on 09-23-2015 7:13 AM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.