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

Creating a custom hierarchy in Web Intelligence with BEx query as a source

Hi,

I have a BEx query which contains Country, State and City as three separate object. I am interested in creating a hierarchy as we used to create in Universe earlier. I am not interested to use SAP based hierarchy. Is it possible to achieve this? I am using SAP BI4.0 SP04.

Also I have observed that hierarchy in WebI appears twice with two different icons (3 steps with arrow and 3 steps green right sign) any body knows its significance? How different are they in behavior?

Regards,

Girish Oak

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Aug 21, 2012 at 12:41 PM

    Girish,

    The only option you have in creating a custom Hierarchy is created a Relational UNX using the BICS connection. Within the UNX you will be able define the custom hierarchy. You CAN NOT a customer Hierarchy using WebI or any other tool if you connect direct using BICS. This is you only option.

    Good Luck,

    Ajay Gupta

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 21, 2012 at 12:06 PM

    HI,

    In Universe we have the option of creating the Custom hierarchies.so select the dimensions in the order wise create the custom hierarchy.

    I think there is nothing diff b/w them, behaviour wise also both are same...

    regards

    ASHOK

    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.