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 single entities as CubeViews into Excel direct with their correct data.

I have created other Book loop definitions this morning for other CubeViews and they have generated correctly, I even tried copying and renaming the variable elements from the ones I have created ( that do work ) but it will not export to Excel anything other than a blank tab for this particular CubeView.

What else could be causing it to fail ? 

Our "Loop" settings for ALL books is identical. The "If Statement" tab only varies by the account name ( copied and pasted so not incorrectly entered ). The "Change Parameters" tab is identical for ALL books. Finally the "Excel Export Item" tab has the cubeview name as "Name" and is connected in the CubeViewName field, output name is identical in ALL books.

I have more complex Books that generate, which pull in multiple UDs, but this one; it does contain an Annotation data column; which is possibly the only variation from the other books. Could that be the reason ?

Appreciate any guidance on this.

Cheers

Mark

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