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 Busschema?

1 Answers   Cap Gemini,


what is report studiio and how to start it?

2 Answers  


What is the complex report you faced in real time?

0 Answers  


What is Portal Tab?

1 Answers  


How do you improve the performance of the Cognos Analytics report

0 Answers  






I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

0 Answers   Infosys,


Which one is better among Value and select & search prompts,in terms of performance?

2 Answers   L&T,


Can i apply drill through on chart in report studio?

4 Answers   TCS,


What is Regular Dimension and Measure Dimensions and Diff b/w them ?

2 Answers  


-----------------What is Singleton?

1 Answers   BoA, Cap Gemini, TCS,


What is model filter and query filter?

2 Answers   Wipro,


Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

0 Answers  


Categories