on 06-29-2018 7:45 AM
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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
76 | |
10 | |
8 | |
8 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.