Interested to Buy Any Domain ? << Click Here >> for more details...
what is filter?give me one example that you created a report
in your project?
- 3 Answers
- 6637 Views
- IBM, I also Faced
- E-Mail Answers
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 we check the errors before running the report,plz let me know the answer
What are the steps to create DMR model in FM? Give me brienf discription as interview point of you?
What are all the different types of prompt in cognos?
how many facts&dimensions tables in a sales project?can any body name those dimensions and fact tables please
Can anyone tell me which automation tool is used in cognos,is it a testing tool or performance enhancing tool Thanks in advance
What is Parametermap?
How many fact tables and dimension tables in your project?
we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab with LOB as rows and loan amount as measure,coming to the main problem we have to create dynamically changing column in the columns of the crosstab.The requirement is ...we must have two dynamic columns like feb 08 and feb07.For example if current date is feb 28,we have to get the loan amount from 1st of feb to 27 of feb 2008 as feb08 and loan amount from 1st of feb to 27th of feb 2007 as feb07 columns.Please suggest us the possible way....thanks in advance....
im having null data in one of the cell in my report i have to display as "no data" when u run the report how can i achive this problem?
WHAT ARE THE DISTNICT VARIABLES?
which type of project we r going to snowflake schema
How can we improve performance in framework manager level?
Teradata 
