Question: How do you place the sum total of a report at the bottom without using the Tree reverse functionality?
Answer Reverse descendants and reverse children options will accomplish this. Source: Office Hours 2020-05-17 Partner Enablement
Knowledge Base Articles
Question: Is there a way to see individual account layers within a hierarchy?
Answer Yes, if you would like to see the children members at lower layers of account structure you can for example: “children.children.children” to accomplish this. Additionally, you can leverage text values on the members you’d like to retrieve and ...
Question: Where and how can default formatting be set for reporting purposes, is there a way to format “Empty” to retrieve “0” instead?
Answer Yes, default report formatting for Cube Views, PDFs, and Excel can be set in a number of different places. Application Settings – Sets default formatting across the entire application Cube View Settings – Sets the formatting specific to the cu...
Question: Are there any updates on merge and center on headers for cube views?
Question(cont) For example, center months across six columns. Answer It has been approved and is in development. The expected release for this enhancement is expected in one of the quarter releases in 2020. Source: Office Hours 2020-05-17 Partner Ena...
Is 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
Is it possible to wrap text in a column header and change its width within a Cube View?
Answer Text wrapping is not currently available within a Cube View itself. This functionality is offered in Excel or within a grid view component showing next to the data explorer then set word wrapping on the grid view within a dashboard. Source: Of...
How do you adjust the default expansion for rows within Cube Views?
Answer This can be found under cube view properties > Formatting > header format. Source: Office Hours 2020-05-17 Partner Enablement
Question: Is there a way to suppress members in a nested row definition so they don’t repeat themselves, while maintaining the expand and collapse?
Answer No, you will need to define multiple row definitions to accomplish this but you will not be able to keep the expand or collapse definition. Source: Office Hours 2020-05-17 Partner Enablement
Question: Is there a way to keep intentional blank rows when using the toggle suppression setting?
Answer Currently, there is no way to keep blank rows when toggling the suppression settings. A workaround for this would be to hardcode a number in the member filter of a row. The screen shots below show how to hardcode “.0000001” for all cells in th...
Question: Is there a way to have a cube view dynamically display only the valid constraint members of the account dimension? The accounts and the cube views are all in the rows.
Answer There is a setting in the cube view that can be turned on that will only display valid intersections. Source: Office Hours 2020-04-09 Partner Enablement
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) Re...
How can you adjust the column width on cube views?
Answer For the Row Header width: This can be found under General Settings > Header Size, and can be either set to a specific width, or –1 for default sizing. Needs to be set independently for Data Explorer, Excel & Report modes.For the Column width: ...
Can I set Application wide defaults for Formatting Cube Views in Excel?
Answer No, the Application Properties (found on the Applications Tab in OneStream), contain settings for 'Standard Reports' but these only apply to the Data Explorer and cannot be set for Excel or Report mode. It is recommended to created standard Ex...
Question: Is it possible to see statistical data as 3-month average, for example, if the Quarter is selected as the time period?
Answer For most situations, this would most likely require either A dynamic UD8 calculation against the statistical account, or A Cube View data helper rule called within the cube view to display the desired results Source: Office Hours 2020-01-31 Pa...
Question: In a Cube View heading, how can I include the last day of the month as the time description in a page caption (e.g., display "as at 30 September 2020" instead of "September 2020“)?
Answer Assuming that the date being shown is always the last day of the month and the client is using calendar months, it is possible to use XFBR string rule to call a function to get the number of days in the month. Source: Office Hours 2020-01-17 P...
Question: How do I extract register data to Excel? The register has a lot of text fields and unstructured data that is not suitable for storage in a cube. How can I extract the register data for analysis in Excel, without the data going through a financial cube?
Answer Option 1 – Instead of using the register in specialty solutions, a ‘lighter’ option would be to use the data import staging area, where you can use attribute columns for text. This is set on the cube settings, where you can enable additional a...
Question: Is it possible to sort the product by the account data value “Sales” and have the product with the greatest sales first etc.?
Question (Cont) A Cube View was created which has a row defined as S#ACT “Actuals” and a Column defined as U1#Product.Children. An Advanced Chart was created with the Diagram Type = XY2D, Swap Axes set to True and Type is Bar Stacked. Otherwise, defa...
Is there a way to suppress a row in a cube view based on values in another row using conditional formatting?
Answer It is not possible to do this using conditional formatting. However, it IS possible using Cube View Extender rules.
Question: When you have the CV row syntax A#BalanceSheet.Tree, will it show the account detail into the division cubes?
Question When you have multiple cubes (Corp cube with 2 extended cubes)…With cube views, can you view all levels of accounts from the top Corp cube, down through the 2 division cubes in one column of a CV? Example: When you have the CV row syntax A#B...
Question: How can I perform Cube View calculations against hidden columns?
Answer •When this question was posed, there were some workarounds involving the use of row/column overrides. •However, with the release of 6.0.0 (March 2020), you can now create calculations against hidden rows/columns Source: Office Hours 2019-07-11
