Report Builder Limitations | Community
Skip to main content
jeff_bloomer
Community Advisor and Adobe Champion
jeff_bloomerCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
October 16, 2015
Solved

Report Builder Limitations

  • October 16, 2015
  • 6 replies
  • 4217 views

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?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by BrianAu1

    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

    6 replies

    B
    Adobe Employee
    BrianAu1Adobe EmployeeAccepted solution
    Adobe Employee
    October 16, 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

      jeff_bloomer
      Community Advisor and Adobe Champion
      jeff_bloomerCommunity Advisor and Adobe ChampionAuthor
      Community Advisor and Adobe Champion
      October 16, 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!

      jeff_bloomer
      Community Advisor and Adobe Champion
      jeff_bloomerCommunity Advisor and Adobe ChampionAuthor
      Community Advisor and Adobe Champion
      October 16, 2015

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

      I
      imene_drir
      October 16, 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.

      jeff_bloomer
      Community Advisor and Adobe Champion
      jeff_bloomerCommunity Advisor and Adobe ChampionAuthor
      Community Advisor and Adobe Champion
      October 16, 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.

      Terms & ConditionsAccessibility statement

      Loading footer...