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



suppose i want to do drill through a column only for the values which is having more than > 50000..

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

suppose i want to do drill through a column only for the values which is having more than > 50000..

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

Post New Answer

More Cognos Interview Questions

what is the main advantage of impromptu over cognos reportnet?

0 Answers  


How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..

0 Answers  


------------ Diff b/w MemberCaption and MemberDescription?

0 Answers  


how many types of keys are there i.e primary key and foreign key etc..?

3 Answers   IBM,


what is power prompt in cognos ep7series?what is the use of this?

0 Answers   HCL,






If we run a report, that has 2 pages, i want to display one page in HTML format and another page wil display in pdf format. What is the procedure?

2 Answers   IBM, Polaris,


What is cognos connection?

0 Answers  


what are typees of dimensions

5 Answers   HCL,


What is snapshot ?

4 Answers   IBM, TCS,


What are various types of gateways in cognos?

0 Answers  


my cient has reports in java and the dw mart is there already, whether you will suggest for Cognos reports ?

1 Answers   IBM,


Usage of Stored Procedures in Cognos

1 Answers   General Motors GM, TCS,


Categories