Hi Cognos Guru,
I am working on dimensional package and come across Caption function. Can you share your experience what is the use of this function?
To know it I took member set and caption of the same member set in the list and run the list report but I am got same result in the two column :(
Quote from: sunny bachan prasad on 30 Apr 2015 06:39:25 AM
Hi Cognos Guru,
I am working on dimensional package and come across Caption function. Can you share your experience what is the use of this function?
To know it I took member set and caption of the same member set in the list and run the list report but I am got same result in the two column :(
Hi,
In a dimensional source, you will find members rather than data items. Each member is identified by its MUN (Member Unique Name) and described by its caption. If you bring members into a report, the members are retrieved via their MUNs but the report displays the member captions automatically. If you use the caption() function, you are isolating the caption as a text value. The column showing the members and the column showing the captions will therefore look the same, but one is a member set and the other is a set of text values.
Cheers!
MF.
I would add that the modeler can define the caption to be different than the actual value of a member. In practice this is not all that common, but I have done this from time to time. Most commonly, it was used to display something in a particular way, but pass a different value to a drill-through report.
Hi MFGF,
Thanks a lot for sharing your experience.
I am writing what i understood from your statement so please correct me if i am wrong.
1)when we drag member set directly to the report then cognos uses the MUN to find location of that particular member set and whatever value is displayed in the report output for that member set is due to the caption function as cognos uses caption function by default in this case and the output value is the member set.
2)If we use caption function for member set we are isolating the value of member set as a text value.
Thanks in advance :)
Quote from: sunny bachan prasad on 30 Apr 2015 01:31:26 PM
Hi MFGF,
Thanks a lot for sharing your experience.
I am writing what i understood from your statement so please correct me if i am wrong.
1)when we drag member set directly to the report then cognos uses the MUN to find location of that particular member set and whatever value is displayed in the report output for that member set is due to the caption function as cognos uses caption function by default in this case and the output value is the member set.
2)If we use caption function for member set we are isolating the value of member set as a text value.
Thanks in advance :)
That's pretty much it, yes. Anything that is a member set can be used subsequently in dimensional calculations, whereas anything that is a text item cannot :)
MF.
Thanks a lot MFGF :)