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 |
Hi all, IF any one has Cognos Dump Questions please send it to my mail ID : jaya.purna@gmail.com Cheers Jaya
what is the use of macros&folders&herarchies in frameworkmanger?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
what are the joins present in reportnet?which is most widely used?
how can you create a report like if country=india then true if contry=spain then false?
What are the considerations regarding performance kept in mind while setting up cognos?
How to Reset Pagenumbers in one report.
What is Portal Tab?
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..
In how many ways we can apply the security to a cube in Transformer? Explain?
APPLYING COLORS TO ALTERNATE ROWS IN A LIST REPORT
can you apply grouping on crosstab?