OneStream Community

ZAH · 04-11-2023

Hello Everyone, Is there a way to force the composite expression to run before the One To One Rules ? i am trying to run a complex expression to override values coming from the Source Data. but the One To One Mapping is triggering the mapping, what i...

ZAH · 01-10-2023

Hello All, I have a cube view in which i am using on the Row Level a GetDataCell Function, example GetDataCell(Account1+ Account2): Name (Trade). on the column level i have a Comment using the V#Annotation:Name(Comments). however, on the GetDataCell ...

Adding a Child to a Base Member · 09-21-2022

Hello All, I need some Quick help . is it possible to create a Child under a Base member that has a value. for example in my UD2 dimension i have Book A1 it is the Base member and it has data in it. If i try to create a Child under this A1 , Child A1...

Member Constraints · 09-05-2022

Hello all . i am trying to display in a cubeview a list of accounts with specific constraints related to FLow , for example i want to display Only accounts with having Flow = EQU . any idea which function to use ? i tried the [Where] clause it didnt ...

Member Filter Flow Selection · 09-01-2022

Hello everyone, Hopefully someone might help . i am trying to create a cube view that will display GL Accounts having specific FLOW criteria . on the rows the i have GL and the columns contain the FLOWS. i have multiple flows configured but each GL h...

ZAH · 04-11-2023

thanks for the help, Christian, but how can include the One-to-One mapping in the Composite rule? is there anything special i have to put in the Rule Expression to map the Source to a Target ?

ZAH · 01-13-2023

I tried it, it doesn't work. the Cell for the Comment stays in Green. (Read Only)

ZAH · 01-10-2023

Hello Toni, I am using a Row Template Cube , the purpose of the cube is for Analytical reporting whereby i just want the users to input some comments over a Caption for Combined Accounts . As if i am calculating a total and asking the user to explain...

Re: Member Contstraints · 09-05-2022

Can i find it somewhere? (BR Formula)i am still new to the OS world . no indentation is not needed . my cube will be for Data Entry purposes only

Re: Member Contstraints · 09-05-2022

Hello Nicolas, i tried this: A#M_BS.Base:Name(XFMemberProperty(DimType=Account, Member=|MFAccount|, Property=FlowConstraint)it displays the flowconstraint for all BS accounts . i want to be able to select Accounts having EQU flow only . in sql it is ...

OneStream Community

User Statistics

User Activity

Complex Complex Expresion in Transformation Rules

Cube View Comments

Adding a Child to a Base Member

Member Constraints

Member Filter Flow Selection

Re: Complex Complex Expresion in Transformation Rules

Re: Cube View Comments

Re: Cube View Comments

Re: Member Contstraints

Re: Member Contstraints