How to create a dynamic column name in Cognos?
- 6 Answers
- 36784 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
New coloums are added in database, then how you know in report level
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
How to Reset Pagenumbers in one report.
What is the difference between set functions and filter function in dimensional data?
How can I test reports in cagonos?
------------- How to identify the Revenue Column in Report?
How can you link a query to a data container manually in Report Studio?
what are the dimensions that you have in your current project?list them?
What is called cognos reporting tool?
what is catalog and types of catalogs in cagnos and which is better?
What do you understand by the term 'aggregate cache'?
What are the batches and it’s details?
What do you understand by the cognos?
what is power prompt in cognos ep7series?what is the use of this?
Cleared COG-112 with 100% score today. What next certification should i go for?
