asranantha,

MDX is used against OLAP sources (ie 'cubes'). You've provided no details of your cube at all, only a DB table.

Have you built your cube yet? If so, maybe if you outline the fact and dimension tables (ie the source) and then anything you may have done with the creation of the dims and measure groups, including what your measures are, *then* you might have more luck getting a response form someone who simply writes the mdx for you.