Skip to Content
author's profile photo
Former Member

Ad hoc queries in BW 3.5

I am looking at building a web ad hoc query template that will enable end users to query against a certain cube. Has anyone done this? What are the risks of haveing end users create queries using ad hoc? Can you lock the ad hoc object to only 1 cube? Please help

Thank you

Aaron Blasi

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Feb 04, 2005 at 08:51 AM

    The risks of end users creating queries are the same as of end users creating queries in the BEx. Depending on your InfoCube design people may create queries that don't deliver the expected results. To prevent this you should create some useful structures and save them to ease query creation.

    You should also write a little documentation per InfoProv with rules like "Always select exactly 1 version, either for the whole query or per column", "Key figure Sales Price does not include discounts given" and things like that. Otherwise your users either get frustrated or you spend hours and hours fixing the users' queries.

    If you mean with "lock the ad hoc object to only 1 cube" that the users shall be able to create queries on cube A but not on cube B the best is to settle this with authorizations. You can also put an InfoProvider into the web item so that one cube is defaulted for the query but if the user clicks on 'Create New Query' he can select the other InfoProvider (he is authorized to create queries) too.

    Normally you wouldn't allow users to create BEx queries but not ad hoc queries on a given cube so this should be no problem.

    Best regards

    Dirk

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Feb 03, 2005 at 06:18 PM

    Hello Aaron,

    the restrictios are listed in the online documentation:

    http://help.sap.com/saphelp_erp2004/helpdata/en/1f/03223c5f00612be10000000a11402f/frameset.htm

    Yes, one Ad hoc query is restricted to one InfoPorvider. BUT a InfoProvider could be a MultiProvider!

    Kind Reg.

    Michael

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Feb 08, 2005 at 10:19 PM

    Thank you both for the input. I will work with my BASIS person to set up the correct authorizations.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded