Can anyone give me a suggestion on this. I'm having problem making a query
in which i need virtual dimension in one of the axis. For testing I tried to
execute it in MDX Sample Application it from "Warehouse and Sales" Cube of
FoodMart 2000:

SELECT
{[Store Type].[All Store Type]} ON COLUMNS,
{[Product].[All Products].[Non-Consumable]} ON ROWS,
{[Time]} ON PAGES
FROM [Warehouse and Sales]

There are two problems you're running into here:
1) MDX Sample App doesn't support queries with more than two axes - you'll
have to remove your PAGES axis before it will run
2) The Store Type virtual dimension isn't present in the Warehouse and Sales
cube, so you can't use it in a query! You would need to add the dimension to
the cube before you can use it.

HTH,

Chris

"shrwan" wrote: