Hi, I have a transactional DW that tracks fulfillment.
In the fact table I have a record for each transaction that occurs for an order. i.e. ordered, backordered, cancelled, outofstock, shipped, fulfilled etc.
So for a given order that has been fulfilled, it would have several records starting from ordered to outofstock to shipped to fulfilled.
So for example, let's say I want to get the number of orders that are outofstock but not include the ones that have been shipped or fulfilled?
The original query would be something like
Select [FulfillmentStatus].[OutofStock] on rows,
"[Measures].Members on columns " & _
"From [Fulfillment] "
But how do I filter out the ones that have been shipped?
Would I use a where clause? Please help. Thanks in advance
In the fact table I have a record for each transaction that occurs for an order. i.e. ordered, backordered, cancelled, outofstock, shipped, fulfilled etc.
So for a given order that has been fulfilled, it would have several records starting from ordered to outofstock to shipped to fulfilled.
So for example, let's say I want to get the number of orders that are outofstock but not include the ones that have been shipped or fulfilled?
The original query would be something like
Select [FulfillmentStatus].[OutofStock] on rows,
"[Measures].Members on columns " & _
"From [Fulfillment] "
But how do I filter out the ones that have been shipped?
Would I use a where clause? Please help. Thanks in advance