Can you give an example of the best way to sum a row from a cube view? For example, if I add two rows to a cube view, one with a selection of members, how do I make the second row a custom sum of the first? I know one way to do it, but I don’t love it, I would love to see what else you guys recommend.
Clarification – this is referring to using Cube View Row/Column math when members expansions are in use. Answer No “elegant” ways to address this currently – options are: Avoid using member filters (i.e., break the source rows down to more detail) Replicate the member filter in a GetDataCell function on the total row Create a CV Helper function to return the same thing Enhancement Status: There have been numerous enhancement requests to allow CV Row/Column math to work against member expansions, as well as suppressed rows/columns. These have all been approved by Development and should be in one of the upcoming quarterly releases in 2020. Source: Office Hours 2020-03-26 Partner EnablementQuestion: Are there any learning materials to help when setting up a new application (in addition to the training materials)? As a new partner, we're spending some time to build an application to understand the interdependencies but is there anything which defines what order things need to be set up?
Answer Attached is a sample project plan showing the typical build activities and the ordering of such. Source: Office Hours 2020-01-17 Partner Enablement
Question: Is there a way to report the total of a group of members based on a text attribute with multiple dimensions in a row?
Question (cont) The example below is for an operating expense that I want to be filtered using a text property of “HP” (a specific business line). I thought the following would work, but it is still pulling in the total company business line, not just a total of the “HP” UD3 members. A#Marketing:U1#TotalBU:U2#Top:U3#CustomerGroup_0002.Base.Where(Text1 contains HP):Name(Market) I don’t need an expansion of the customers (UD3) but a total of the relevant members. Answer Using CVR Math in a cubeview row will not work in this situation. CVR Math Example A Dashboard XFBR String will be needed to aggregate the members with the Text property to produce a total. XFBR Example Source: Office Hours 2021-02-04 - Partner EnablementIs there a list of valid font families for Cube Views?
Answer Standard Microsoft supported fonts are utilized in OneStream Source: Office Hours 2020-05-17 Partner Enablement Update 07/02/2024 Note that one can use any font that has been installed in Windows on the OneStream servers. The interface only lists a subset of fonts produced by standard Microsoft libraries; but in recent versions any font can be invoked simply by using the FontFamily formatting property: FontFamily = [My Custom Font Name]Question: Regarding the Clear Calculated Data Function, is it possible to clear just select base or intermediate members of a parent member? This is in an effort to not clear the entire dimension but just a subset of data.
Question Answer •Please see OneStream Software's Knowledge base article related to how to clear the Data Cells in a Specific Data Buffer: https://onestreamsoftware.service-now.com/sp?id=kb_article&sys_id=abcf0fc6db0bc410ea2c25894b96192f •When clearing an intersection using custom calculation rules the very first step clears previously calculated data. This often times gets leveraged for seeding purposes when the data has been flagged as “durable.” •Often times when you leverage custom calcs for planning purposes, you’ll want to set the data flag to “durable” so this calculated data doesn’t get cleared out during a consolidation. Source: Office Hours 05-21-2020Question: How do you run a consolidation, or a force calculate, in a business rule? I’m copying data into another scenario and then want to calculate the member formulas in the account dimension.
Answer Rather than triggering a calculation/consolidation from the business rule, consider adding it as a second step in a data management sequence instead (for example after the ‘data copy’ custom calculation step). Otherwise, one can create a calculation/consolidation step as part of a separate data management job that can then be called using a business rule. A data management job can be called within a business rule using one of the following commands: StartDataMgmtSequence – start the sequence in the background and move to the next line of code in the business rule ExecuteDataMgmtSequence – start the sequence and wait for it to finish before moving to the next line of code in the business rule QueueDataMgmtSequence – like StartDataMgmtSequence but creates a queued task that will be considered by all the data management servers not just the server that is running the business rule. Source: Office Hours 2020-7-2 - Partner EnablementThe customer would like for users to be able to process/approve/post journals, but have these three steps completed by different users for each journal? Thus, journals should have segregation of duties. How can we accomplish that?
Answer If users are allowed to process, approve and post journals, then the only way to accomplish this would be through a Journal Event Handler rule.
