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
Displaying Text Values in QuickView
Is there a way to retrieve the Text field value in QuickView along with the $ values on the trended time report. The Country values are available in Text1 of the Entity Dimensions also have created a UD8 member formula to retrieve the values. But unable to retrieve both Country and $ values in one single Quick view. Below is the format of the QuickView report. Where Country details can be retrieved from the U8#ENT_COUNTRY:V#Annotation:Name(Country). Any Idea?
Annotation Column Order
Hi all, I'm trying to create a CV with: - row1 Account.base and UD1.base - column1 Dynamic Annotation that return the Account description - column2 Entity the output with this structure is: Ent Acc UD1 DescAcc 10 Do you know if there is a way to have the following output Acc DescAcc UD1 ? so put the description near the account code (I use the Annotation since I would like to have the account description in a specific column) without move the UD1 before the Account in row? Thank You!
Anyone collecting capex information in cubeviews? Is this possible?
Hi there, we are trying to figure out a way of collecting capex project information in OS inside a user friendly form (not capital planning register). Wonder if anyone else is doing it and how you are accomplishing this? Trying to figure out how to allow users to enter project number and name without creating metadata for each project in one of the dimensions ahead of time or if there is an easy way to accomplish this. The information we need to collect is really minimal, number, name, description, amount per year and a classification in one of three buckets.
