Accessing User Entered Data on a Dashboard CubeView
I have a dashboard with a cubeview. The user is allowed to enter data into multiple cells and then save. I have a save event handler to verify the data entered, however, I cannot access all of the information at one time. The event handler provides access to one cell at a time. Also,within each row I have a cell where users may change the numeric value and another where they type in an annotation. Changes to the numeric value cells will fire the event handler however changes to the annotation cells alone will not trigger the event handler. Is there any way to access the entire cubeview pre saved data to verify entries. I need to know that if a user entered a value that they also entered an annotation or if the user removed an annotation where a numeric value existed on that row.
Setting up default value in the combo box for Cube View
Hi Everyone, We recently received a request from the client to set up a default value in the combo box for the cube view. The cells are set with type Annotations and has a dropdown of options to be selected. The client wants to default the dropdown as PctBudget until and unless it is changed. Is there a configurable setting that can be used to achieve that? I used the default value/members under parameters but it didn't help the cause. Thanks in advance! Pragyanshu JackLacavaHenning
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!
