Calculate if No Data
Have you ever wondered how theCalculate if No Data setting works? (I did, and Keith Berry helped me out) “Calculate if No Data = False” prevents the execution of rules on “OK,NA” (no data) entity. However, the Calc Status gets changed from “OK,NA” to “OK”, and it impacts the parent (“CN”). The “False” option is to avoid populating unused entities with rules. Calculate on “OK,NA” Force Calculate on “OK,NA” Calculate if No Data = True No rule execution No change in Calc Status Rule is run Calc Status changes to “OK” Parent becomes “CN” Calculate if No Data = False No rule execution No change in Calc Status No rule execution Calc Status changes to “OK” Parent becomes “CN”Ho to extract a hierarchy for any dimension in Level format in OneStream?
Originally posted by Vignesh Mohan Hi, How can we extract the hierarchy of any dimension in an excel in a Level based format starting from top most level to the bottom most level for every base member ? Basically I do not want a Parent-Child format extract. Please find the attachments for the sample screen shot.
Cube View - Split Delimited Stored Item Text into Separate Columns
Hello - I have a cube view that currently has two columns. The first is just base members of an account hierarchy, and the second is a dynamic calc UD8 that retrieves the text 5 value for each account stored by scenario type. The UD8 is working and pulling the correct text 5 values, however some but not all of the stored item text is delimited by semicolons. How can I split this text by semicolon into separate columns in the cube view?
Data Refresh between applications for on-premise
Hello experts, How can we copy just data from an application to another? We have an on-premise setup and would like to copy data from prod environment to lower environment application. I know we can do simply do entire DB copy for that application, but it'll replace everything (like app artefacts). Is there a way we can just copy underlying data of an application? I noticed some data tables (BinaryData20xx, DataRecord20xx), but not sure if simply copying them will work. Thanks, Gaurav
