cancel
Showing results for 
Search instead for 
Did you mean: 

organizational change best practices

Former Member
0 Kudos

Hi,

with every organizational change we need to repost the data in the infocubes, it's becoming very time consuming task.

how do you deal with such requirements ?

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

sander_vanwilligen
Active Contributor
0 Kudos

Hi,

Please share more information re. your data model and explain what are the pain points. In theory Navigational Attributes should be the solution but a real-life example could clarify your scenario.

Best regards,

Sander

Former Member
0 Kudos

Hi Sander,

Here is the situation, currently in SAP ECC each customer have multiples sales representatives, and every sales representative visits the customer only for some specific product categoies, so for a specific product category and a specific client there is only one sales  representative.


Sales representative is designed as “partner function” in the customer master data (table KNVP)

The relation between a sales representative and product categories is N:N and  evolves frequently

In the sales document cube, we have the customer, the sales representative and product, the product category  is a navigational attribute of product

the pain point is that every time a product category for a customer changes to a new sales representative we have to repost the data, wich is very painful.

Thanks.

sander_vanwilligen
Active Contributor
0 Kudos

Hi,

Your scenario will be difficult / impossible to model using a navigational attribute. I suggest to evaluate using a Virtual Characteristic.

Virtual Characteristics can be implemented using BAdI RSROA_OLAP_BADI. You will need a table (DSO) where you store the combination of Customer, Product Category and Sales Rep. The BAdI will read this table during run-time. This way you can always refer to the actual Sales Rep without the need to actually store it in the transaction record.

Please refer to SAP Note 1717880 - Virtual Key Figures & Characteristics for more information.

Best regards,
Sander