Sign in to Community
Sign in to view all badges
I want to create a report for a quarter.
1) This should contain data for every day.
2) For every date, the drill-down should be Dimension1>Dimension2>Dimension3
The challenge here is that it is very time-consuming to drill down 3 sublevels for 90 days. It has to be done manually every single day. Is there any automated way of achieving this?
You can consider looking outside of Analysis Workspace. You have 2 options:
I think Data Warehouse will be a better option for you.