Expand my Community achievements bar.

Webinar: Adobe Customer Journey Analytics Product Innovations: A Quarterly Overview. Come learn for the Adobe Analytics Product team who will be covering AJO reporting, Graph-based Stitching, guided analysis for CJA, and more!
SOLVED

Report Builder Limitations

Avatar

Community Advisor

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?

Jeff Bloomer
1 Accepted Solution

Avatar

Correct answer by
Employee

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

View solution in original post

6 Replies

Avatar

Correct answer by
Employee

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

Avatar

Community Advisor

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!

Jeff Bloomer

Avatar

Community Advisor

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

Jeff Bloomer

Avatar

Level 1

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

Community Advisor

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.

Jeff Bloomer