I'm developing a financial reporting dashboard that has a template containing 202 lines. I have created variables for each line, and use the variables using pick and match for each line in the front end.
The dashboard behaves too slow with this approach. for each selection it takes 10 mins to give the results. Does anyone have a better approach?
Such stuff shouldn't be attempted within the UI else being resolved against native dimensions within the data-model respectively just transferring the hierarchically P&L structure from the ETL system. Any overlapping from values against several higher dimension-values could be addressed with an as-of-table. And in the end a simple: sum(value) as expression should be enough.
