Forum Discussion

MarkHoughton's avatar
MarkHoughton
Contributor
3 months ago

Help required troubleshooting a Report Book not processing in Excel

Hi, I have a Book that is not creating any data in Excel, it is supposed to loop through all entities. I know that there is data in the system that should populate the Book because I can retrieve s...
annotations
Cube View
Reports
db_pdx's avatar
db_pdx
Valued Contributor
3 months ago

Hi Mark: a few things to check:

  • Can you run the cube view directly and export to Excel? Note all the parameters that are requested, especially if there are any dependent parameters.
  • Double check that the parameters you documented are spelled correctly in your Change Parameter sections of the Report Book
  • Lastly, try running the cube view in a new Report Book with no loops; again, to ensure its working. This would help narrow down that it is a Loop/Change Parameter issue vs a more fundamental cube view issue.

Hope this helps.   -db