Custom Hierarchy

building reports webintelligence
1

Here is my scenario,
I have 2 custom Hierarchies.

Custom Hierarchy : 1
Material Type
Material
Product
Sponsor

Custom Hierarchy : 2
Product Type
Material
Product
Sponsor

Started Creating reports :

In the report I need to drill only from Material to Sponsor. So I kept the scope analysis to 2 level.
But in the report I see a Up arrow on Material which is drilling up to Product Type or Material Type. All I need is to disable that Drill Up for Material. After editing the report to Query I see the Scope analysis is set to custom from 2 level. How can I make it default to 2 level with disabling the Drill up for Material.

   Material 
       Product 
         Sponsor

RUC :us: (BOB member since 2010-05-03)

2

Hi ,

Just Try this … Go to Scope of Anlysis and do custom and Tick the levels there .

Material Product and Sponsor…

Its using Default hierarchy so it will give you the Option fo drill up and drill Down .

Regards
Sapan

swapnil_taz :india: (BOB member since 2006-04-06)

3

Sorry I am not able to understand.
Please explain me in detail. Thanks

Here is my scenario again.

My default hierarchy is
Material Type
Material
ProductName
ProductType
ProductSubtype
I want to display only from
ProductName
ProductType
ProductSubtype

How can I disable Drill Up option for ProductName ???

RUC :us: (BOB member since 2010-05-03)

4

Can some explain me ??

RUC :us: (BOB member since 2010-05-03)

5

Moderator note:
Please do not bump your post until at least one business day has passed.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

6

This helped me out, But there is complete solution.

Please share some more inputs

RUC :us: (BOB member since 2010-05-03)