Hi,
I am using BI 7.3 and have a requiement to optimize current dataflow where locking is a prominent issue.
My simple data flow is DS-> DSO->Cube->MP->Report. This is a adhoc load and when multiple country execute simulataneously, they lock each other. Now i want to partition DSO and cube using 7.3 SPO concept based on Company code. I have been successful in creating the objects.
Now i have one problem that there is also one selective deletion on cube, now since the SPO cube looks like below
SPO
-SPO Partition 1
-SPO Partition 2
-SPO Partition 3
my question is that do i have to create selective del. on SPO object or on individual partion. My worry is if i create sel del on SPO for a particular company code then it should not be locking cube for other company code. where as if i create sel del at individual partioned, then its a cumbersome process to create for each partition. Can you please guide how to handle this scenario.
Reagrds
Prashant