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.
Is there any possible way to do it in workspace analysis? Since the metrics are to be fetched for each day of the quarter, with a 4 level drill down, it becomes time-consuming and repetitive manual task. Is there a better way to do this?