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 |
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 do Performence Tunning in Cognos Reports?
What is looping and how to avoid it in framework manager?
what is stitched query???
what r the claims? how many type of claims we face from client side?
----------------Describe DWH Architecture?
-------------Diff b/w Union and Unionall?
where you can save the report net documentation in our local system?
Can you define dimension?
What is Crossproduct?
In which type of report we can create school time table in cognos? [I want period numbers in rows like period 1, Period 2, period 3, period 4, period 5 and class numbers in columns like 8th class, 9th class, 10th class and subject names in cells] Genelally school time table is prepared in crosstab report, but subject names are not measures and a crosstab cell can not contain non-measures. This is my problem,,,,,
Which studio is used to create reports?