what is filter?give me one example that you created a report
in your project?
Answers were Sorted based on User's Feedback
Answer / arun kiran
We use filter to view limited data. For eg:
a list report with two columns country and revenue
eg: china 1235939
india 40393493
japan 938743739
US 32478327
UK 9420834028
if you drag a filter in query explorer and in expression box
you typed country = 'japan'.. if you run the report you will
be able to view only japan 938743739. you limited data to
japan. if you want to see for two or three or more use IN
function
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / piggynet
Filters are used to secure,limit or restrict the data. for
examples
if we only want to see product name and revenue by product
you can use the filter. (filtering data)
if we want to show regional manager sales data only for
his region we can user filter on region column (restricting
data)
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / naresh
filter is a condition to restrict the data as per the user
requirement.
we have 2 filters 1. detailed filter-it reflects
individual data items
2. summary filter-it reflects aggregated
data
ref: www.mycognos.webs.com for any other issues.
| Is This Answer Correct ? | 3 Yes | 0 No |
How to upgrade drivers in Cognos 8?
------------------What is Focalpoint?
What you mean by drill across?
Explain the difference between powerplay transformer and power play reports?
-----------Diff b/w OLAP and RDBMS?
In framework Manager, what is a stitch query and is it good or bad?
Is there any comparison available for Cognos Reportnet Vs Crystal reports?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
what is the difference between enterprise data warehouse and data warehouse
tell me two or three issues from client side and how to solve those issues?
what is the use of layout component reference
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