Skip to Content
0
Former Member
Apr 01, 2014 at 12:31 PM

Selective deletion on Semantically partioned Cube?

116 Views

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