V#VarianceExplanation - Best Ways to Use
Hi, I'm trying to understand the best way to add annotations and comments in OneStream to explain variances. Last week at splash I was advised to use V#Annotation or V#VarianceExplanation. But what I'm confused about is how do you actually get it connected to the calculated variance (red box), versus only being able to connect it so the actual reported number (yellow box). Right now I'm using a get data formula in my quick view to calculate the variance (GetDataCell(S#Actual-S#AOP):Name(Variance)). What are other people doing when trying to provide commentary on variances? Whats the best way to use this view?
Consolidated Annotations
Hi. Is it possible to make annotations in the UD1 dimension and have them roll up to the respective legal entity (at consolidated level)? A challenge I'm facing is that only specific base members under the UD1 dimension reference the legal entity in the text field. How can I manage this so that only the relevant regions (that reference legal entities) contribute to the commentary at the consolidated level?
Conditional Formatting in Cube view on Annotation members
HI, I am looking for an option to highlight text value in the cube view based on some condition. I have combo box which has parameter which pulling value from one of the DIM Member 1 = United States Member 2 = Canada Member 2 = Not filled If its not filled then I want to highlight red. Is there any option. I tried using XFBR but seems like it run on specific data unit only
Error saving attachment in Cube View
I want to give users the ability to add attachment in the cell with a dynamically calculated UD8 member. Dynamic calculation places the value of 1 into that intersection if the file attachment is present and the value of 0 if there is no attachment. I use these values to change the formatting of the cell if there is an attachment. I am an Admin and I have no problem attaching the file. However, other users are getting the "Error saving data attachment" message. I wonder what governs this and if I can give my users the ability to add attachments to that cell? Any suggestions are appreciated.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
