on 10-16-2015 4:48 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.