Skip to Content
author's profile photo Former Member
Former Member

Needs to implement a filter

Hi all,


My requirement is client needs to create a filter "keyword" which contains nearly 75 objects. For example i need to filter out a person in the city i can filter him by so much criterias like "Name,age,surname,job,doornumber etc.,," like that client needs to serach data in the report according to the information which he need among the 75 objects. My question i sis there any simple way to impliment the same at report level or else universe level or else db level.



my assesment is : By creating an object in the universe "keyword" and in properties__>--> Properties tab edit (LOV) defining all the 75 objects as a query level filters will solve the solution is it a better way to do?? beacause while creating the same while running the report with the object "Keyword" it will pop up all the 75 filters at astretch and its time taking process.


Please guys help to find out a better solution.



Note : All the filters are OPTIONAL. It is not neccesary fo rthe client to know all the search criteria.




Thanks & REgards,

Madhu

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 23, 2014 at 05:50 AM

    Hi Madhu ,

    It is not a good practice to have 75 Objects / prompts at report . afaik there is no option to search in multiple objects values with a single prompt in BO .

    In the report , you can create Input control for better search on all the data available.

    go through below thread

    BOBJ Tricks: Search Field Input Control in Webi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member


      Thank you sathish,

      But user needs to have it as filter itself. I tried it to change at universe level by defining an objects and to edit the lov to having all the 75 fields at the select class. At report level it while fetching the created object in the report it will show at prompt level as lov containg the values of 75 fields but need to analyze whether the usage is effective or it will have any negative impact on teh report.

      Regards,

      Madhu

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.