Quick question to refresh my mind about cubes and they're occurence in a data item.
Below is a data item containing the following:
[Control Platform].[Categories].[Categories (All)].[Category]->:[PC].[@MEMBER].[0]
I understand:
[Control Platform] = Package
[Categories] = Dimension
[Categories (All)] = Hierarchy
[Category] = Level
[PC] = PowerCube
[@Member] = ?
- = ?
Any help? Sorry for the simplistic write-up, I did it to help me remember it more than anything. Can anyone clarify the two question marks though?
Thanks,
iBoy
The [@Member] I think simply indicates that it's a member. That .[0] is the category code for that member.
In PowerCubes you will occasionally see a tilde inside the category code. That happens when you have two members, in the same level, with the same category code. This can happen when you create dimensions from unrelated attributes. Marriage status-> Gender. Since Male will appear in all marriage statuses, Transformer will automatically append a unique ID to ensure uniqueness.