Transcript www.sqlbi.com Dim Date Dim Geography Dim Customers Sales Dim Categories Dim Products The data warehouse is a simple and standard one, after all we will build everything in an hour…

www.sqlbi.com
Dim Date
Dim
Geography
Dim
Customers
Sales
Dim
Categories
Dim
Products
The data warehouse is
a simple and standard
one, after all we will
build everything in an
hour…
buying
NEW customers???
Class
Percentage
A (few products)
70%
B (some products)
20%
C (many products)
10%
GRAND TOTAL
100%
SUM( Amount)
GROUP BY Product
INTO #temp
SQL
UPDATE #temp
SET Percentage = RunningTotal on
Product Amount / SUM( Amount )
SQL
UPDATE product
SET Class = A/B/C (from #temp)
SQL
MDX query
on Sales cube
to extract ABC Class
Process Sales cube
OLAP
OLAP
Process Product
Dimension
UPDATE product
SET Class = A/B/C
• Update Sales aggregations
(ABC flexible attribute)
• from MDX query
• Requires ETL or Linked
Server
OLAP
SQL
DBI-B225: Microsoft “Data Explorer” for Excel
DBI-B315: Querying in DAX
http://channel9.msdn.com/Events/TechEd
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn