cancel
Showing results for 
Search instead for 
Did you mean: 

Offset Variable on ZCALQUARTER not working

0 Kudos

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?

Accepted Solutions (0)

Answers (3)

Answers (3)

cornelia_lezoch
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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

FCI
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

you can use any char as a reference for z object

0quarter-reference.jpg

FCI
Active Contributor
0 Kudos

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

0 Kudos

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

0 Kudos

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
Active Contributor
0 Kudos

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

former_member186445
Active Contributor
0 Kudos

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

0 Kudos

I created another Z info object like 0CALQUARTER

former_member186445
Active Contributor
0 Kudos

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.