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

Hi all, IF any one has Cognos Dump Questions please send it to my mail ID : jaya.purna@gmail.com Cheers Jaya

1 Answers  


what is the use of macros&folders&herarchies in frameworkmanger?

1 Answers  


dumps needed ASAP for - C2020-180 Cognos IBM Certification

0 Answers   Aptech,


what are the joins present in reportnet?which is most widely used?

2 Answers   IBM, Satyam,


how can you create a report like if country=india then true if contry=spain then false?

2 Answers   Syntel,






What are the considerations regarding performance kept in mind while setting up cognos?

0 Answers  


How to Reset Pagenumbers in one report.

0 Answers  


What is Portal Tab?

1 Answers  


i thought to keep fake experience..as a fresher i can't enter..bcos there is a large gap after my graduation..4 years..any person who enter with fake exp describe how to attend the interview process..

0 Answers  


In how many ways we can apply the security to a cube in Transformer? Explain?

1 Answers   Wipro,


APPLYING COLORS TO ALTERNATE ROWS IN A LIST REPORT

5 Answers   Satyam,


can you apply grouping on crosstab?

1 Answers   CTS,


Categories