OneStream Community

coneill · 04-15-2022

GOALExport cube view to Excel with Landscape printing orientation. METHODThere is a cube view setting on the Advanced tab, labeled as Landscape = True/False. I have set that setting to Landscape = True. RESULTAfter exporting to Excel, the cube view f...

coneill · 01-26-2023

I had the same question! This is what I found worked:1) In Data Sources, point the Amount to a row validator column*. This will NOT be the debit or credit amount column of data if that column might contain a zero for a valid row.2) Update the 'Logica...

coneill · 10-12-2022

As Andy points out, you can create a Quick View to surface the entity properties.Another quick and dirty answer is simply to:1. View the Entity dimension in grid view.2. Display Parent Child Relationships = Yes.3. Grid Columns To Display = Name, Pare...

coneill · 10-11-2022

The formula is simply:Return 1The account attributes are:Account Type = BalanceFormula Type = DynamicCalcAllow Input = FalseIs Consolidated = False

coneill · 10-11-2022

CHOICE 1 You can move the scenario column after the account column to trigger the repeating of the Actual label. But this may not be the look you are going for.CHOICE 21. Make a UDx parameter of the Scenario and Account names..2. Exclude header rows ...

coneill · 10-11-2022

This might help. I use a counting account called One. It is a dynamic calc account with the formula: Return 1. I use it in reports. I might report on entities E#West.Base and if I include the A#One account, it will tally the number of members display...

OneStream Community

User Statistics

User Activity

Export a Cube View to Excel in Landscape Orientation

Re: Has anyone ever had a data source that is two columns for the amount and they have to be added t

Re: How to overview changes in EntityDim?

Re: Dynamic Calc to Increase Column Value by 1

Re: Turn off suppression of repeated member names in a Cube View

Re: Dynamic Calc to Increase Column Value by 1