Report Builder Limitations

Avatar

Avatar
Springboard
Level 7
jeff_bloomer
Level 7

Likes

146 likes

Total Posts

222 posts

Correct reply

16 solutions
Top badges earned
Springboard
Validate 10
Validate 1
Contributor
Shape 1
View profile

Avatar
Springboard
Level 7
jeff_bloomer
Level 7

Likes

146 likes

Total Posts

222 posts

Correct reply

16 solutions
Top badges earned
Springboard
Validate 10
Validate 1
Contributor
Shape 1
View profile
jeff_bloomer
Level 7

15-10-2015

I seem to be running into limitations very quickly with row labels for a report I want to run in Report Builder.  It appears that I'm only able to add two or three dimensions at the most for a single metric, and then I'm done.  Am I really limited to running a report out of the Data Warehouse and not from Report Builder.  If so, what's the purpose in having report builder?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 50
Level 7
brian_au
Level 7

Likes

69 likes

Total Posts

303 posts

Correct reply

193 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Boost 50
Level 7
brian_au
Level 7

Likes

69 likes

Total Posts

303 posts

Correct reply

193 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile
brian_au
Level 7

15-10-2015

Hi Jeff,

Report Builder utilizes the Adobe Analytics API within Excel and should be on par with what you can pull in Reports & Analytics (formerly SiteCatalyst). The purpose of Report Builder is to allow for Reports & Analytics data to be pulled direct into Excel spreadsheets with potential for dynamic cell references, custom formulas, and Excel graphs/charts. Data Warehouse can run off the raw data which allows for more dimension breakdowns and it is intended to be a data extract tool. You may need to work with the raw clickstream feed or Data Warehouse to meet your reporting needs.

http://microsite.omniture.com/t2/help/en_US/arb/
http://microsite.omniture.com/t2/help/en_US/reference/data_warehouse.html

http://microsite.omniture.com/t2/help/en_US/sc/clickstream/home.html

Best,

Brian

Answers (5)

Answers (5)

Avatar

Avatar
Boost 50
Level 7
brian_au
Level 7

Likes

69 likes

Total Posts

303 posts

Correct reply

193 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Boost 50
Level 7
brian_au
Level 7

Likes

69 likes

Total Posts

303 posts

Correct reply

193 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile
brian_au
Level 7

15-10-2015

Avatar

Avatar
Springboard
Level 7
jeff_bloomer
Level 7

Likes

146 likes

Total Posts

222 posts

Correct reply

16 solutions
Top badges earned
Springboard
Validate 10
Validate 1
Contributor
Shape 1
View profile

Avatar
Springboard
Level 7
jeff_bloomer
Level 7

Likes

146 likes

Total Posts

222 posts

Correct reply

16 solutions
Top badges earned
Springboard
Validate 10
Validate 1
Contributor
Shape 1
View profile
jeff_bloomer
Level 7

15-10-2015

I saw this option as well.  The one problem with the DW request is the time involved in waiting for it to arrive.  If it was real-time like Report Builder, it wouldn't be an issue.   Thanks for the advice, though.  I appreciate it.

Avatar

Avatar
Boost 1
Level 1
imene_drir
Level 1

Likes

2 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Boost 1
Applaud 5
Applaud 25
View profile

Avatar
Boost 1
Level 1
imene_drir
Level 1

Likes

2 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Boost 1
Applaud 5
Applaud 25
View profile
imene_drir
Level 1

15-10-2015

Jeff, you can get a DW request in tableau format and be done with it (of course doable only if you have tableau which is worth it). For the data feeds, they can be humoungous but unless you really need to dig at the hit level data and are looking at building a DB or find a discrepancy, it's a waste of your time unless, then again you might get enjoy having all the benefits of the raw data. If you just want multiple dimensions, a bunch of metrics as per your above request, then yeah data warehouse is the right choice + Tableau for visualization.

Avatar

Avatar
Springboard
Level 7
jeff_bloomer
Level 7

Likes

146 likes

Total Posts

222 posts

Correct reply

16 solutions
Top badges earned
Springboard
Validate 10
Validate 1
Contributor
Shape 1
View profile

Avatar
Springboard
Level 7
jeff_bloomer
Level 7

Likes

146 likes

Total Posts

222 posts

Correct reply

16 solutions
Top badges earned
Springboard
Validate 10
Validate 1
Contributor
Shape 1
View profile
jeff_bloomer
Level 7

15-10-2015

Very much appreciated for the assistance.  This will help a lot.  Thanks again!

Avatar

Avatar
Springboard
Level 7
jeff_bloomer
Level 7

Likes

146 likes

Total Posts

222 posts

Correct reply

16 solutions
Top badges earned
Springboard
Validate 10
Validate 1
Contributor
Shape 1
View profile

Avatar
Springboard
Level 7
jeff_bloomer
Level 7

Likes

146 likes

Total Posts

222 posts

Correct reply

16 solutions
Top badges earned
Springboard
Validate 10
Validate 1
Contributor
Shape 1
View profile
jeff_bloomer
Level 7

15-10-2015

I appreciate what you're saying, but it sure is frustrating to have a tool that is not as robust.  It would make things a lot easier if Report Builder worked with the same functionality of the Data Warehouse request instead, but without the 24 hour wait.  It's much harder to build reports from the true raw data feed as it is not joined in any way.  That being said, are you aware of any documentation out there containing best practices for leveraging the raw data stream in something like a large relational database?  Thanks!