BUG: MDX Query Does Not Return Correct Results When Writeback Data Is Not Committed (819541)

MORE INFORMATION

When you commit the writeback, Analysis Services updates the value on the server. Hence, when you query the virtual dimension after the commit, you receive the updated values.

For a regular dimension, Analysis Services resolves the value on the client. Hence, when you query a regular dimension, the MDX query returns the updated values.

Steps to Reproduce the Behavior

To reproduce the behavior, follow these steps:

1. Start the MDX Sample application, and then select the Foodmart 2000 database.
2. Run the following UPDATE statement in the MDX Sample application:

   UPDATE CUBE [Warehouse]
   SET ([Measures].[Units Ordered],[Time].[1997],[Warehouse].[All Warehouses].[USA].[CA],
   [Store Size in SQFT],[Store].[All Stores].[USA].[CA].[Los Angeles].[Store 7],
   [Product].[All Products].[Drink].[Dairy].[Dairy].[Milk].[Even Better].[Even Better 2% Milk],
   [Store Type].[All Store Type])=200 USE_WEIGHTED_ALLOCATION
   

3. Run the following MDX statement to show that a query with a regular dimension returns the updated value:

   SELECT FROM [Warehouse]
   WHERE ([Measures].[Units Ordered],[Time].[1997],[Warehouse].[All Warehouses].[USA].[CA],
   [Store Size in SQFT],[Store].[All Stores].[USA].[CA].[Los Angeles].[Store 7],
   [Product].[All Products].[Drink].[Dairy].[Dairy].[Milk].[Even Better].[Even Better 2% Milk],
   [Store Type].[All Store Type])
   

4. Run the following MDX statement to show that a query with virtual dimensions returns the original value:

   SELECT FROM [Warehouse]
   WHERE ([Measures].[Units Ordered],[Time].[1997],[Warehouse].[All Warehouses].[USA].[CA],
   [Store Size in SQFT].[All Store Size in SQFT].[23598],[Store].[All Stores],
   [Product].[All Products].[Drink].[Dairy].[Dairy].[Milk].[Even Better].[Even Better 2% Milk],
   [Store Type].[All Store Type].[Supermarket])