Skip to Content
0
Former Member
Jan 02, 2006 at 10:52 PM

Report error with u0093variable in currency translationu0094

12 Views

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