Skip to Content
avatar image
Former Member

Predefined filters

Where is the best place for a tutorial or to learn about predefined filters? I have BOBJ Edge XI3.1.

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 17, 2010 at 05:40 AM

    Regular objects go into the SELECT clause. Filter objects go into the WHERE clause. So essentially anything you can put in a SQL where clause is probably valid in a predefined condition.

    You create these by opening your universe, and look down at the bottom-left corner of the screen, below your list of classes and objects. You will see two icons, one for the different object types and another that looks like a yellow funnel. Click on the funnel, and you're in condition mode. Right-click on a class, and you'll see "Insert condition" on the menu. You can now add a predefined condition to your universe. 😊

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 12, 2010 at 08:38 PM

    WHat do you mean by predefined filters? In a universe you can create your own filters. But there is no such thing as a predefined filter. Unless you are talking about filters which are created automatically for universes based on specific data sources (eg. on SAP BEx queries)

    I will suggest you to take a look at the Universe Designer user's guide:

    http://help.sap.com/businessobject/product_guides/boexir31/en/xi31_designer_en.pdf

    WHat kind of data source do you want to access with your universe?

    Regards,

    Stratos

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 15, 2010 at 07:27 PM

    I was just using the verbage that was used in my Web Intelligence Report Design Class book. It states "Some universes have predefined filters built into them by the universe designer."

    As I am the Universe designer also, i am just looking for the best place to get in depth learning materials for creating these filters.

    Thank you for the link, that is probably an excellent place to start.

    I am in now way connecting to SAP data. My only data sources are SQL 2008 databases.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Ron,

      The filters should be built in conjunction with the reporting requirements.

      If there is a common requirement for last month's sales data, build a pre-defined condition for it.

      What you would need to do here is build an object for start of last month and an object for end of last month and then create a filter where sales date is between these two objects.

      If there is a common requirement to include only outgoing telephone calls, build a predefined condition for it.

      Basically anything that you think users will want to put in conditions you should include.

      Then you can throw this back at the DBA and make sure these columns are indexed for best performance as well.

      Regards,

      Mark