what is subcube ?

All Replies

• Sunday, March 17, 2013 8:22 AM

   

   
  

  0

  Hi ravindrareddyyeruva ,

  Have a look at the link below, it gives a great short explanation :

  http://msdn.microsoft.com/en-us/library/ms144916.aspx

  ---

  Regards, David .

  • Proposed As Answer by Kieran Patrick Wood Sunday, March 17, 2013 1:03 PM
  •  
  • Reply
  • Quote

   
• Sunday, March 17, 2013 8:56 AM

   

   
  

  0

  Hi,

  Thank you.

  • Reply
  • Quote

   
• Tuesday, March 19, 2013 1:28 AM

  Moderator

   

   
  

  0

  Hi,

  How to create this..how to use..please give some Description

  Thank U.

  Hi ravindrareddyyeruva,

  Please refer to the following MDX statement to create subcube:
  CREATE SUBCUBE [Adventure Works]
  AS
  SELECT [Date].[Calendar].[Calendar
  Year].&[2003] ON 0
  FROM [Adventure Works]

  For more information, please see:
  CREATE SUBCUBE Statement (MDX): http://technet.microsoft.com/en-us/library/ms144916.aspx
  How to create subcube in analysis service: http://blog.sqltechie.com/2009/10/how-to-create-subcube-in-analysis.html

  Regards,

  ---

  Elvis Long
  TechNet Community Support

  

  • Marked As Answer by ravindrareddyyeruva Friday, March 22, 2013 5:27 AM
  •  
  • Reply
  • Quote