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


Please Help Members By Posting Answers For Below Questions

What are the types of hierarchies?

560


What is a Framework manager?

561


how can I test reports in cagnos?

634


How to generate cubes in cognos?

570


how you migrate reports to cognos 8 from previous versions?

634






Define report item?

666


What is a Folder?

683


What are the roles defined by cognos platform?

566


What is the difference between the content store and content manager?

572


How to deploy from one server to another server?

2021


I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

1828


hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com

1600


How can create users and permissions in cognos?

561


how to perform single sign in cognos by using url?

567


What is difference between data mart and data warehouse?

548