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 many number of cubes can we create on a single model? How can we navigate between those cubes?
How to create a dynamic column name in Cognos?
6 Answers Aditya Birla, Polaris,
How applying "Level Span" in Cognos 8.3?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?
How do you deployment reports from one server (Development) to other server(Production)? How do you configure the cognos7.0 version cube in cognos 8.0? Pls, explain with example? How do you create IQD without IMR or can u explain other way create IQD?
what is the difference between enterprise data warehouse and data warehouse
What are Governer Settings?
how many types of formats you can run a report using cognos?
what is power prompt in cognos ep7series?what is the use of this?
What is the use of report studio?
which table we load first in DW. dimension or fact? why?
4 Answers IBM, JPMorgan Chase,