cancel
Showing results for 
Search instead for 
Did you mean: 

How to bulid WHERE statement in transformation between two cubes

Former Member
0 Kudos

Hi,

I have inventory cube that stores receipts(0CPTSTREBU) by week (0CALWEEK). I want to move this data to a new cube that will have fixed week buckets (example - week1, week2, week3....etc).

Now my requirement is - when I move the the receipt quantity to new cube say in

1. bucket1/week1 - I want to restrict it by 0CALWEEK = current week

2. bucket2/week2 - I want to restrcit it by 0CALWEEK = current week -1...etc.

that means for week1, get receipt qty where 0CALWEEK = current week, for week2, get receipt qty where 0CALWEEK = current week-1 and so on.


Can I use transformation formula to achieve this? If yes, how?

Note: I tried using this in BEX, but ended with performance issue. So, trying to see if if can be achieved at cube level.

Regards,

Pat

Accepted Solutions (0)

Answers (3)

Answers (3)

Loed
Active Contributor
0 Kudos

Hi,

How will you determine which is WEEK1? Is it the WEEK1 to WEEK52 of the year or WEEK1 to WEEK5 of the month? Can you post a sample data?

Regards,

Loed

amine_lamkaissi
Active Contributor
0 Kudos

Hi Pat,

I think an abap routine is a better solution in your case.

Amine

Former Member
0 Kudos

Hi Pat

you have to do snapshots of each week using APDs. See below doc