Question:
If you want to group customers by customer group, you just need to add an attribute "customer group" in the master data of the characteristic "customer" and fill it with values,
then you can report on it, said it has been put as navigational attribute.
Now, this grouping is fixed company wide. This means that if I want a different grouping I need to add another attribute "customer group 2"...
I have a request to have as many possibility of customer groups as needed by the users. Potentially, each user would define its own grouping. So the said way of grouping is no longer possible.
I was thinking that maybe I could address this need by having hierarchies to represent the grouping needs. But the question is how can I let my users maintain their own grouping, as this can change daily ?
Any other creative alternative is welcome.
Ch
Answer:
Hmmm... first thing that comes to my mind is Classification: then at least they don't need to "do" anything in BW, it stays in R/3
You could let them assign "personal" classes to the customer master data and extract these with the standard hierarchy extractor.
However, the more i think about this, the less is seems like an option..
Though question for a Friday afternoon Ch
Answer:
With personalizations?
There is some Business content about it for costcenter reporting. Data is picked up from R/3 and loaded in ODS 0PERS_VAL
A user reports on CC's assigned to his UserId.
(No access to a system now so I dont have the details).
I can inmagine this principle can be created in R/3 for customers too.
But anyway via a flat file upload.
Just an idea and I think you can justify if it is usable.
Answer:
Who said I have an R3 system connected
(even with R3, classification is not an option as it is adding attributes to the customer, and this would mean as many attributes as different classification/users)
I also thought about personalisation, but I am not sure how it works
Up to now, my best idea is to create a table in BW via a maintenance view and tell my users to maintain it directly in BW, and then use it to daily update their personal hierarchies.
Ch