Data Warehousing Community Forum
October 24, 2019, 01:19:28 am

Pages: [1]   Go Down
Author Topic: Calculate gross profit, yearly sales,monthly sales,weekly sales?  (Read 14440 times)
DW Fresher

Reputation: +0/-0
Offline Offline

Posts: 2

View Profile
« on: November 29, 2014, 01:40:04 pm »

hi all

i try to create procedures according to these conditions

What are my yearly sales?
What are my monthly sales?
What are my weekly sales?
What are my daily sales?
What is my Gross Profit?
What is my Gross Sales?
this is star schema
this is the link of image
now how i calculate yearly sales, monthly sales, and also gross profit.

create procedure spgrossprofit
select  as grossprofit from dimfact

now which aggregate function i use for calculate above conditions?

any help?
« Last Edit: November 29, 2014, 01:42:44 pm by bakhtawar » Logged
Pages: [1]   Go Up
Jump to: