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
2. Sales Cost
3. Sales Revenue
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?
Hi Phani Kumar,
Deciding the structure completely depends on the business. Without the understanding of the business, it will be very difficult to propose what dimensions are required.
However, few pointers. I am not sure, what is the basis for considering volume, cost, and revenue. Usually, I will keep one application for calculating revenue. Revenue will be calculated as volume * unit price. So, there will be 3 account members - revenue, volume, and unit price. This particular application should have
Account, Time, Category, Entity, Rptcurrency
You can have more dimensions also, based on the business need.
Hope this helps.