Dimension breakdown | Community
Skip to main content
gauravgulati_
New Participant
Jun 3, 2021 8:17 AM UTC
Solved

Dimension breakdown

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
yuhuisg
yuhuisgAccepted solution
New Participant
Jun 3, 2021 8:32 AM UTC

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.

View reply

3 replies

yuhuisg
yuhuisgAccepted solution
New Participant
Jun 3, 2021 8:32 AM UTC

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.

Translate
gauravgulati_Author
New Participant
Jun 3, 2021 12:13 PM UTC

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?

Translate
Terms & ConditionsAccessibility statement

Loading footer...