| MDX-Query to get latest months and previous years same months data |
| Written by Vidas Matelis | |||
| Tuesday, 03 April 2007 19:37 | |||
|
Q: Need MDX Query to get latest months and previous years same months data A: You can use ClosingPeriod function to get last month member and then use ParallelPeriod function to get previous years same month
Result:
|
Comments (2)
Most read
- How to install Adventure Works SQL DW and Analysis Services 2005/2008 sample database and project
- MDX-How can I get Last (Previous) Year to Date (YTD) values?
- Analysis Services 2005 error: Errors in the metadata manager. The attribute with ID of ., Name of . refer
- MDX-How do you format or round KPI expression value?
- MDX-How do you calculate monthly average of one year, optionally including empty months?
Top Rated
- How to install Adventure Works SQL DW and Analysis Services 2005/2008 sample database and project
- Analysis Services 2005 XMLA script to add/drop existing partition aggregate
- Why In Reporting Services MDX query disappears after leaving "Data" tab.
- When accessing calculation tab in BIDS I am getting error Unexpected error occurred
- In an MDX query how can I get the top 3 sales years based on the order quantity?
- What TCP port SQL Server Analysis Services 2005 uses
- How to calculate YTD monthly average and compare it over several years for the same selected month
- Analysis Services 2005 error: Errors in the metadata manager. The attribute with ID of ., Name of . refer
To run sample code you have to instal Analysis Services, then download and install Adventure Works database, deploy this sample solution and then you'll be able to run MDX queries.
To install Adventure Works DW database follow this link:
http://www.ssas-info.com/analysis-services-faq/29-mgmt/242-how-install-adventure-works-dw-database-analysis-services-2005-sample-database
(like GalaXQL).
It seems that the only way to practice is having BIDS and still you will need a datasource cube to run queires against.
Is there another way?