Hi guys!
I just started building OLAP cubes and not sure if I am doing right. I have a table in MS SQL Server 2000 containing SalesmanID, CustomerID, ProductID and DeliveryDate by day. I need to creat a cube with dimensions:[Salesman],[Customer],[Product],[DeliveryDate] and SalesQuantity as a Measure. Is there a way of building MonthToDayThisYear and MonthToDayLastYear, YTDThisYear and YTDLastYear SalesQuantity, By Quarter, by week in MS Analysis Services? Should I create a view from the same table which I am using as a fact table for DeliveryDate as a Time dimension?
I just started building OLAP cubes and not sure if I am doing right. I have a table in MS SQL Server 2000 containing SalesmanID, CustomerID, ProductID and DeliveryDate by day. I need to creat a cube with dimensions:[Salesman],[Customer],[Product],[DeliveryDate] and SalesQuantity as a Measure. Is there a way of building MonthToDayThisYear and MonthToDayLastYear, YTDThisYear and YTDLastYear SalesQuantity, By Quarter, by week in MS Analysis Services? Should I create a view from the same table which I am using as a fact table for DeliveryDate as a Time dimension?