Code: Select all
['Amount'] = N:DB('Forecast',
ATTRS('dimVersion', !dimVersion, 'Previous Version'),
DB('dimVersion', !dimVersion, 'hier.CostCenters') | ':' | ElementAttrS('dimCostCenters', DB('dimVersion', !dimVersion, 'hier.CostCenters'), !dimCostCenters, 'OrgConsolidation'),
DB('dimVersion', !dimVersion, 'hier.Accounts') | ':' | ElementAttrS('dimAccounts', DB('dimVersion', !dimVersion, 'hier.Accounts'), !dimAccounts, 'SpreadCalcElement'),
'2018 YTG 05',
'Effective');
In this particular case, we may be able to populate the cube with a TI, but we have some other cubes depending on being able to do this with rules. It seems like concatenation would be highly undesirable in terms of cube performance. Am I right to be concerned? Is there a better idea?