Dimension breakdown

[gauravgulati_]

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?

[yuhuisg · Accepted solution]

You can consider looking outside of Analysis Workspace. You have 2 options:

1. ReportBuilder: an add-on for Excel.
2. Data Warehouse: setup and schedule CSV exports that can be sent to email or FTP.

I think Data Warehouse will be a better option for you.

[gauravgulati_]

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?

[yuhuisg]

Unfortunately, the short answer is "no". You're always going to face the problem where you have to breakdown one value by one value. That's why I recommended Data Warehouse: you only need to specify the dimensions, and DW will know how to breakdown all of the values.