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

What is the function of cognos dispatcher?

0 Answers  


Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com

7 Answers  


My problem is as follows I made two pages of the portal; in the first page i have two reports and from one of these i would like to communicate in some way (i.e drill- through?) with the second page that contains four reports (prompt value [product] and three chart [sales revenue, sales quantity and budget]). Particularly I would like to communicate with the report that contains the prompt, passing the Product. How can i drill from the first page of the portal to the second page ? More generally, is it possible to move from one page, containing 2 report, to another page with 4 report, through a drill-through or any other mechanism? Thank in advance.

1 Answers  


how can you restrict the number of values available for a prompt? i tried this by using static choices property, but i dint get result... so pls explain in detail steps....

3 Answers  


Can you define folder?

0 Answers  


How to do Performence Tunning in Cognos Reports?

0 Answers  


Can you define cognos impromptu?

0 Answers  


How to create Events?

1 Answers  


How to convert the tabular report into graphical report?Is this possible in cognos 8 report studio?

3 Answers   IBM, TCS,


Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

0 Answers  


actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

0 Answers  


How to create a dynamic header in a crosstab report using cognos 8.1 report studio?please suggest me.

1 Answers  


Categories