Replacing MemberCaption to value of Prompt

[harithwal]

Hi,

Source is Tm1 Cube.
Relational Table contains Better Name for Display

Requirement : for e.g., the hierarchy what i have contains membercaption like 'Period', 'Period.', 'Period..' so that tm1 can maintain the uniqueness of the member the description has been appended with the period symbol. But the requirement in the dashboard is not to display the membercaption in the Charts, Visualization but to display the names from the Relational Table.

Is it possible to acheive this.

[MFGF]

Sadly not. You can't mix relational and dimensional data in the same query. Neither can you use join operators on dimensional queries.

MF.

[bdbits]

I do not have TM1, but I have one idea... with other Cognos dimensional modeling tools you can set multiple role values for each level. If TM1 also supports this, you could populate another level role in the cube like "short name", then in your report use this instead of the member caption in the appropriate property for the displayed item. e.g. in a chart this might be the category, so you would click on category and change the "Source Type" under "Text Source" in the properties.

Just throwing this out there, as I said I do not have TM1 but maybe that is an option.

[MFGF]

Hmmm. I'm not sure, but I have a nagging feeling Cognos BI doesn't surface "other" attributes in TM1 cubes. TM1 is very picky when you define "Alias" attributes for a member - each "Alias" must be unique within the dimension. I'd be delighted to be wrong, though! :)

MF.