Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

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 ?

0 Answers  


---------------Tell me about DWH Concepts?

0 Answers   Bank Of America,


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.

1 Answers  


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

0 Answers   IBM,


HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS

5 Answers   IBM, Virtusa, Wipro,


how can I test reports in cagnos?

0 Answers   IBM,


Wht is difference between content store and content manager?

2 Answers   Satyam, Tech Mahindra,


what is crosstab space

1 Answers   IBM,


What junk dimension contains?

0 Answers  


what are the applications of the tabular model ????

5 Answers   iFlex, iGate,


In my report i want display sales rep name, country ,city how to achieve this by using repeater table

0 Answers   IBM,


can any one explain about blue prints&performance tuning in cognos? 

1 Answers   TCS,


Categories