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?

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

How we check the errors before running the report?

945


What is looping and how to avoid it in framework manager?

1146


How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

3246


Can you explain the advantage of using shortcuts?

983


How Metrics Studio is better than Report Studio?

2504


How do we drill through from a powerplay cube to reportnet?\

2293


What is dtm?

1086


What are the advantages of shortcuts?

909


What you mean by drill across and what is the difference between drill through, drill across?

967


What actually a project contains?

1041


Define the slice and dice?

959


what is the main advantage of impromptu over cognos reportnet?

984


What are all the types of gateway used in Cognos?

972


Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.

1319


What are initial page components of Cognos connection?

951