cancel
Showing results for 
Search instead for 
Did you mean: 

How to filter a hierarchy-node by Web-API-Command?

Former Member
0 Kudos

Hi,

I have built a prototype with Start-Point, Data Provider (BW-Query with hierarchy) and Table view with Toolbar-Button. Now I would like to select a row (hierarchy-node), klick the Toolbar-Button and send a Web-API Filter-command to the Data Provider, so that I just see the selected row (hierarchy-node) in the Table view.

I tried this Web-API-command but it doesn´t work:

'FILTER_NODE_IOBJNM=0CUST_SALES;FILTER_VALUE='&@Hierarchy_key&';FILTER_COLLAPSE= ;FILTER_IOBJNM=0CUST_SALES;'

Is it possible to set a filter to a hierarchy-node by Web-API-command and how does this work?

Best Regards,

Daniel

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

For drill down you need the following syntax:

'FILTER_NODE_IOBJNM=0D_DBSIC1;FILTER_VALUE=

'&#ID[ACC503]@Industry_Sector_DB_SIC_key&';

FILTER_COLLAPSE= ;FILTER_IOBJNM=0D_DBSIC1;

CMD_1=CMD%3DDRILL_TO_LEVEL%26LEVEL%3D2%26IOBJNM%

3D0D_DBSIC1%26DATA_PROVIDER%3DDP;'

For drillup:

'CMD_1=CMD%3DDRILL_TO_LEVEL%26LEVEL%3D'&NSTR

(#ID[ACC503]@Industry_Sector_DB_SIC_node_level,

'B')&'%26IOBJNM%3D0D_DBSIC1%26DATA_PROVIDER%3DDP;'

It's very tricky, you need exactly this syntax. I have a full example over 10-15 pages of such navigation (and passing values) on hierarchies in my Visual Composer book.

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

I am using standard query 0FIGL_V10_Q0001 and for this query i could not able to perform the hierarchy in VC. Pl suggest me the process of developing hierarchies in VC.

Former Member
0 Kudos

Hi Mario,

I will add this to the Wiki next week, because this week im too busy.

Greetings

Daniel

Former Member
0 Kudos

Hi Mario,

the problem is solved, so the correct code should look like this:

'FILTER_NODE_IOBJNM=<b>0HIER_NODE</b>;FILTER_VALUE=

'&#ID[ACC503]@Industry_Sector_DB_SIC_key&';

FILTER_COLLAPSE= ;FILTER_IOBJNM=0D_DBSIC1;

CMD_1=CMD%3DDRILL_TO_LEVEL%26LEVEL%3D2%26IOBJNM%

3D0D_DBSIC1%26DATA_PROVIDER%3DDP;'

Regards

Daniel

Former Member
0 Kudos

Hi Daniel,

can you also put this solution in the Visual Composer WIKI in the Modeling section? I think it's a great example and many more people will stumble over that. I will assign points afterwards to you.

Mario

Former Member
0 Kudos

Your advise, to use 0HIER_NODE worked for filtering on Hierarhchy levels, that are not leaf levels, but this don't work, when I need filtering for leaf level. I have situation, when same values has to be filtered from Hierarhcy leaf level characteristics and some from greater level. Any ideas?

Hierarchy structure like

Z_ROUTE (Filtering OK)

Z_1 (Filtering OK)

0001 (Filtering NOK)

0002

Z_2

0003

0004

Karlis

Former Member
0 Kudos

Hi. Daniel.

We also come across with same issue. Can you please let us know what we need to

give in place of 'FILTER_NODE_IOBJNM'.

Is it technical name of char or Hierarchy tech name which has defined in query designer.

Here you have mentioned 0Hier_Node in place of 'FILTER_NODE_IOBJNM.

Thanks in advance. waiting for your response.

Arun

Former Member
0 Kudos

> Hi Mario,

>

> the problem is solved, so the correct code should look like this:

>

> 'FILTER_NODE_IOBJNM=<b>0HIER_NODE</b>;FILTER_VALUE=

> '&#ID[ACC503]@Industry_Sector_DB_SIC_key&';

> FILTER_COLLAPSE= ;FILTER_IOBJNM=0D_DBSIC1;

> CMD_1=CMD%3DDRILL_TO_LEVEL%26LEVEL%3D2%26IOBJNM%

> 3D0D_DBSIC1%26DATA_PROVIDER%3DDP;'

>

> Regards

> Daniel

Hi daniel

I created 2 Buttons on the tool bar...could you please give me the syntax for the Drillup & Drilldown as i am looking for the exactly same functionality

Thanks

Former Member
0 Kudos

u201Cweb api is deprecated with the next release of SAP NetWeaver and is subject to change.u201D .......

Any alternative ?

Former Member
0 Kudos

Re: How to filter a hierarchy-node by Web-API-Command?

Posted: Nov 20, 2007 3:06 PM in response to: Daniel Rüger Reply

Your advise, to use 0HIER_NODE worked for filtering on Hierarhchy levels, that are not leaf levels, but this don't work, when I need filtering for leaf level. I have situation, when same values has to be filtered from Hierarhcy leaf level characteristics and some from greater level. Any ideas?

Hierarchy structure like

Z_ROUTE (Filtering OK)

Z_1 (Filtering OK)

0001 (Filtering NOK)

0002

Z_2

0003

0004

Karlis

Hi Karlis , i have the same problem. can you solved this problem . any idea ?

Best Regards,

Cristian

Edited by: Christian Nazar on Nov 3, 2009 11:26 PM

Former Member
0 Kudos

Hi Mario,

thank you for the support!

I tried your example and the How-To but it doesn't work in the full functionality. The hierarchie drill-down works but the filter isn't set to the selected node so if I select one Hierarchy-node and click the Drill-down-Button all nodes drill down to the next level. But I just want to see the selected node as it is discribed in the examples.

I'm working with 2004s-Query (SPS10) and VC (SPS10)...

Maybe it is a problem with the _key of my hierarchy-attribute because if i display the _key in a table-view, it is shown like "1.00000000123e17". Shall I use a Text-Function like trim() or so to format the _key?

Regards

Daniel