on 06-17-2009 5:15 PM
Hi Experts,
Could you please review the below Syntax in VC and update me what it is performing,modify it according to my requirment or advise me how to achieve it.
My requirment is filter a hierarchy and navigate on hierarchy and able to view results/Graph accordingly.
By refering "How To u2026Model SAP BI System Hierarchies in Visual Composer" Doc i had developed 2
Please explain me the syntax...actually it is working in dashboard but it is not giving me the correct node display...etc,So i thing i need to perform so modification to syntax
Drill UP
'CMD_1=CMD%3DDRILL_TO_LEVEL%26LEVEL%3D'&NSTR(@Cust_Hie_Incl_Self_3_node_level,'B')&'%26IOBJNM%3D0CUST_SALES__ZCUSTH3%26DATA_PROVIDER%3DDP;'
Drill Down
'FILTER_NODE_IOBJNM=0CUST_SALES__ZCUSTH3;FILTER_VALUE='&@Cust_Hie_Incl_Self_3_key&';FILTER_COLLAPSE= ;FILTER_IOBJNM=0CUST_SALES__ZCUSTH3;CMD_1=CMD%3DDRILL_TO_LEVEL%26LEVEL%3D2%26IOBJNM%3D0CUST_SALES__ZCUSTH3%26DATA_PROVIDER%3DDP;'
Thanks in Advance
Hi
In that document the code is given only for drilling down to the second level, it will not go below that.
If you want to drill down below that then you have to modify the code like below -
'FILTER_NODE_IOBJNM=0CUST_SALES__ZCUSTH3;FILTER_VALUE='&@Cust_Hie_Incl_Self_3_key&';FILTER_COLLAPSE= ;FILTER_IOBJNM=0CUST_SALES__ZCUSTH3;CMD_1=CMD%3DDRILL_TO_LEVEL%26LEVEL%3D4%26IOBJNM%3D0CUST_SALES__ZCUSTH3%26DATA_PROVIDER%3DDP;'
where you find "%3D2%" it will drill down to second level. After 'D' enter the level to which you want to drill down. If you enter "%3D4%" it will allow you to drill down to 4 th level below the Parent node.
Also there is space after the "FILTER_IOBJNM". Just refer the notes at the end of that document. You need to modify the code accordingly.
Regards
Sandeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.