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 |
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
---------------Tell me about DWH Concepts?
first of all i want say thanks to Zilanibasha, As u said that now these days Cirtification in cognos8 is only possible. Will u like to tell me in detail How i apply for cirtification As i m very much Interested.
After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate<fromdate its an error. How can we generate the user defined error message for this type of error
HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS
5 Answers IBM, Virtusa, Wipro,
how can I test reports in cagnos?
Wht is difference between content store and content manager?
2 Answers Satyam, Tech Mahindra,
what is crosstab space
What junk dimension contains?
what are the applications of the tabular model ????
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
can any one explain about blue prints&performance tuning in cognos?