Offset Variable on ZCALQUARTER not working

[former_member585782]

Hi,

We use BW 7.5 SP06

I created characteristic ZCALQUART by copying 0CALQUARTER.

The problem is in BEX the offset on variable of ZCALQUART works only in interval one YEAR. For example variable "XXX" get value 2.2018 if I put: "XXX" - 1 it works and show 1.2018 but if I put "XXX" - 3 it does not work.

If I do all that manipulations with variable on 0CALQUARTER it works.

Please help to find solution, maybe I must do some additional tunning with my ZCALQURAT characteristic?

[FCI]

Question was how. By using 0CALQUARTER as a reference or as a model ?

Anyway, as you can't create new time characteristics. The characteristic you created is a normal characteristic. I'm not surprised that it behaves differently than the original one.

[former_member186445]

please elaborate on 'you can't create new time characteristics'?.

[FCI]

When trying to create a new time char:

As quarter is a NUMC type, I'm not surprised you have issues with offset when using a non-time char. This is working for dates because of the DATS type but I'm not so sure it works for NUMC types (CALMONTH, CALQUARTER...).

[former_member186445]

he should just create the z object with the 0 object as reference and it should work just fine. he can even use the same variables if it concerns a referenced object

[FCI]

Maybe you're right. I actually never had to create new char of this type. I was just pointing out the fact that 0CALQUARTER is a time char as ZCALQUARTER can't be.

[former_member186445]

you can use any char as a reference for z object

0quarter-reference.jpg

[FCI]

Yep, but it won't be a time characteristic (you won't be able to add it in the time dimension of a cube for instance). Don't know if there is other differences...

[former_member585782]

Thanks for your answer, maybe I wasn't clear in my post, excuse me for my English.

I created ZCALQUART same as 0CALQUARTER (data type, master data, length, ...)

[former_member585782]

The reason of that I didn't use 0CALQUARTER and didn't create Z inf obj as reference is that I used in my DSO 0CALMONTH. If I use 0CALMONTH and 0CALQUARTER Bex report couldn't show me the data like these:

Product | 0CALMONTH | 0CALQUARTER | SUM

A 06.2018 1.2018 1000

month JUN must be in 2-nd quarter

[FCI]

And why so ? You can have unrelated time dimensions in the same DSO (a 0CALMONTH and a 0CALQUARTER independant)