suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?
Answer Posted / suresh
Hi,
Steps to do.
1) Select that particular column
2) Unlock the object
3) Just simply cut that list column(Dont delete)
4) Create a boolean variable and write code
your measure column>50000
5) drag conditional block to that column which you already
cut the column
6) CB Properties Under Block variable Point to already
created boolean variable.
7) Select Yes and drag you measure value to that CB
8) Just select the text item and under drill through
properties point to your report.
9) Select no and drag your measure again to that CB.
10) Run the report.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How we check the errors before running the report?
What is looping and how to avoid it in framework manager?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
Can you explain the advantage of using shortcuts?
How Metrics Studio is better than Report Studio?
How do we drill through from a powerplay cube to reportnet?\
What is dtm?
What are the advantages of shortcuts?
What you mean by drill across and what is the difference between drill through, drill across?
What actually a project contains?
Define the slice and dice?
what is the main advantage of impromptu over cognos reportnet?
What are all the types of gateway used in Cognos?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
What are initial page components of Cognos connection?