Can Alias be displayed in Cognos Insight?

Post Reply
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Can Alias be displayed in Cognos Insight?

Post by macsir »

I looked around but can't find any option in Cognos Insight to display alias in the Widget?
If can't anyway, what is the meaning for adding an alias? :geek:
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
moby91
MVP
Posts: 229
Joined: Fri Mar 11, 2011 2:18 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2003 2007

Re: Can Alias be displayed in Cognos Insight?

Post by moby91 »

No, you cannot use an alias in Cognos Insight as you can in TM1:
In Cognos Insight you cannot use an alias instead of the corresponding element name as you can do in TM1.

In Cognos Insight, when importing data say from a flat file, you can define an alias in the data source and map it to an element.

In short terms, in Cognos Insight a TM1 alias is restricted to the role of a lookup element in a lookup dimension when importing data, quote the IBM Cognos Proven Practice "IBM Cognos Insight - Map Members from Different Sources to the Same Dimension":
"This scenario can be dealt with in Cognos Insight by using Aliases or a lookup dimension."


Note:
http://www.ibm.com/developerworks/libra ... t-page649/
IBM Cognos Insight - Map Members from Different Sources to the Same Dimension

Summary: Experienced data modelers can use the techniques in this article to map members from different data sources to the same dimension during an import into Cognos Insight 10.1 or 10.2. They may be used when measures are taken from two data sources and the members from the dimensions bringing context to the measures do not match.

http://www.ibm.com/developerworks/libra ... 49-pdf.pdf
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Can Alias be displayed in Cognos Insight?

Post by macsir »

Thanks, bro.
I will check out the article later.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply