OLAP Cube

Reply

sukino Posted: 12-07-2007 12:08 PM

rated by 0 users

I am trying to create this cube in Analysis manager (SQL server 2000).

Fact Tables

ItemLedgerInfo - Measures: Quantity, DocumentDate

Dimensions

Item - Measure: Item Description (Order By Item No)
Manufacturer - Measure: Manufacturer Code
Location - Measure: Location ID

Is there anyway to query the data using the olap cube such that I could specify DocumentDate <= ParameterDate?

Currently I am using Excel spreadsheet to read from the olap cube as the datasource and display it as a pivot table.