The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
OSAdmin
OneStream Employee
3 years agoHow to overview changes in EntityDim?
Hi all,
Does anyone know how to easily overview changes in the EntityDim in terms of Percent Consolidation and Percent Owenership between periods and years? Can this be extracted in a prebuilt repo...
AndyR
3 years agoNew Contributor III
Hi Fredrik,
In a Cube View there are member property formulas you can use. Under the samples there are three examples.
XFMemberProperty(DimType=Account, Member=Sales, Property=AccountType)
XFMemberProperty(DimType=Account, Member=|MFAccount|, Property=Text1, VaryByScenarioType=[], VaryByTime=[])
XFMemberProperty(DimType=Time, Member=|MFTime|, Property=Description, TimeDimProfile=Standard)
Alternatively in Excel you can use XFGetRelationshipProperty formulas with potential property arguments including:
AggregationWeight
ParentSortOrder
PercentConsolidation
PercentOwnership
OwnershipType
Text1
Text2
Text3
Text4
Text5
Text6
Text7
Text8
Thanks,
Andy
Related Content
- 2 years ago
- 2 years ago
- 2 years ago