help improve performance of bar chart using AGGR() and cycle groups
I have a bar chart with 2 dimensions, first- a cycle group that includes payment category fields (4 different levels of granularity), procedure code, and primary and secondary diagnosis. The second dimension groups the bars into 3 different organization types.
The expression of this chart measures utilization PMPY for the cycle group (PaymentCatClmTypeDx2) using this code-
The chart is frozen during the load and not loading. Occassionally, after a very long period of time the chart will load but making any selections causes the entire application to freeze again. What can I do to improve performance? Is this too much for a QliKView chart to handle?
I'm not sure someone could help you without understanding of your model (this depends on many parameters including data scheme, data size, length of inter-table links, etc.), but general recommendation of best practices regarding performance says to perform all possible calculations in a load script.
So I'd recommend you to think about pre-calculation of neccesary values for the dimension(s).
Is there a function that does the equivalent in the load script? I am using aggregation that changes for each cycle group so I don't see how this can be computed correctly in the load script. I tried moving this back to SAS (where I created my input datasets), but the aggregation is static and was incorrect because it did not update correctly when my filters changed.