Forum Stats

  • 3,872,069 Users
  • 2,266,376 Discussions
  • 7,911,043 Comments

Discussions

dimension multiple leaf levels

hi, there is a logical table (business model and mapping) with 6 columns.

the columns are:

region name
region special name
city name
city special name
street name
street special name.

my purpose is to:

when users click "region name" on the dashboard, the drill down is "region name" -> "city name" -> "street name"
when users click "region special name on the dashboard, the drill down is "region special name" -> "city special name" -> "street special name"

"special names" are not in the drill down of "names"
"names" are not in the drill down of "special names".

I build a dimension (business model and mapping) with 4 levels.

grand total level
- region
_region name_
-- city
_city name_
--- street
_street name_
- region special
_region special name_
-- city special
_city special name_
--- street special
_street special name_


(underlined are columns)

but I get an error "not identical leaf levels",
how to achieve my goal?


and is it a must to define ONLY ONE dimension for ONE logical table?
Tagged:

Answers

  • Goran Ocko
    Goran Ocko Member Posts: 554
    edited Oct 5, 2009 1:35PM
    You need to have two hierarchies in the same dimension, one is for region name-<city name-<street name and other for region special name-<city special name-<street special name.

    For example:

    Total
    --Region (column region name is the key use for drilldown)
    ----City (column city name is the key use for drilldown)
    ------Street (column street name is the key use for drilldown)
    --Region2 (column region special name is the key use for drilldown)
    ----City2 (column city special name is the key use for drilldown)
    ------Street2 (column street special name is the key use for drilldown)

    Now, if you drill from region name you'll get region name-<city name-<street name and if you drill from region special name you'll get region special name-<city special name-<street special name.

    Regards
    Goran
    http://108obiee.blogspot.com
  • 707781
    707781 Member Posts: 500
    edited Oct 5, 2009 11:19PM
    Dear Goran O,

    hi, I built the same dimension as yours (please see 1st message), but I got the error.
    thanks

    the error is:

    [38073] Dimension '"Business Model Name"."Dimension Name"' has multiple leaf levels which are not identical.

    here is the detail of this error: from here

    38073 Dimension ‘@1%ls‘ has multiple leaf levels which are not identical.
    Cause. The repository contains a definition error. Leaf levels in a dimension have to be
    identical.
    Response. Use the Administration Tool to correct the dimension hierarchy. Use the Check
    Consistency command to check for additional repository compilation errors. Correct any
    problems and retry the action. If the problem persists, contact Siebel Systems technical
    support for assistance.
  • Goran Ocko
    Goran Ocko Member Posts: 554
    edited Oct 6, 2009 4:42AM
    To eliminate this error add detail level (child, lowest level) in the first hierarchy and share it in the second hierarchy. This is must be and if you ommit use for drilldown on the key column on that child/shared/lowest level it will never be displayed, so your two hierarchies will be the same as we defined before. Use primary key (id from table) for the column on this detail level. In the second hierarchy go to Street2/New object/Shared level as child and choose Detail level. Now both have this Detail level.

    The dimension is now like:
    Total
    --Region (column region name is the key use for drilldown)
    ----City (column city name is the key use for drilldown)
    ------Street (column street name is the key use for drilldown)
    --------Detail (shared level, id is the key not use for drilldown)
    --Region2 (column region special name is the key use for drilldown)
    ----City2 (column city special name is the key use for drilldown)
    ------Street2 (column street special name is the key use for drilldown)
    --------Detail (shared level, id is the key not use for drilldown)

    Regards
    Goran
    http://108obiee.blogspot.com
    Goran Ocko
  • 707781
    707781 Member Posts: 500
    edited Oct 6, 2009 6:19AM
    Dear Goran O,

    hi, I tried your way,
    but I test 2 cases.

    1) Detail (shared level, id is the key not use for drilldown)
    on the dashboard, the drill down is not enabled.

    2) Detail (shared level, id is the key use for drilldown)
    on the dashboard, when I click region, it directly drills down to detail level

    And if the detail level does not exist.

    thanks!
This discussion has been closed.