Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Coffee Break: Join us on Wednesday, April 5th at 10am PT to chat with Ben Gaines, Director of Product Management for Adobe Analytics. Ben will be online to answer your Analytics and Adobe Summit questions.

Dimension breakdown


Level 1

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?

3 Replies


Community Advisor

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.


Level 1

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?


Community Advisor
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.