Hello,
I have the following structure in the product dimension
PROD GROUP
-> PROD CAT
-> (PROD CAT) (SUB-CAT)
-> (PROD CAT) (SUB-CAT) (PRODCODE)
I have the code below where TPByCatChild=(PROD CAT) (SUB-CAT) (PRODCODE)
ATTRPUTS(vsubproductname,DimName4,TPByCatChild,'ProdDesc');
And I have a rule that
['Code - Name' ] = S:
!Sub Product v2 | ' - ' | DB('}ElementAttributes_Sub Product v2', !Sub Product v2, 'ProdDesc');
But when I click the alias button the Name column for a few of (PROD CAT) (SUB-CAT) (PRODCODE) becomes *ERR*
Can anyone suggest where I could check to solve this problem?
*ERR* when Alias in turned on
-
- Posts: 16
- Joined: Mon Jan 24, 2011 12:41 pm
- OLAP Product: TM1, Cognos Planning and BI
- Version: 9.5
- Excel Version: 2010
- Location: PoA - Br
Re: *ERR* when Alias in turned on
Hello,
If your dimension attributes are loading as *ERR* there's probably an error in the Rule.
I never saw this *ERR* in different places than the cubes on cells where I used a rule and there was a logic error.
Take a look at your cube maybe you need to convert numbers to string to concatenate (not only using S:) or some cells have erroneous values.
If yet you can't solve this, used the Control Objects, by clicking in View > Display Control Objects and look for a Cube with name like:
} + ElementAttributes + Dimension name that you are trying to load the alias
You can use this control cube to load the Alias, you'll just need to create a rule to get the Alias from the Cube where you made the previous rule.
I hope it helps.
See you.
If your dimension attributes are loading as *ERR* there's probably an error in the Rule.
I never saw this *ERR* in different places than the cubes on cells where I used a rule and there was a logic error.
Take a look at your cube maybe you need to convert numbers to string to concatenate (not only using S:) or some cells have erroneous values.
If yet you can't solve this, used the Control Objects, by clicking in View > Display Control Objects and look for a Cube with name like:
} + ElementAttributes + Dimension name that you are trying to load the alias
You can use this control cube to load the Alias, you'll just need to create a rule to get the Alias from the Cube where you made the previous rule.
I hope it helps.
See you.
Matheus Dewes
Developer/Consultant
Developer/Consultant