Report error with u0093variable in currency translationu0094

[Former Member]

Hi,

I'm getting following system error in BWQ when executing a query with variable in currency translation.

"Abort Variable Z101LTUSDC is not allowed for the conversion key date."

I've created currency translation Z101LTUSDC in rrc1 with following parameters.

Exchange rate type 1001

Source currency from data rec

target currency = fixed USD

Time Ref = Time Base from Variable = ZDATEVAR.

ZDATEVAR is a variable created on 0CALDAY & is included in cube1.

a Query that uses this currency translation in BWD works fine.

Now, when i run the query created on cube1 in BWQ, by using currency translation type Z101LTUSDC, I'm getting following error.

"Abort Variable Z101LTUSDC is not allowed for the conversion key date."

What is the reason for this?

It works fine in BWD but doesn't work in BWQ.

I assigned variable ZDATEVAR in the definition of currency translation type in BWD.

But, after transport, I see that variable is blank in the definition of currency translation type in BWQ.

i double checked that ZDATEVAR exist in BWQ in F4.

But, why query is taking "technical name of currency translation Z101LTUSDC" as variable date instead of "ZDATEVAR"?

transport got moved to BWQ successfully with no errors or warnings.

Appreciate any help

Hari Immadi

http://immadi.com

SEM BW Analyst

[Former Member · Accepted solution]

Hi Hari,

Check in Quality... tha variable ZDATEVAR available or not.

Collect the Query and all the query elements for that query into a request and transport again.

Srini

[Former Member · Accepted solution]

Srini,

Variable does exist in BWQ.

anyhow, the problem is now solved after transporting variable & Query.

Thanks for your help.

Hari Immadi

http://immadi.com

SEM BW Analyst