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.

what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

2070

---

Mention the difference between ‘macros’ and ‘prompt’?

1147

---

hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

2191

---

Can you explain a cognos controller?

1020

---

what are the errors faced while bursting the reports and how to solve those errors?

2016

---

Write some methods to apply securities in framework manager model?

1118

---

Can you define query studio?

960

---

What are products of cognos?

974

---

if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

1916

---

how to connect datamarts

2791

---

What is meant by Reportstudio shortcut?

2188

---

What are the message flows?

983

---

How security is concerned with Reportnet? Explain its implementing steps.

2043

---

I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

2009

---

What are the methods by which it non-durable model could be changed into the durable model?

957

---