suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kumar
Hi Friends,
We have Conditional Drill Through Concept.
Create a boolean variable with specific condition, select
the variable from conditional explorer then define the
Drill through.
Thank You
| Is This Answer Correct ? | 0 Yes | 2 No |
2. What is With Clause In Cognos?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
How to create a Ratio in Cognos Report studio Reports?
I need to display blue color for max Revenue and red color for min Revenue by using condition formatting how it possible........?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
what is mean by complex starschema ,star schemagrouping?
Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??
what is the difference between enterprise data warehouse and data warehouse
What do you mean by query studio?
what is a box type in cognos? what is a stitch query? what are the services that run in background when cognos is running
What is the difference b/w macros and prompt?