How do you ...

[VBXL]

Write this to work in a MDX Query

Select a,b from ExampleTable where
a = 'XXXX'


a = Rows
b = Columns


Cheers

VBXL

 

[claws2rip]

hi....

in MDX the "where" statement works differently than it does in SQL.

to write in MDX using your example above I'm going to have to modify your example a bit.
assume u have a "State" field and a "Tools" field in your table and your tracking how many tools were sold.

here r 2 examples:
1.
this retrieves all measures being counted in all states

select measures.members on columns,
state.members on rows
from CubeName

2.
this will tell u all hammers sold in the state of kentucky
select {[Tools].[Hammer]} on columns,
{[State].[Kentucky]} on rows
From CubeName

hope this helped,
Sam