Need MDX query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Need MDX query

Author

Topic

vanithagabbula
Starting Member

1 Post

Posted - 2010-03-23 : 02:47:54

Need MDX query to retrieve data between two time periods.
The below query working fine to retrieve data for the year 2008.
SELECT {[BillingFamily].[ALTRIA GROUP INC. (20133)]} ON ROWS, {[Measures].[Rating Requests]} ON

COLUMNS FROM [IVS_BillingFamily] WHERE ( [Time Period].[2008])

Need MDX query to retrieve data between 2008 and 2009

vanitha

naveengopinathasari
Yak Posting Veteran

60 Posts

Posted - 2010-03-25 : 00:46:41

SELECT {[BillingFamily].[ALTRIA GROUP INC. (20133)]} ON ROWS, {[Measures].[Rating Requests]} ON

COLUMNS FROM [IVS_BillingFamily] WHERE ( [Time Period].[2008]:[Time Period].[2009])

You will get all the details between 2008 and 2009 if you want childs you can get it also.

let me know if this helped you.

Lets unLearn

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources