cancel
Showing results for 
Search instead for 
Did you mean: 

Dimensions for Sales Volume

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.