How to create a dynamic column name in Cognos?
- 6 Answers
- 37260 Views
- Aditya Birla, Polaris, I also Faced
- E-Mail Answers
Answer Posted / lakshmi
We can use variables for dynamically displaying column name.
In our project we given three dimensions in the prompt
value, user can switch to the dimension that they want to
see in the report.
Consider 3 dimensions A, B and C, Users want to see
measures in the report based on what is the dimension they
have selected in the report prompt having A, B and C
dimensions.
By using the Case Statement we can switch between the
dimensions
Create Dataitem as follows
Case
When ?p_Dimension?=A Then [A] (Directly take from
model)
When ?p_Dimension?=B Then [B] (Directly take from model)
When ?p_Dimension?=C Then [C] (Directly take from model)
End
This will automatically pick up the Dimension query item
names from the model based on User’s selection to display
as column name.
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What is the use of Cognos scenario?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
What is a Query Subject?
What do you mean by drill across?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
What are the advantages of cognos?
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
what is model and say about process how to create model and how to test model?
explain how to create powerplay reports?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
What is difference between primary key and unique key constraints?
How to join multiple db in catalog?
What do you mean by query studio?
What is the complex report you faced in real time?
