Hierachy Report Requirement

[Former Member]

Hi,

I have a hierarchy which has subobjects in it. The sub-objects are displayed onto the higher node of the hierarcy. How do I avoid this. To give you clarity, here is a example:

The report I have now:

> Node 1 - 750

-

---

SO1 - 100

-

---

S02 - 150

-

---

SO3 - 100

-

---

S04 - 150

-

---

SO5 - 100

-

---

S06 - 150

>>> Node 11

-

---

SO1 - 100

-

---

S02 - 150

>>> Node 12

-

---

SO3 - 100

-

---

S04 - 150

>>> Node 13

-

---

SO5 - 100

-

---

S06 - 150

The report I am looking for:

> Node 1 - 750

>>> Node 11 - 250

-

---

SO1 - 100

-

---

S02 - 150

>>> Node 12 - 250

-

---

SO3 - 100

-

---

S04 - 150

>>> Node 13 - 250

-

---

SO5 - 100

-

---

S06 - 150

Let me know if it still confusing.

Thanks

Ace

[marcus_lnnendonker · Accepted solution]

Hi Ace Base,

add the sub-objects to rows in Query Designer if it's not already there, then right-click on "Rows" in Query Designer (the grey bar) and choose "Display as hierarchy".

However, by right-clicking in the Excel workbook you can still drilldown SOs in the upper levels. If you wish to avoid that, you need to use authorization objects. See current discussion in

Cheers,

Marcus.

[Former Member · Accepted solution]

Is there a possibility to use the complete report and the defined hierarchy also offline (without connection to BW), e.g. in MS Excel without programming (if no, which possibilities there are to programming)?