Skip to Content
author's profile photo
Former Member

Query building question

Hi,

Does anyone know if it is possible to configure a cube so that if a user wanted to create a query from it, it automatically populates the query designer window with a standard set of charcteristics?

i have this idea to simplify the query buildig process by giving the end users a starting point, but I don't know if it is possible.

Thanks,

Allan

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • author's profile photo
    Former Member
    Jun 11, 2004 at 06:50 PM

    You may also want to look at using structures to handle common (even the basic) key figure and calc kf usages so that they just need to grab the structure and all their KF's and CKF's are dropped in place and ready to go.

    I also try with new cubes and such try and create a set of standard variables against most of the characteristics available to have as much "<i>ready to go</i>" for the developers to build queries against.

    I always have the first query built something which contains just about everything in a query (<b>a "ktichen sink" query if you will</b>). - This is never published to the end users, but is available to developers and admins as a catch all query they can use to verify data, check out different bits of infromation as needed.

    - Stephen

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Jun 09, 2004 at 02:51 PM

    There is no way to do what you propose (although it would be nice).

    However, what we generally do is provide a "master" query for each InfoProvider that already has most or all of the fields of interest defined with appropriate filters, variables, etc.

    All the user then has to do is to modify that query to suit his/her needs and do a Save As...

    Hope this helps...

    Bob

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      The only alternative is to start building a new query from scratch, so yes, the power users like starting with a "master" query.

      This approach also has the benefit of leading to better consistency in which variables and filters are used, etc., which improves the overall report-to-report consistency.

      Bob

  • author's profile photo
    Former Member
    Jun 09, 2004 at 10:29 PM

    Hi Allan,

    It is not possible because each query is based on a set of charcteristics and key figures.They are not standard set.They differ from cube to cube.So, there is no standard set.But you can use RRI to jump from a query to a query(BEX or SAP) or any sap transaction,i am pretty sure that it is not a solution for your quetion.

    Ravi.

    Add comment
    10|10000 characters needed characters exceeded