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's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
3 years ago

How 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...
Cube View
Reports
AndyR's avatar
AndyR
New Contributor III
3 years ago

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