Data Mart : change an InfoCube after it has already been loaded with data.

[Former Member]

Hi everyone,

I need to calculate a YTD balance for 4 fiscal years which have been loaded to a total FISL cube. I plan to use the data mart to read the past fiscal periods and calculate the keyfigure 0BALANCE. Can anyone advise.

This process becomes urgent and need your help.

Many thanks. Jad

[Former Member]

Can anybody help please.

[Former Member]

why do u want to do a datamart? You said you already have the data in the cube, then you can as well use the same data to derive YTD in the query.

you can restrict ur 0BALANCe, with fiscal year (user entry, or current), period and do a offset on fiscal year by -1,-2,-3, to derive previous 3years.

If i got the whole issue wrong, can you be more elaborate?

[Former Member]

Hi voodi,

Thanks for your answer. You are right. We can do this in the query. That is how we have done until know. But for some new needs, we have to calculate the right value in the cube. In fact, in my source system, I have 2 diffrent closing date for my companies. For some of them, I get the right value for total period and YTD balance from R3. For the companies which have a diffrent closing date, I have to calculate the YTD balance according to the same closing date (as the first category). In this way, in BW, all the companies period, blance... are harmonized. These informations will be sent to another system. That is why, we have to prepare these datas in BW before sending them to the interface.

Thanks.

[Former Member]

makes sense. Are you gonna realise this req with some start routine to read the closing date and deriving the balance of other companies ... might warrant some fancy ABAP code .. keep us posted

[Former Member]

Obviously, Abap code will be there. But I don't know when I read my cube for the past fiscal years, do these data will be again inserted to my cube or not(This is actually my main question).

Should I use a full update or a delta?

If you have experience on that? Thanks.