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 ...
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(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...
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...
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...
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...
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: ...
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...
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...
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...
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 (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...
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...
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