How to create a dynamic column name in Cognos?
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
How can I test reports in cagonos?
What is Metrics designer?
how to create measures and dimensions?
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
What do you understand by the cognos?
How create measures and demensions?
What do you mean by drill across?
What is the information present in the cognos configuration file?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
---------------Tell me about DWH Concepts?
How is possible this scenario using in type-in prompt.?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
What is the use of powerplay web viewer in cognos?
What is difference between primary key and unique key constraints?