Hierarchy

[system]

Hi All,

I have a hierarchy defined in Universe as

Material Type
Material
Country
Region
State
One of my report needs only from
Country
Region
State
In the report level, I picked Country and enabled Scope of analysis with level 2 .

In the report , How can I disable the drill up for Country ??
Because when I drill up and drill down… I can see Drill up for Country.

Once I edit the query I see Scope of Analysis changed from 2 to Custom ???

---

RUC (BOB member since 2010-05-03)

[system]

Moderator note:
Please do not cross-post. It leads to fragmented discussions and is against our forum rules.

Original question and the discussion is here:

120×120 10.4 KB

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…

Please continue only there.

Closing this topic.

---

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