Data distribution from calmonth to calweek

[Former Member]

Hello all,

I have designed a plan query for inserting data at 0calmonth.

I want that while saving to cube the data should be saved also at the 0calweek.

How to do this...?

Regards,

Pratighya

[Former Member]

Hi Pratighya,

The only solution to do this is to build a conversion table in which you put the percentage of the month for each week. Something like this:

Week month %

1 ____ 1____ 4.8%

2 ____ 1____ 23.8%

3 ____ 1____ 23.8%

4 ____ 1____ 23.8%

5 ____ 1____ 23.8%

6 ____ 2____ 25%

7 ____ 2____ 25%

8 ____ 2____ 25%

9 ____ 2____ 25%

10____ 3____ 22.7%

....

14____ 3____ 9.1%

14____ 4____ 13.6%

etc.

The percentage is depending on whether you use working days or all calenders days in a month.

The amount for a specifice month must be divided over the weeks.

Success,

Udo

[Former Member]

Hi Udo,

How and where to build this conversion table?

Regards,

Pratighya

[Former Member]

Hi,

You can build this in BI, just creating an infoobject ZCALWEEK (YYYYWW) compounding 0CALMONTH.

and adding an infoobject Percentage.(ZPERC or something like that)

The table can be filled manually.(maintain masterdata).

Then you have to build an ABAP routine in your transformation which looks up in a loop all ZCALWEEKs belonging to a month and writes a record for every ZCALWEEK with the calculated amount.

I am not an ABAP programmer, so I cannot help you with that, but it should not be to hard to accomplish.

Success,

Udo

[Former Member]

Hello Udo,

I think in saving the plan data from query to cube the transformations are not used.

So how should this abap rotine work?

Reagrds,

Pratighya

[Former Member]

Hi,

First save the month data, then create transformation with the cube as datasource.

(e.g. into a DSO and then back to the cube again)

Udo