pls ans what are the filters we have in framework manager?
filters in report studio?
Answer Posted / swamy
Hi,
In framework Manager we have 2 types filters,
1.Stand alone filters:-
A.Use a stand-alone filter when you want to reuse the expression.
B.You can add a stand-alone filter to one or more dimensions or query subjects to limit the data that the query retrieves when the filtered dimension or query subject is used in a report.
2.Embedded Filter:-
A.Use an embedded filter when you want to use a filter with only one dimension or query subject.
B.You can create an embedded filter when modifying a dimension, relational data source query subject, or model query subject.
In report studio We have 3 Types Filters,
1.Tabular Filters:- In this two types,
A.Detailed Filters:-Filter is applied before aggregation as aggregation (detail)records are filtred
B.Summary Filters:-Filter applied after aggregation than aggregated (summary) records are filtered.
2.Grouped Filters:-
Filter which is applied to the group as group records are filters, known as Group Filters.
3.Slicer:-
A.Specifies the expression that defines the slicer member set. Slicer Applies to Slicer Member Set
B.A set of expression that returns members from a single hierarchy of a single dimension.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
can you tell me what are the dimension tables are used in project
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
What are the methods by which it non-durable model could be changed into the durable model?
Can you define bitmap index?
What is the complex report you faced in real time?
how u will design the report if the objects are available
What are the advantages of cognos?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
Write some methods to apply securities in framework manager model?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
What do you understand by the term 'aggregate cache'?
Diff b/w Crossproduct and Outerjoin?
what is the difference between list report and crosstab report?
What is the difference between set functions and filter function in dimensional data?