I have a query regarding multiple dynamic selection on one Screen:
I have several charts, KPIs and data sets on one screen. Some of those should have a filter on the currenty Year, some current month and some current day. I know that the possibility exists to build cubes with such selection. However it seems to me like a huge work arround for the problem at hand.
I can manually fix the selection. However is there any possibilty of somehow selecting a dynamic filter taking the current date as reference, without having to build cubes for each label?
I would appreciate your help on the Topic!