Dimension breakdown

Avatar

Avatar
Level 1
gauravgulati_
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
gauravgulati_
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

0 solutions
View profile
gauravgulati_
Level 1

03-06-2021

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?

View Entire Topic

Avatar

Avatar
Publish 1
MVP
yuhuisg
MVP

Likes

200 likes

Total Posts

608 posts

Correct reply

122 solutions
Top badges earned
Publish 1
Affirm 100
Springboard
Bedrock
Validate 1
View profile

Avatar
Publish 1
MVP
yuhuisg
MVP

Likes

200 likes

Total Posts

608 posts

Correct reply

122 solutions
Top badges earned
Publish 1
Affirm 100
Springboard
Bedrock
Validate 1
View profile
yuhuisg
MVP

03-06-2021

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.