on 01-26-2007 11:45 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mario,
I will add this to the Wiki next week, because this week im too busy.
Greetings
Daniel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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. 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
> 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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.