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 |
What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,
cognos reportnet is molap or rolap ... somebady telling cognos reportnet is molap and other will be telling rolap ... i need extract answer
if a page have 3different layouts(list,crosstab,chart)can you show the 3 leyouts in 3 different formates (pdf,excel,csv)?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
what are the uses of report studio,q.studio,analysis studio,event studio&.metric studi.
16. How can we create top 10 and bottom 10 records in the same list?
What is a Pivot?
In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha
how can you set the image in the report
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
How to create multilingual reorts?
Can any one tell me cognos training class in chennai? thanks in advance...