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...
Forum Discussion
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