Forum Discussion
Slow switch measure
Hello, I was wondering if somebody has found a working solution for the slow switch statement problem? For my dashboard I would like to switch between over 100 measures (I call this the base m...
but the agregation table dont related to the dimensional , when you set a aggregation its only linked to the fact table it will be using, aggregation tables arent used to do actual reporteing they are a backend lets say solution that speed up the information requestedon the fact table by the reports. or related to the dimensions itself as part of the table all depends on the approach
the only cons of aggregation tables lets say its they will growth the model size depending on the amount of data on it.
Oh, I understand now. Thank you for this clarification!