Explain about embedded & standalone filters?difference
between them



Explain about embedded & standalone filters?difference between them..

Answer / harry

Framework Manager supports stand-alone filters and embedded
filters.

Use a stand-alone filter when you want to reuse the
expression.

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, or you can include it in a package to
make it available to your users. By moving a stand-alone
filter or a shortcut to it into a folder, you can better
organize the model objects.


Use an embedded filter when you want to use a filter with
only one dimension or query subject.

You can create an embedded filter when modifying a
dimension, relational data source query subject, or model
query subject.

If you start with an embedded filter, you can later convert
it into a stand-alone expression that you can apply to
other dimensions or query subjects. Tip: Right-click the
filter expression in the Filters tab and click Convert to
Stand-alone Filter.

When you embed a filter, the data source query subject must
have a relationship to any query subject referenced by the
expression. This relationship is necessary even if the
expression references a model query subject based on the
same table as the data source query subject in which you
are embedding the expression.

To create a filter on an unrelated query subject, do one of
the following:

Ensure that there is a join path between the new query
subject and the one that contains the filter.

Base the embedded filter on a query item that is based on
the data source query subject you want.

Convert the calculation to a stand-alone filter, so that it
is not part of the query subject.

Create a stand-alone filter that references the embedded
object.

Is This Answer Correct ?    14 Yes 1 No

Post New Answer

More Cognos Interview Questions

How can you link a query to a data container manually in Report Studio?

0 Answers  


what is filter?give me one example that you created a report in your project?

1 Answers   HCL, IBM,


HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS

5 Answers   IBM, Virtusa, Wipro,


what is Galaxy schema??

2 Answers   IBM, iGate, Wipro,


How do you test the reports? Explain the Unit testing procedures after developing the reports?

1 Answers   HP, TCS,






What is the complex report you faced in real time?

0 Answers  


How to connect three fact tables?

11 Answers   L&T, TCS,


how to handle multifact?

2 Answers   IBM,


What is the use of 'individual data source' option while using filter in query studio?

1 Answers   Thomson Reuters,


what is bobble chart?

1 Answers   Syntel,


How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

0 Answers   HCL,


Wt is the Diff between Business Key & member caption?

2 Answers  


Categories