Forum Discussion
Split one row into two rows
you need a flag in your Product dimension telling if product is a component or combination
or you can create mini hierarchy in the data - only report the component products, with combinations being the higher level in Product dimension
one way or the other you will need to change your tables
Hmmmmm.... thanks for the quick answer... the problem is that the date comes out Salesforce,... so the table can't be changed.
If there is any other way... else I have to check for another solution...
Thanks,
Dennis
could it be that this field is availabel in the system, but is not extracted? right now it's basically doublecounting, so I would be surprised if the system didn't have option to avoid that
otherwise, if there is a logic that you can apply to identify all this products then we can have a look into implementing it
examples that you describe make sense for a person, but are not structured enough to write some code, e.g. I have no clue if it works for SKN products
you could always do the mapping manually and blend it with your SalesForce data
Hi Stachu,
In Salesforce, we created the packages also as 1 product, so it's not in the system (at this moment).
At this moment (en at least for the comming 24 months), we only have 2 packages:
- ACN+ for DRY SKIN
- 1 ACN+ Wash
- 1 ACN+ Cream
- ACN for NORMAL TO OILY SKIN
- 1 ACN Wash
- 1 ACN Cream
So, I hope this creates an opportunity *cross the fingers*
- ACN+ for DRY SKIN
