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...


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

can anybody send me interview questions with answers on IBM cognos-FM and Report studio. My mail ID is: cskcognos@gmail.com

1 Answers  


hi, I want to create this report... List View--- -(Drop down list) Order Date From: \/ To: Customer Employee Order customer ------------------------------------------------------------ ------------------------------------------------------------ ------ customer c-name c-address c-phone c- city.................... ------------------------------------------------------------ ------------------------------------------------------------ ----- c-id c-type . . . ------------------------------------------------------------ ------------------------------------------------------------ ---- Employee .............same like one list Order.....................same like one list These are all in one page....i want u show... condtions *when i select in view type ex:employee and date as 10-05- 2007 to 10-05-2010 I need to go the employee list table and display the items .. And Iam trying in value prompt for creating of (cust,emp,ord)in a single value prompt,that will not created... and how to create 3-list and connection for those in value prompt.. Pls any one knows explain me (by step by step) of creating that report? Thanks Vannur

0 Answers  


what are determinants?

4 Answers   Dominion,


In how many ways we can apply the security to a cube in Transformer? Explain?

1 Answers   Wipro,


How to perform single signon in Cognos by using URL?

3 Answers  


Difference between Express authoring mode and Professional authoring mode?

2 Answers   Wipro,


Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??

2 Answers   Barclays,


what are the enhancements in cognos reportnet ?

9 Answers   IBM, TCS,


Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days

0 Answers  


what is the difference between cascading prompt and drill-thru

4 Answers  


where we use page break  and page set. with example?

1 Answers   CNSI, IBM,


Can you define a datastore in cognos?

0 Answers  


Categories