Explain about embedded & standalone filters?difference
between them
- 1 Answers
- 12803 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What is Fullouterjoin?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
What do you understand by the term 'aggregate advisor?'
--------------Diff b/w ODS and OLAP?
What do you understand by user class in cognos?
Explain what is the difference between microstrategy and cognos reporting tool?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
how to merge 2 crosstabs thans
What is the use of powerplay web viewer in cognos?
what is a prompt value in report studio and variables ?
What is called cognos reporting tool?
What is the difference between Open Connection command ang Open Session Command?
What is difference between data mart and data warehouse?
what is model and say about process how to create model and how to test model?
