Avoid Locks on Planning Area/Cube Read Only

[Former Member]

Hi,

I have 2 basic planning areas which are added to a multi planning area. My users will enter data into one of these cubes. The other cube is just to read some reference numbers for validation etc. I do not want any locks to be created on the the read only cube.

What is the best way to ensure this ?

Thanks

Shailesh

[Former Member · Accepted solution]

Shailesh,

Do you have a requirement to read the data from the BCS cube live as it keeps

getting updated or is there a lead time to read that data ?

If the reference data is too small, have you considered copying it from BCS

cube to your BPS cube into some special periods then use it for validation.

Hope this helps.

Cheers

Srini

[Former Member · Accepted solution]

To do the copy I would still have to put the BCS cube in my planning area. Now will the execution of the copy not put a lock on the bcs cube data?

[Former Member · Accepted solution]

Shailesh,

Only the dataset that you are writing to, will be locked and this is defined in

your level defintion.How often do you anticipate this function to be executed?

If it isn't that often, you could even schedule it as a batch job and trigger it

in the background at your non-peak hours.

Hope this helps.

Cheers

Srini

[Former Member · Accepted solution]

My requirement is the real time update of data from the BCS cube to the BPS Layout. To avoid a lock on the BCS cube, I will need a function which reads from the BCS cube even though it is not included in the planning package/area. Is this possible ?

[Former Member · Accepted solution]

Hi Shailesh,

Create a planning function on multiplaning area to copy the data from read cube (P_AREA_READ) to plan cube(P_AREA_PLAN). (Use standard copy function.) In the planning level restrict "Plng Area" = P_AREA_PLAN. do not select P_AREA_READ in planning area or planning package. in the copy function select "Plng Area" into Fields to be changed. Select "P_AREA_READ" in 'From planning area' and "P_AREA_PLAN" in 'To planning area'.

Call this planning function on layout opening. this will ensure the real time data in the planning layout.

Lock mechanism on data:-

Lock set on the data select on the planning level. data will be locked as per the selection condition on the level. so if you select only planning area, data will be locked for that planning area only.

Data locking never happens on the read data. In standard copy function all the restriction on "From" fields are only for read data. so lock will not set on the data in the "From" fields.

Regards

Tarun Malik

[Former Member · Accepted solution]

Thanks Tarun. That was helpful

[Former Member]

Hi Shaileash,

Create read only cube as "Basic Cube" and plan cube as "Transactional cube".

Regards

Tarun

[Former Member]

I forgot to mention this. I cannot do that. The actuals cube is a BCS cube which needs to be a transactional cube.