Data Warehousing Community Forum
December 19, 2018, 10:18:18 pm

Pages: [1]   Go Down
  Print  
Author Topic: Calculate gross profit, yearly sales,monthly sales,weekly sales?  (Read 12195 times)
bakhtawar
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
http://oi58.tinypic.com/9upt29.jpg
now how i calculate yearly sales, monthly sales, and also gross profit.

create procedure spgrossprofit
as
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
  Print  
Jump to: