Skip to Content
avatar image
Former Member

Problem in getting BW hierarchy in VC

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 13, 2008 at 02:13 PM

    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

    Add comment
    10|10000 characters needed characters exceeded