sainatth.wagh (10/11/2012)
Hi,Can somebody sent me syntax for the mdx query for with a drillthrough option, and to find data for the specific month.
Let me know if somebody would provide any input on it.
Thanks,
Sainatth Wagh
Did you try BOL or google? No offense but you will find an answer a lot quicker by looking for the answer instead of asking somebody else to hand you the answer. What do you mean by find data for the specific month? I assume you mean a where clause in an MDX query? With the addition of "Very Urgent" in the title I assume this must be either for an interview or a test.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/