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.