Problem in getting BW hierarchy in VC

[Former Member]

Hi experts,

I'm following the How-To instructions to show BW hierarchy in VC, but it doesn't work.

Showing Error "Nested Exception INVALID_VARIABLE_VALUES"

The drill down command is:

'FILTER_NODE_IOBJNM=0H_GLACC;FILTER_VALUE='& #ID[ACCGQ2]@Fincl_Statement_Item_key &';FILTER_COLLAPSE= ;FILTER_IOBJNM=0H_GLACC;CMD_1=CMD%3DDRILL_TO_LEVEL%26LEVEL%3D2%26IOBJNM%3D0H_GLACC%26DATA_PROVIDER%3DDP;'

We are using VC-7.0 on SP13.

Regards,

Pankaj.

[former_member272962]

Hi Pankaj,

Please validate if you have an extra space between your && when entering your char_key. Please see below.

Original

'FILTER_NODE_IOBJNM=0H_GLACC;FILTER_VALUE='& #IDACCGQ2@Fincl_Statement_Item_key &';FILTER_COLLAPSE= ;FILTER_IOBJNM=0H_GLACC;CMD_1=CMD%3DDRILL_TO_LEVEL%26LEVEL%3D2%26IOBJNM%3D0H_GLACC%26DATA_PROVIDER%3DDP;'

Fixed

'FILTER_NODE_IOBJNM=0H_GLACC;FILTER_VALUE='&#ID[ACCGQ2]@Fincl_Statement_Item_key &';FILTER_COLLAPSE= ;FILTER_IOBJNM=0H_GLACC;CMD_1=CMD%3DDRILL_TO_LEVEL%26LEVEL%3D2%26IOBJNM%3D0H_GLACC%26DATA_PROVIDER%3DDP;'

I'd first try with the removal of the space between & and # for the first char_key statement.

Edited by: Andrew Cho on Aug 13, 2008 4:14 PM

[Former Member]

Thanks for reply, I removed the space then also problem persists.

Any idea???

Regards

pankaj Kumar

[Former Member]

I solved it by making some changes in formula.

Regards,

Pankaj