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
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 |
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 |
can anybody send me interview questions with answers on IBM cognos-FM and Report studio. My mail ID is: cskcognos@gmail.com
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
what are determinants?
In how many ways we can apply the security to a cube in Transformer? Explain?
How to perform single signon in Cognos by using URL?
Difference between Express authoring mode and Professional authoring mode?
Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??
what are the enhancements in cognos reportnet ?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
what is the difference between cascading prompt and drill-thru
where we use page break and page set. with example?
Can you define a datastore in cognos?