BI and VC problem.

[Former Member]

hello experts.

This thread was originally posted in the VC forum, but maybe i would be able to get some answers here:

I'm trying to build a simple iView displaying a result table for a query. The input for contains only one query variable (in this case, a fiscal year/period). the variables is compound with fiscal year variant.

When i'm trying to attach a value help based on the characteristics fiscal year/period, (ext_key as a key) im getting a warning message on my VC panel :"Failed to create fields for rule input: ':' Expected ':'.it can be due to field names that have reserved words".

After deployment, the value help concatenates the variant to the selected variable thus leads to an INVALID VARIABLE error.

for example: "001.1999";; in the SAP BI and "K4/001.1999";; in the value help. No string manipulation I know of could solve the problem.

after replacing the '/' sign with ':' manually, the value became valid, but again, it didnt work when i tried to manipulate it in advance by a formula.

any ideas?

I'm using VC 7.0 SP 14.

Motty.

[Former Member]

Hi,

You can try this when you add the value help using the wizard:

On the Specify Data Service Runtime Parameters screen

In the Output section

Use Key from dropdown as key field instead of key_ext.

rgds

Deepak

[Former Member]

I'm beyond that.

It doesnt work for any option given in the drop down list.

[Former Member]

Hi

The : cud mean it is expecting an interval rather than a single value. U can check the variable definition.

Dont see any other reason unless it is some SP level issue...

rgds

Deepak

[Former Member]

I have the same problem either with single values or an interval.

[Former Member]

Hi

I wud say it should match the way variable is defined for BI query: single value or interval or select option etc.

Have no other clues.

rgds

Deepak

[Former Member]

It is defined as select option

[ChandranGanesan]

Hello Motty

See this doc

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/07134c67-0b01-0010-0493-b89287cf...

Thanks

Chandran

[Former Member]

Hi Chandran.

I know this Doc. It doesn't solve the problem in the value help formed by the wizard.

Motty.