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
BedrockMission!

Learn More

View all

Sign in to view all badges

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Publish 1
MVP
yuhuisg
MVP

Likes

182 likes

Total Posts

560 posts

Correct Reply

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

Avatar
Publish 1
MVP
yuhuisg
MVP

Likes

182 likes

Total Posts

560 posts

Correct Reply

107 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.