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

WebIntelligence report on top of bex Query in BI4.0 (SP2)

Dear experts,

I'm working on webi report on top of bex Query in BI4.0 (SP2). I would like to know your opinions about some points I have noticed.

A - I need to drill throught a hierarchy which contains several millions of members.

Is there a possibility in my report drilling down to one member without selecting all members of the hierarchy in the query panel ?

B - I cannot put a dimension with hierarchy both in the result pane and in the filter pane, although it is possible for any other dimension without hierarchy.

Is there any special trick to achieve this or is a bug??

C - I cannot sort variables defined in my bex query, but they don't appear in the window to sort prompts.

Do you know how to solve this issue ?

D - I noticed all keys and description of dimensions appear with the same label "key" and "text". SO it is very confusing for the user to understand what key or text means (if a key if the customer key or the company code key).

Any idea to have a more explicit label for BW characteristics?

Regards.

CL.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 05, 2011 at 02:07 PM

    Hello

    I am suffering some of the same issues with WEBI 4.0 so I will be following your post to see if someone comes up with some good answers.

    With regards to your question:

    I cannot put a dimension with hierarchy both in the result pane and in the filter pane, although it is possible for any other dimension without hierarchy. Is there any special trick to achieve this or is a bug??

    What worked for me before the instalation of SP02 was to drag the hiearchy to the filter pane, then double click the hierachy in the universe outline window. This would then achieve the result you are looking for. This worked well until SP02 and since then I can no longer perform this trick and I am still waiting for SAP to advise on this issue.

    Regards

    Phillip

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 06, 2011 at 09:51 AM

    Hi,

    I do not have access to a BW system to test this, but i have something on three of your questions...

    A) drilling without getting all the lower members. I would look to query drill, this means a drill action in the report will go to the database to fetch the level (and only for the selected member, a drill down).

    The only thing I'm not sure about is if the BEx hierarchy is seen as drill hierarchy by that option too.

    If you'd ask me it really should.

    C) this is an old problem, but I know it is bugging more people, because the same is true for universe based prompts. They also cannot be 'arranged'. Since the Bex query is the 'universe', ordering that has been set in the 'universe' is the only chance you have.

    Like with the universe you could use prefixes to separate them from the query defined prompts (based on an alphabetic sort of the prompt message). I'd say this is a good one for the idea place...

    D) also an old (very old actually) problem. Some will want to keep the text short and simple. The prefixing will tell which key it is. Some will prefer unique names, so no prefix is needed. The same was true for universe designers. Now since there is no universe, if you do not agree with the 'designer' you're out of luck 😉 no way to change it.

    Hope this helps,

    Marianne

    Add a comment
    10|10000 characters needed characters exceeded

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.