Interested to Buy Any Domain ? << Click Here >> for more details...
How to create a dynamic column name in Cognos?
- 6 Answers
- 38445 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
Which lifecycle we will use for reporting?
Explain difference between powerplay transformer and power play reports?
Can you define framework manager?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
Define the slice and dice?
What is Fullouterjoin?
What is Additive function?
How to a create header dynamically in a crosstab report in cognos 8.1?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
What DB View and Bus View?
What is a Framework manager?
how you create security to reports?
