Interested to Buy Any Domain ? << Click Here >> for more details...
How to create a dynamic column name in Cognos?
- 6 Answers
- 38747 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
Explain what is the difference between native sql and cognos sql?
What is the deployment requirements used in cognos?
What is the difference between a data mart and a data warehouse?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
How to deploy from one server to another server?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
How do you call a store procedure within a transformation?
What is a Transformer?
how can you get the errors in job? when loops are araised we get error?
what are the dimensions that you have in your current project?list them?
What are the steps to import the two data sources in framework manager?
What are the different types of important services used in cognos?
What are shortcuts? Where it can be used? What are the advantages?
Please explain the different stages in creating a report in cognos report net?
