Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Help on MDX Query ...Very Urgent Expand / Collapse
Author
Message
Posted Thursday, October 11, 2012 11:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 29, 2013 9:13 PM
Points: 20, Visits: 68
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
Post #1371703
Posted Thursday, October 11, 2012 1:05 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:13 PM
Points: 12,995, Visits: 12,414
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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1371743
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse