Offset Variable on ZCALQUARTER not working

[#1]

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?

[cornelia_lezoch]

Hi Amirkhan,

as the other guys alread tried to tell you - you Z-object NEEDS to use the 0-Obect as reference.

what is the data that you want to use:

201802

201801

201704

How shall a nummeric info object "know" that 201704 is equivalent to "201801 - 1"???

This is something that only a time char is able to do. Therfore your char NEEDS to be a time char and this can only be done by referencing it.

regards

Cornelia

[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 Member]

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 Member]

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 Member]

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 Member]

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 Member]

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)

[Former Member]

what do you mean whit copy? is 0calquarter used as reference or as template?

[Former Member]

I created another Z info object like 0CALQUARTER

[Former Member]

again, what do you mean with 'like'? did you use it as template or as a reference. if you don't know what i mean with this question or if you don't know the answer, i can't help you.