Problem exporting reports through Ad Hoc | Community
Skip to main content
maxg72951070
May 16, 2016
Solved

Problem exporting reports through Ad Hoc

  • May 16, 2016
  • 1 reply
  • 924 views

Hello,

I'm trying to set up a daily scheduled report through Ad Hoc but there seems to be a bug with the formatting. 

For instance, when I log in on Ad Hoc, the default view shows no other rows than the time granularity (Day, week, month, etc.). To get my additional dimensions I have to press the "Replace tables" button. 

This is causing a problem with the automatic delivery method since it seems like Ad Hoc is extracting the default view of the report and not the manually updated one (once I click "replace table"). This causes all my daily updated reports to be missing all their dimensions. 

I've taken screenshots of the process to further explain my point:

This is my default Ad Hoc view once I log in. As you can see, I'm missing the "Regions" dimension.

Now if I press "Replace Tables"

I'm getting the final version (the one that I ideally want to be automatically exported to my data analytic platform) 

 

Am I the only one experiencing this issue? 

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 andreim46534007

I have a similar issue, but the interesting thing is that it works only for several line items, I broke down year by other dimensions and set up 12 break downs for year but it does for first three months only, when I update the table manually it works perfect and shows data for all passed months.  

1 reply

andreim46534007Accepted solution
July 9, 2018

I have a similar issue, but the interesting thing is that it works only for several line items, I broke down year by other dimensions and set up 12 break downs for year but it does for first three months only, when I update the table manually it works perfect and shows data for all passed months.