Interview Questions   Tutorials   Discussions   Programs   

Cognos - Explain about embedded & standalone filters? Difference between them?

asked mar December 25, 2014 11:43 AM  

Explain about embedded & standalone filters? Difference between them?


1 Answers

answered By   0  

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.

   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!