If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cube based Data item

Started by iBoy, 30 Oct 2013 09:56:15 AM

Previous topic - Next topic

iBoy

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

CognosPaul

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.