Question Re: BW Hierarchy - same Node - Leaf in Design Studio in Technology Q&A

BW Hierarchy - same Node - Leaf in Design Studio

Former Member — Fri, 29 Jul 2016 09:54:40 GMT

I'm having problems with the display of an hierarchy in BO (testing in Design Studio).

Under each node i get the same leaf.

What I get:

1000

1001

1002

2000

2001

2002

What I want:

1000

1001

1002

2000

2001

2002

We did change (the first option) hierarchy attribute setting in RSH1.

After this change it is working in the Bex analyzer but not in any of the BO tools.

What am I overlooking?

Kind regards,

Ralph

Re: BW Hierarchy - same Node - Leaf in Design Studio

TammyPowlas — Fri, 29 Jul 2016 10:00:25 GMT

I haven't seen anything like this; it does sound like a BW backend setting

Could you share your screen shot of the InfoObject for the hierarchy tab back in BW? Transaction RSD1?

Use the camera icon to upload the image

Re: BW Hierarchy - same Node - Leaf in Design Studio

Former Member — Fri, 29 Jul 2016 11:16:38 GMT

Re: BW Hierarchy - same Node - Leaf in Design Studio

TammyPowlas — Fri, 29 Jul 2016 11:20:24 GMT

Ralph:

Here is my InfoObject Hierarchy from RSD1 for you to compare:

Re: BW Hierarchy - same Node - Leaf in Design Studio

Former Member — Fri, 29 Jul 2016 11:33:37 GMT

I did a compare but all settings are the same.

When I start the query in RSRT I get the correct hierarchy.

So it looks like BW the BW settings are ok.

Maybe something wrong between BW -> BO?

Re: BW Hierarchy - same Node - Leaf in Design Studio

TammyPowlas — Fri, 29 Jul 2016 11:37:03 GMT

What are the hierarchy settings in the BEx query? Could you share a screen shot of those?

Re: BW Hierarchy - same Node - Leaf in Design Studio

Former Member — Fri, 29 Jul 2016 11:50:26 GMT

Hi,

One more suggestion is don't change initial view of data source in Design studio & then try whether its work or not !!!

As we know, if we created conditions in Query designer then it will work in design studio only if you use query initial view as it is otherwise that conditions will never work.

Please try once.

Thanks!

Ketan

Re: BW Hierarchy - same Node - Leaf in Design Studio

TammyPowlas — Fri, 29 Jul 2016 11:52:40 GMT

Ketan - good suggestion. I should have thought of that. Thank you

Re: BW Hierarchy - same Node - Leaf in Design Studio

Former Member — Fri, 29 Jul 2016 12:18:31 GMT

Thanks for the response Ketan, but it isn't working.

I did make some changes so used the "reset initial view" button and ran the application again. No luck..

Re: BW Hierarchy - same Node - Leaf in Design Studio

TammyPowlas — Fri, 29 Jul 2016 12:26:05 GMT

Please share screen shots of your BEX query hierarchy properties

Re: BW Hierarchy - same Node - Leaf in Design Studio

Former Member — Fri, 29 Jul 2016 12:27:23 GMT

I already changed a lot of these functions, but i'm always up to try another config.

Re: BW Hierarchy - same Node - Leaf in Design Studio

TammyPowlas — Fri, 29 Jul 2016 12:33:01 GMT

Here's mine:

Re: BW Hierarchy - same Node - Leaf in Design Studio

Former Member — Fri, 29 Jul 2016 12:46:50 GMT

Just tried the setting without any luck 😕

Can you confirm the hierarchy setting I want normally works?

Re: BW Hierarchy - same Node - Leaf in Design Studio

TammyPowlas — Fri, 29 Jul 2016 12:57:29 GMT

Strange, for me this has always worked the way you want it to. Not sure what is going on with your scenario.

Re: BW Hierarchy - same Node - Leaf in Design Studio

Former Member — Fri, 29 Jul 2016 13:03:56 GMT

Hello,

Can you try to enable the first option like this ?

But I guess that's what you did.

When you say "any bo tools", which one are you talking about ? It should work as designed in Design Studio, Analysis for office and Olap, but can't say for Webi.

Re: BW Hierarchy - same Node - Leaf in Design Studio

Former Member — Fri, 29 Jul 2016 14:40:59 GMT

Hi Franck,

That's the option I already enabled.

Behavior with the following tools:

BW RSRT: OK

Bex Analyzer: OK

Design Studio: NOT OK

Analysis for Office: NOT OK

Analysis for OLAP: NOT OK

Webi : did not test.

Re: BW Hierarchy - same Node - Leaf in Design Studio

Former Member — Wed, 17 Aug 2016 13:17:16 GMT

It looks like we found a SAP note for this issue.

https://launchpad.support.sap.com/#/notes/2307358/E

Waiting for the SAP team to apply this note...