Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the below Product Master Table in my app:
PRODUCT_KEY
PRODUCT
..
..
CATEGORY_KEY
CATEGORY
..
I have a requirement to design a table for product sales. The below is the table Attributes required:
PRODUCT
PRODUCT SALES VALUE
CATEGORY SALES VALUE
Here the category Sales Value is the total sales for the specific category to which the product belongs to.
I know this can be done by Set Analysis. Someone can guide me please?
Can you give screenshot of your data model?
My data model is very detailed. I cannot share as is.
pls. take any simplest standard sample with PRODUCT dimension or any other and SALES fact.