Data Slice

[Former Member]

Hi

I have two planning areas, one for HR and other for cost center planning. For all the planning related to HR is done is HR planning area and posted to Cost center to respective cost elements using copy function. Cost center layout will allow users to plan other cost elements apart from the costs posted from HR planning area. We are using the cost element hierarchy in the lead column of cost center planning layout.

My question here is, how should I be able to protect the user from changing the cost elements that are coming from HR planning area in cost center planning layout? If I use data slice, my copy function would give an error when it is copying these cost elements from HR area.

Any ideas around it are most welcome. Thanks Raj.

[Former Member]

Hi,

We have exactly the same issue; details as follows.

The same user has access to the Salary Cube/planning area where detailed salary planning is conducted. Then we map the results to the Cost Elements in the CC Cube/ planning area via a multi-area. The last step is for the <u>same user</u> to complete the Cost element planning in the CC Cube by Cost Centre. The cost Elements are displayed as a hierarchy (Lead Column of Layout)

I have created a data slice on the CC Planning Area containing a user defined variable for the Cost Centre with defined Cost elements to be locked. This locks the selected Cost elements to data entry in the layout.

<b>Option 1</b> (prefered)

Using the Multi-planning area, To be able to create a planing sequence which.

1/ Deactivates the data slice

2/ copy the results from the Salary planning to the CC planning for defined cost elements

3/ Reactivate the Data slice.

<b>Option 2</b> (work around)

Create a copy of the Cost Element Hierarchy for planning data entry that excludes the Salary Cost elements that are filled from the Salary planning. To see the total costs and revenues planned - use a report.

<b>Question</b>:

To save time, does anybody know the program that needs to be called to deactivate and reactive the data slice?

[Former Member]

Hi Experts,

Is there any function module to activate and deactivate data slice which can be called in global planning sequence. I liked the way to deactivate data slice and copy HR and activate again.

Thanks,

Raj.

[Former Member]

Hi Raj,

data slices are stored in the table UPC_DATASLICE with its status ACTIVE/INACTIVE.

Look into these function modules and use the same as per ur requirements to activate/deactivate.

UPC_DATASLICE_INIT

UPC_DATASLICE_COMMIT

UPC_DATASLICE_SAVE

hope it helps.

[Former Member]

Hi Hari,

Thanks a lot for your quick response.

I want to use below function modules to solve my problem with copying the HR cost into cost center planning.

I have data slice on HR cost elements and I am coping to these elements using fox function. Now I want to call function module to deactivate particular data slice and run copy function and activate it back.

This copy is being done at each cost center level based on user authorization at cost center.

Thanks,

Raj.

[Former Member]

Hi Raj,

If i understood your question correctly,

you can't call any external funciton from within FOX.

you got to go for exit function to "activate data slices by calling external functions".

hope it helps.

[Former Member]

Thanks a lot Hari. I understood whole thing and have a nice time.

[Former Member]

If you are using the GUI and excel, use SAPAfterDataPut to change the specific rows containing HR costelements to be read-only. This way u can ensure that the data that comes from HR is not over-written by users.

Hope this helps

NS

[former_member93896]

Raj,

use a user-dependent variable for cost element in the data slice. This way data will be locked only for certain users.

Regards

Marc

SAP NetWeaver RIG

[Former Member]

Hi,

You could try to exclude your HR cost element in your planning level but include them in the layout. Consequently, BPS will only display these cost elements (the other will be input ready.

Hope it helps

Anthony

[Former Member]

Hi Boujema & Marc

I am using the hierarchy in the lead column for cost element so I don't know how can I exclude the some cost elements from the hierarchy and include them in the layout.

Marc>>>I didn't understand on how can I achieve this using the user specific variable because the data should be locked for every user for 5 cost elements in the cost element hierarchy.

looking forward for response.

Thanks,

Raj.

[Former Member]

Hi Raj,

Marc's solution is probably the only one. What you need to do is limit the slice to only the users accessing the layout. That way the user triggering the copy from HR (hopefully not the same as the ones doing cost center planning) will not run into a lock. Yet the users will.

It's a tricky one. There is no node exclusion feature on variables. If you select multiples nodes, you will be asked to select one. If you restrict the level with a FM derived list of cost elements, the layout will no longer display a hierarchy...good luck.

One thing to note is that if you deploy the layout on web using Excel on web, you won't have the hierarchy any way.

[Former Member]

Raj,

I think there are two ways it could be achieved with the following assumption: Data is copied for only specific cost centers from HR to Cost Center cube (that is the list is static not dynamic). If so

Option 1

Create a fixed variable for cost center and exclude those values in the ranges (as there is no exclude button)

Put that variable in the planning package. So now since you have the hierarchy it will display all values but user can change only data for the values defined in the variable in the package which has exclusions for the cost centers being copied.

Advantage: Simple configuration and quick.

Disadvantage: Only one user can plan for cost center at a time as he locks all the cost centers.

Option 2

Make cost center authorization specific and assign each user the specific cost centers he can work with. Then you could create a variable authorization relevant.

Advantages: Not all cost centers are locked.

Disadvantage: If the same user is copying and planning then there might be a chance of an overlap if the user selects the wrong value. Needs more work and additional load on security team of maintaining the user profile.

If the cost centers being copied over are not fixed then with your current design I am not sure how you can overcome locking issues with users selecting values.

Hope this helps.

Akash