Filter issue

[Former Member]

Hi,

tell me the Filter issue

[Former Member]

Hi nanip123,

[http://www.bidw.org/business-objects/universe-design/universe-access-restriction/]

[http://www.bidw.org/business-objects/universe-design/using-data-restriction-techniques-in-business-objects-universe/]

you asked about the Filter issue ,i think it's means data restrictions. we can restrict the data from large amount data. the above URL is the data restrictions templates. here we can Filter the data from large data..

Thank you,

Praveen

[Former Member]

Hi,

Are we talking about the filter issues with Universe designer or with Business View designer?

Regards,

Kuldeep

[Former Member]

Hi Kuldeep,

Here we are talking about Universe Designer.

The above post is belongs to Universe Designer.

Thanks and Regards,

Madhu...

[Former Member]

Hi,

Filter can be created in two ways:

1.Through Universe Designer

2.Web I

Universe Designer: Filter is nothing but a Condition. Designer can generate SQL that filters in the most efficient way. This is particularly more important in a star schema . If you build a query that involves filtering on a value from dimension table. Designer can apply the filter directly on the fact table using table foreign key. This eliminates unnecessary joins to dimensions tables.

How to create filter in Universe and what is advantages and disadvantages.

A condition object is a predefined Where clause that can be inserted into the Select statement inferred by objects in the Query pane.

Condition objects are stored in the Conditions view of the Universe pane. You access the conditions view by clicking the Conditions radio button at the right bottom of the universe pane

Using condition objects has the following advantages:

u2022 Useful for complex or frequently used conditions.

u2022 Gives users the choice of applying the condition.

u2022 No need for multiple objects. Building universes Defining objects

u2022 Condition objects do not change the view of the classes and objects in the Universe pane.

Filter Issues:You may need to direct users to use the condition objects view of the Universe pane. The only disadvantages for using condition objects is that you may want to force a condition on users to restrict their access to part of the data set. In this case you need to define a Where clause in the object definition.

Example: Select * from Employee where DepartmentId=20(Here where is a condition to filter the values of the select statement.)