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

cognos is holap or molap or rolap

7 Answers   Cognizant,


Can you explain dynamic query mode?

0 Answers  


What is the difference between a cascading report and drill through the report?

0 Answers  


what type of charts we create mostly in realtime? plz help

4 Answers   IBM,


How to configure the Cognos configurations to work in the Windows 2000 Server machine?

1 Answers   IBM, Infosys,


Hi, I am Searching on Cognos 8, If any experienced person can send out a project or explain a realtime scenario that would be very helpful for me. Please be kind towards me and help me in this regard. I am really finding difficult to find a person who can guide me in this feild. Your help will be highly appriciated. My email id is balajishriram@gmail.com. Hope you will help....

3 Answers   Deloitte,


What are the batches and it’s details?

0 Answers  


What is difference between page break and section report? What is main advantage datawarehousing over oracle?

0 Answers  


Can you define slice?

0 Answers  


advantages of cascade prompt ???

3 Answers   iFlex,


what is the difference between aggregation and roll up aggregation?

1 Answers  


I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?

0 Answers   IBM, KKL, Reliance,


Categories