SAP Analytics CLoud - Custom Hierarchy on BW Live Connection

[keinhoff]

Hi all,

with 2020.Q2 release the feature for creating custom hierarchies on BW live connection was announced. Unfortunately I cannot find any hints in the documentation how to use this feature.

I imported the relevant notes 2865887 and 2865929 and we are already on SAP BW 7.50 SP16. From my point of view all prerequisites are fulfilled.

Are there any other settings I have to keep in mind to make use of this feature? Any settings within the BW Query? I can imagine that hierarchies should be activated on the infoobject used in the query. But also this is the case.

Is there anyone who can share experiences with this?

Regards

Kjell

[deepusasidhar]

Are you able to see any BW hierarchy when you go to the Hierarchy option in the builder?

I am able to create hierarchy based on BW/4 2.0 SP4 system (see post and screenshots below). On the query side make sure you have the hierarchy enabled, in this case we already had an hierarchy associated with the object and we were able to create a new hierarchy.

https://answers.sap.com/questions/13048884/custom-hierarchies-groups-for-bw-live-q2-2020.html?childT...

[keinhoff · Accepted solution]

Hi Henry,

once again thank your for the help. I do understand how it works once the feature is available for us. 🙂

Finally we made it possible to be used. In SAP BW I started again the Note Analyzer with the newest XML file to see what kind of notes are still missing in our system and I found a lot. Well okay, they come with SP17 but nevertheless I scanned the missing notes for something around InA and Custom Grouping and I still found two or three notes I had to install. After that the feature now is available and we will test the using. The following notes have been installed:

0002815937 InA: Diverse Wertehilfeverbesserungen und -korrekturen

0002827190 Aktivierung einer benutzerdefinierten Gruppierung

0002849009 Benutzerdefinierte Gruppierung: Anpassung des InA-Protokolls

0002868462 InA: Benutzerdefinierte Gruppierung nicht aktualisiert oder Fehler bei mehreren

Sorry, just have the german descriptions for that. But maybe this can be a help for anyone with the same problem mateusz_mikulski .

Regards

Kjell