cancel
Showing results for 
Search instead for 
Did you mean: 

IP - characteristic relationship/ data slices

Former Member
0 Kudos
415

Hi Guys,

I am very new to IP and would like to have some help regarding the following with some simple example

1) characteristic relationship

2) data slices

3) locking

Some examples with the above is much appreciated.

where can i get some good document explaining this ?

Thanks in advance...

Accepted Solutions (0)

Answers (1)

Answers (1)

balajee_sivakumar
Contributor
0 Kudos

Hi,

Please find below the examples for characteristic relationship and data slice,

1. Characteristic relationship:

Consider that you have characteristics called "Country" and "Continent" in your report (also in aggreagtion level).

You cannot always expect the end user to enter the correct continent for a country. In this case, you can create a char rel

based on the relastionship between these two characteristics (attribute, hierarchy or relationship data loaded to a DSO),where the source is "Country" and the target is "Continent". So when ever the user enters country and continent the char rel validates the entry based on the reference data (master data, hierrarchy or DSO data) and throws error if it s wrong. Apart from this by creating "With derivation" char rel, you can even derive continent value from country with out the user even entering the value in thye report.

2. Data Slice:

Consider that your planning requirement is you need to plan on a monthly basis which is like during current month you caa plan for the next month. In this case all other months except the next month should not be available for planning. In this case you can create a daat slice of type "Selection" where in you select '0CALMNONTH' and then filter it to the variable '0CMONTH' +1

where in you "Exclude" this selection. So now all the other months except next month at any point of time will be disabled for planning.

You can go through the following links for your reference,

Char rel - [http://help.sap.com/SAPHELP_NW04s/helpdata/EN/43/1c3d0f31b70701e10000000a422035/frameset.htm]

Data slice - [http://help.sap.com/SAPHELP_NW04s/helpdata/EN/43/1c3d0f31b70701e10000000a422035/frameset.htm]

Hope this solves your doubt.

Regards,

Balajee

Former Member
0 Kudos

Perfect answer...great help...any example for locking and how to handle it...

balajee_sivakumar
Contributor
0 Kudos

Hi,

Consider that in your project you are having country based planning where in the end users from different countries are doing Revenue planning using the same planning Analyzer report. In this case the end user from country 'India' should not be able to edit the records posted by user from country 'Germany'. So you have to go the tcode: RSPLSE and then select the 'Lock Characteristics' tab. Now you will get the list of characteristics that are 'Lock-Relevant' and 'Not Lock-Relevant'. By default all the characteristics in the planning infocube will be selected as 'Lock-Relevant'. Actually for good performance you can select only the lock required characteristics as 'Lock-Relevant'. But you have to do through analysis before moving any characteristic from 'Lock-Relevant' list to 'Not Lock-Relevant list. In our case since 'Country' is already 'Lock-Relevant', the user from 'India' will not be able to edit the records pertaining to the Country 'Germany'.

Hope this solves your doubt.

You can also refer to the below link for more details on Locking,

[http://help.sap.com/SAPHELP_NW04s/helpdata/EN/44/588168ce8c08fae10000000a422035/frameset.htm]

Regards,

Balajee