Syntax passing variables from Webi to Xcelsius

[Former Member]

Hi everyone,

I need to know what is the correct syntax for passing an specific variable from webi to xcelsius.

There are 3 filters in my webi report:

Year

Month

Sales Office

The problem is the syntax for sales office, I've tried several combinations of syntaxes and xcelsius does not update the information. If I use only year and month it works, but I need sales office too.

Example:

Syntax in webi:

Year: 2015                                              (description)              

Month: [0CALMONTH2].[11]                  (tech name)

Sales Offie: [0SALES_OFF].[MX01]       (tech name)

I have tried also with:

MX01               (key)

Sales Off. 1     (description)

Syntax in Xcelcius:

The syntax for year is: 2015 [0CALYEAR].[2015]                        ---which is correct

The syntax for Month is: [0CALMONTH2].[11]                             ---which is correct

The syntax for Sales Office is: MX01 [0SALES_OFF].[MX01]     ---it does not work

I have tried also with:

- [0SALES_OFF].[MX01]

- MX01

- Sales Off. [0SALES_OFF].[Sales Off.]

And it does not work neither.

What is the correct syntax for passing sales office parameter from webi to xcelsius?

Thanks in advance.

[former_member216148]

Hi..Please check following links on this issue.

Syntax for passing Xcelsius parameters to Webi Report

Warm Regards

Saad