suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?
- 2 Answers
- 7306 Views
- Mind Tree, I also Faced
- E-Mail Answers
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 |
What is the difference between ‘macro’ and ‘prompt?
what is the difference between aggregation and roll up aggregation?
How do we drill through from a powerplay cube to reportnet?\
Hi Experts, Can a single package be shared by multiple users?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
The vice president of sales has requested a report that shows sales performance by representatives in each country for year 1998. He would also like to see the performance for reprasentatives in Asia in order to present an award to the top sellers when he visits next month.
what is the difference between Cognos EP7 series and Congos8?
What is cognos connection?
Where do you set security levels for users in reports?
-------------How to do Bursting a Report?
Can you define set to be cardinality?
Hi,Can anyone tell me training centre for cognos in Mumbai?
Teradata 
