What is model filter and query filter?
Answers were Sorted based on User's Feedback
Answer / suresh
Model Filter: need to create a filter inside the FM model
itself.
(Stand Alone or Embeded)
Query Filter: Need to create in RS query.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / kumar
Hi Friends,
We have Filters @ FM Level, Reprt Level
1) FM Level:
a) Stand Alone Filters, We prefer these kind of
Filters whenever we want to use filter for entire Package.
b) Embedded Filters, We prefer these kind of Filters
whenever we want to use filter for Particular Query Subject.
2) Report Level:
a) Summarized Filters are used to filter the group of
records ( Like Having clause in Oracle).( After the
Aggregation)
b) Detail Filters are used to filter the indivisual
records ( Like Where clause in Oracle) (before the
Aggregation)
&
We have Static Filters , Dynamic Filters @ Report Level.
| Is This Answer Correct ? | 3 Yes | 0 No |
suppose a value prompt contains 100 values and i want to select all values in that prompt....i want ALL option in the value prompt? how can u keep this option in value prompt?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
How to configure the Cognos configurations to work in the Windows 2000 Server machine?
what is the difference between aggregation and role up aggregation ?
What are cognos connection initial page components?
Can you define cognos decision stream?
is there any possibility to hide items other than render variable?
Are you aware of any limitations in Cognos?
------------ Diff b/w MemberCaption and MemberDescription?
What are products of cognos?
How to maintain Query subject’s relationships between Database layer and Model Layer? For eg - if 2 DB layer's query subjects are copied in Model Layer - Query subjects respectively, then Where should we define relationship of both Query subjects? Either in DB layer or Model layer?
What are all the types of indexes in Cognos?