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 |
What is the difference between Conditional Layout and Conditional Block
How can create users and permissions in cognos?
Which one is better among Value and select & search prompts,in terms of performance?
What are the types of security?
hi, i am Having 2 Reports one list report,one crosstab report if i put 2 querys for 2 reports which query will execute first?if i put same query for both 2 which report i will Get?pls pls pls Explain me...
What are all the types of indexes in Cognos?
explain how to create powerplay reports?
When we deploy the report to live the client get the data error how can we resolve that
what is the difference between a data item and a query item?
How can I test reports in cagonos?
I need your kind support. I have more than 6yrs of exp in s/w industry. I have worked on some DW technologies which are out dated. For almost 1 year I was on bench.During this bench period I learnt cognos on my own using online docs. Hence I am alligned to a project few months ago to work on cognos. Unfortunately after joining this project I did not get opportunity to work on cognos. I am working on different things apart from cognos. I should get job in another company. Otherwise I am gone. I am confident enough to get job on Cognos in another company. Please let me know is it possible to work on Cognos at lead position (as my current position is at lead level) without having real time experience. Your response is highly appreciated and I will be grateful to you. Thanks in advance Ganesh
What is the diff between Drill through reports and Master detail reports?