Partitions in BW 7.3

[Former Member]

This question is on the semantic provider partition in BW 7.3

I have the company codes in the following order

1010- BZ

1020- BZ

1030-BZ

1040- CH

1510- CH

1520- CH

1530- CH

2010- BZ

2020- CH

2030- CH

4510- CH

4520- CH

I want to make 2 partition with company codes 1010,1020,1030 and 2010 in one partition and rest in other. So basically all BZ in one partition and CH in other. Is this possible with the new functionality of BW 7.3 or do I have to make three partitions (one partition - 1010,1020,1030. second partition - 1040, 1510,1520,1530. Third partition - 2010,2020,2030,4510,4510)?

Thank you for your help.

[former_member362475 · Accepted solution]

Hi Pranoti,

Yes, you can make these two partitions with SPO in BW 7.3.

In the second step "Change Partitions" of the SPO wizard, you can specify the multiple selections of each partitions. Please refer to the screenshot as below.

Best regards,

Chen Hui

[Former Member]

Thank you all for your reply. I was able to create 2 partitions as several single values are permitted in one partitions but cannot have multiple intervals and a combination of interval and single value for each dimension.

[fcorodriguezl]

Hi Patroni!

My advice, please check:

1. How many history have.

2. If you have accumulative or non accumulative keyfigures.

3. If you have all request in PSA.

You rigth using SPO, but you need check, if apply Partitioning physical or Partitioning logic, and which it is you need.

Regards.

Frank.

[former_member183519]

HI proanati,

is BZ/CH are part of company code ? or are they different char. If ans is NO then you can create 2 partitions.

Else

you can go for 2nd approach(3 partitions).

Regards,

Hitesh

[Former Member]

Hi Pranoti,

you can go through following links:

Partitioning - Modeling - SAP Library

-Megha