Interested to Buy Any Domain ? << Click Here >> for more details...
How to create a dynamic column name in Cognos?
- 6 Answers
- 39003 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
Why cognos decision stream is used?
What is called materialized view?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
----------------Describe DWH Architecture?
Can you define a datastore in cognos?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
----------------------What are the User Securities?
Can you explain a cognos controller?
What are the components of report net?
Can you define framework manager?
What is meant by junk dimension?
What are the two types of framework manager?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
