Show formula of Account type DynamicCalc
Hello ... We are trying to output the formula for Accounts of type DynamicCalc in a cube using an U8 member named U8#AccountFormula. In this member we have defined the following: Return api.Account.Formula(api.Pov.Account.MemberId,API.Pov.Scenario.MemberID,Api.Pov.Time.MemberId) The code above only seems to work for all Accounts except type DynamicCalc Is there another function we should be leveraging? ThanksV#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
