Skip to Content
0
Former Member
Jul 13, 2010 at 04:05 AM

Dimensions for Sales Volume

56 Views

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