Question Re: Offset Variable on ZCALQUARTER not working in Technology Q&A

Offset Variable on ZCALQUARTER not working

Former Member — Fri, 29 Jun 2018 06:45:48 GMT

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?

Re: Offset Variable on ZCALQUARTER not working

Former Member — Fri, 29 Jun 2018 07:56:43 GMT

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

Re: Offset Variable on ZCALQUARTER not working

Former Member — Fri, 29 Jun 2018 09:14:59 GMT

I created another Z info object like 0CALQUARTER

Re: Offset Variable on ZCALQUARTER not working

Former Member — Fri, 29 Jun 2018 09:30:55 GMT

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.

Re: Offset Variable on ZCALQUARTER not working

FCI — Fri, 29 Jun 2018 09:39:08 GMT

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.

Re: Offset Variable on ZCALQUARTER not working

Former Member — Fri, 29 Jun 2018 09:50:21 GMT

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

Re: Offset Variable on ZCALQUARTER not working

FCI — Fri, 29 Jun 2018 10:00:12 GMT

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...).

Re: Offset Variable on ZCALQUARTER not working

Former Member — Fri, 29 Jun 2018 10:02:34 GMT

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

Re: Offset Variable on ZCALQUARTER not working

FCI — Fri, 29 Jun 2018 10:05:31 GMT

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.

Re: Offset Variable on ZCALQUARTER not working

Former Member — Fri, 29 Jun 2018 10:09:24 GMT

you can use any char as a reference for z object

0quarter-reference.jpg

Re: Offset Variable on ZCALQUARTER not working

FCI — Fri, 29 Jun 2018 10:13:59 GMT

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...

Re: Offset Variable on ZCALQUARTER not working

Former Member — Fri, 29 Jun 2018 14:27:47 GMT

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, ...)

Re: Offset Variable on ZCALQUARTER not working

Former Member — Fri, 29 Jun 2018 14:36:31 GMT

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

Re: Offset Variable on ZCALQUARTER not working

FCI — Fri, 29 Jun 2018 14:45:39 GMT

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

Re: Offset Variable on ZCALQUARTER not working

cornelia_lezoch — Wed, 04 Jul 2018 09:01:14 GMT

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