Forum Discussion

Mustafa_A's avatar
Mustafa_A
Contributor II
3 years ago

Cubeview - Looping multiple entities into one Excel file?

How do I generate reports in a loop for each member (branches) and send it to single excel file? I have a cube view report which I'm trying to run for multiple entities member (100+ locations). Any i...
Books
Cube View
Mustafa_A's avatar
Mustafa_A
Contributor II
3 years ago

I may be misinterpreting this feature. But I notice that there is an Excel file add-on. I can not seem to preview the result. It might be due a wrong file extension I'm using (see below)

 

But could that work? 

 

Thank you

db_pdx's avatar
db_pdx
Valued Contributor
3 years ago

I believe the file extension for the Excel export should be Filename.xfDoc.xlBook.  This is in contrast to the PDF version which is Filename.xfDoc.pdfBook.

I don't get previews for my .xlBook Report Books, but I do for my pdfBooks.  But you can always run the report as a way to preview.  Or start with the .pdfBook version just for purposes of development.

Cheers,

-DB