Table of Contents Cube View to include when running a Book
We have a user that runs a number of books whose Excel results contain dozens of sheets in a single Excel workbook. The user is asking whether it is possible to create a 'Table of Contents" cube view that will show up at the beginning of the Workbook and contain hyperlinks to each sheet in the workbook. This would allow all users who reference this workbook to more easily scroll to the particular sheets of interests. Does anyone know if this is even possible?
Any way to set Excel Freeze Pane settings from within a cube view?
Originally posted by Darryl Gerrow We have a number of cube views that we automate delivery to Excel using Books, but would like to know if there is a way to set the Excel Freeze Pane settings in the cube view itself so that users don't have to set it when they receive the Book?
Open File with Prompt from Dashboard Button
Hello, I have created a button that opens a Book from File Explorer. This particular book requires prompts to run correctly, but when running the Book from the button, it skips the prompt dialog and runs with errors. Is there a way to have the button ask for the prompts before running the book? Thanks!
Book - Pass Input Parameter to Loop?
Is there a way to pass the Required Input Parameters for a book into a loop? For example if the users picks 2024M3 for time I want to be able to produce a report for that period as well as a report for -3 months and -12 months. I can get T#POV, T#PovPrior3, T#POVPrior12 to work but I would like to use the input time instead.
Display Parameters with their description in report
Hi, I am wanting to show the scale of dollars in a report, I have the parameter |!Divisor!| which has display items as Whole Numbers, Thousands, Millions, and Billions. When I use that parameter in a report instead of showing the display items it shows the value items which are 0, 3, 6, and 9. Thank you, Jeremy Morgan
