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


Please Help Members By Posting Answers For Below Questions

can you tell me what are the dimension tables are used in project

1888


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.

1474


What are the methods by which it non-durable model could be changed into the durable model?

518


Can you define bitmap index?

590


What is the complex report you faced in real time?

1731






how u will design the report if the objects are available

2323


What are the advantages of cognos?

570


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..

1694


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.

2126


Write some methods to apply securities in framework manager model?

653


In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1533


What do you understand by the term 'aggregate cache'?

568


Diff b/w Crossproduct and Outerjoin?

1813


what is the difference between list report and crosstab report?

709


What is the difference between set functions and filter function in dimensional data?

2510