OneStream Community

JenJessel · 02-19-2024

I am looking for a way to run a report for all time periods on percent consolidation. Currently the only way I know how to do this is by running a grid view of for each month. Does anyone know a more efficient solution?

JenJessel · 02-18-2024

I am trying to get prior year actuals in the same column as current year actuals. The code i am using in the CV is above. This result pulling back in YTD prior year but I want monthly value for prior year.

JenJessel · 06-29-2023

Does anyone know how to add more than 2 custom titles on a row? Below is the view of 4 headers. I can change the name on 2 but not 3 of these titles.Member filters are below. I have custom name at the end of my Time and Scenario member filters. I wan...

JenJessel · 04-05-2023

I am trying to create a Cube View that has 2 GetDataCell formulas. The formulas work separately but if I add them both to the same Cube View, one will not work. I am using XFBR in Columns (Time) and GetDataCell in Rows (Accounts). Is there a way both...

JenJessel · 02-08-2023

Looking for help to display Text data in a cube view. I'm using the member filter below which works for every account type EXCEPT DynamicCalc. Account Type set under Settings in the Member Properties (see below). U8#Acct_Text3:V#Annotation

JenJessel · 02-20-2024

Thanks Carlos. We created a UD8 prioryearperiod dynamic calc which is working.

JenJessel · 02-20-2024

Thank you.  Will try this.

JenJessel · 02-19-2024

Thanks Carlos. This is closer. It is giving me a monthly result, however it is pulling back Dec Prior year for each month. I was trying to get prior year monthly results for each month.

JenJessel · 01-22-2024

I added the following code to the end of my formula as I was trying to pull back the text data in Text3 as well as the formula I had before code. Dim accountId As Integer = api.Pov.account.MemberId Dim accountText3 As String = api.account.Text(accoun...

JenJessel · 06-30-2023

I am sorry, you are correct. I am referring to columns. In my Cube View, I have 4 headers as follows:I want to change the header name for 3 of the header dimension types (scenario, time and view). If I add another manual name in the column, I get an ...

OneStream Community

User Statistics

User Activity

Percent Consolidation

Cube Views Column & Row time intersection

Cube View Column Headers custom titles for multiple rows

Cube Views with multiple GetDataCell formulas

Text Values in Cubeview

Re: Cube Views Column & Row time intersection

Re: Percent Consolidation

Re: Cube Views Column & Row time intersection

Re: Text Values in Cubeview

Re: Cube View Column Headers custom titles for multiple rows