Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

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

Question Posted / realgowri

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 Star schema group?

1 Answers   IBM,

-------------How to do Bursting a Report?

1 Answers   Cap Gemini,

Hai frnds, Any body tell to What is Granularuty in cognos Please help me.i can search in so many browsers but i canot get the answer

3 Answers   Wipro,

why we r using report studio in webbased only and fm windows based only

1 Answers  

What is the importance of having monitor service in cognos?

0 Answers  

at what level u prepared the reports in cognos???? in dataware housing what is the automation tool u r using???

1 Answers   Covansys, IBM, Wipro,

architecture of cognos8

1 Answers   IBM, Sonata,

What is use of Field Set present in toolbox?

1 Answers  

How will u execute a stored procedute from a reportstudio

2 Answers   Cap Gemini,

---------------Can we use more than 1 Fact table ?

2 Answers   Bank Of America,

Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!

1 Answers   Wipro,

How to Improve the Performance of the Report? i need this urgently .

4 Answers   HSBC,

For more Cognos Interview Questions Click Here
Categories