Hi Everyone,
I have a report (403b) i have been building and adding features too as I learn and want to know if it could be optimized in report studio. It is currently at 5 minutes and I want to add comparisons to the prior month. I tried some of the property panels but was not able to notice a difference and I am not sure if I am doing it correctly. (Concurrent, Use sql with clause, Data Base only, Join filter to in). At the description level these seemed easy to understand but they didn't work enough to notice.
The report has 3 main queries + prompt queries + render features. The 3 main queries are Gross earnings, Point in Time for EE Status and Point in Time for Dept. I used 2 joins 0:1 on both sides to create the final query with the correct amounts. A picture of the queries is attached.
Any tips or better articles to read would be greatly appreciated. Or if this seems like an appropriate time for this. I don't have much to compare it too. I am working in UKG, IBM Cognos Analytics with Watson 11.2.4