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 |
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
Define query items?
what is cardinality that you can give to employee and department query subjects in framework manager?
Whrer u can save the Report net documentation in our local system?
what are the joins present in reportnet?which is most widely used?
4 Answers Covansys, IBM, Satyam,
In one of my report i have one data item sales_amount. If this report is run by one user from india so the sales_amount should be display in indian repees(Rs.) format, if USA user then in dollers($), if UK user then In Pounds.Hou can i achive this? Please answer me.
4 Answers Accenture, HCL, IBM,
Can you define pivot?
what is sdibling function tell me the some functions
what r the filters in fwm and report studio
what is physical layer and presentation layer?
What is meant by report studio short cut?
Can you define cognos decision stream?