Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Hierarchies..... with SAP BW

Hello everyone.

Im building an application and loading a hierarchy from an InfoObject.

Im loading the following tables

P for master data

T for texts

H for the hierarchy and

RSTHIERNODE for the hierarchy group nodes.

After a few joins to link the master data and texts Im using the sentece Hierarchy with the parameters NODEID, PARENTID, LEVEL. This expands the loaded hierarchy and until here everthing is fine where I'm stuck is on linking the hierarchy with the transational data.

The expanded hierarchy generates N fields with the prefix name LEVEL and the level number, ie, LEVEL1, LEVEL2, and so on and each level has the description of the level.

The problem I have is when I filter any value stored on the main table (the transaction data) the fields from the hierarchy become gray like if there's not data asociated with the hierarchy (obviously there is).

So I dont know if anyone has ever worked on an scenario like this that can share some tips or tricks.

thanks in advance.

2 Replies
Not applicable

Re: Hierarchies..... with SAP BW

Hi Victor,

did you solve the problem?

lars

saniiiil
New Contributor III

Re: Hierarchies..... with SAP BW

Hi Victor,

I have not done the same scenario as you but we are using Xtract QV as SAP-QlikView connector from Theobald Software and loading the BW Hierarchies with their Hierarchy Connector.

On their blog they describe how to do that:

http://www.theobald-software.com/blog/2011/06/21/load-a-bw-hierarchy-into-qlikview-using-xtract-qv/

I hope this may help you.

Sanil

Community Browser