Hi Team,
I have to calculate Sales Volume, Sales Cost, Sales Revenue.
I don't have Accounting Knowledge.
Please confirm if the below dimensions are sufficient to calculate and also suggest any new parameters required in dimension
1. Sales Volume
Account
Time
DataSrc
Category
Entity
Product
Quantity
2. Sales Cost
Account
Time
DataSrc
Category
Entity
Cost Type
Rptcurrency
3. Sales Revenue
Account
Time
DataSrc
Category
Entity
Rptcurrency
Time Category
What are the parameters required to build these dimensions to calculate Sales Volume, Sales Cost and Sales Revenue ?
What are the required formulas to calculate these and Script logic/Business rules required to calculate?
Regards,
Phanikumar