/* ¸µÅ©µå ¼­¹ö Á¶È¸ */
EXEC sp_helpserver

/* ¸µÅ©µå ¼­¹ö »èÁ¦ ¹× Ãß°¡ */
EXEC sp_dropserver 'vEduDevOLAP'

EXEC sp_addlinkedserver
     @server='vEduDevOLAP',       /* local SQL name given to the linked server */
     @srvproduct='',          /* not used */
     @provider='MSOLAP',      /* OLE DB provider */
     @datasrc='vEduDev',      /* analysis server name (machine name) */
     @catalog='AW Test'      /* default catalog/database */

/* ¸µÅ©µå ¼­¹öÀÇ Å×À̺í Á¶È¸ */
EXEC sp_tables_ex
   @table_server='vEduDevOLAP'

/* ¸µÅ©µå ¼­¹ö Å×À̺íÀÇ ÃøÁ¤°ª°ú Â÷¿ø Á¶È¸ */
EXEC sp_columns_ex 
   @table_server='vEduDevOLAP',
   @table_name='Internet Orders'

/* ¸µÅ©µå ¼­¹ö MDX Execute */
SELECT * 
FROM OpenQuery(vEduDevOLAP,'SELECT --measures.members 
  {Measures.[Internet Sales Amount]} ON COLUMNS, 
  [Date].[Month].members ON ROWS 
FROM [Adventure Works]') 

SELECT * 
FROM OPENQUERY(vEduDevOLAP,'WITH MEMBER Measures.Test AS ''1'' 
SELECT {Measures.Members,Measures.Test} ON COLUMNS FROM [Adventure Works]')

/* ¸µÅ©µå ¼­¹ö Dynamic Management View(DMV) Execute */
-- Cube Á¶È¸
SELECT * 
FROM OpenQuery(vEduDevOLAP,'
SELECT CUBE_NAME
 , BASE_CUBE_NAME 
  FROM $system.MDSCHEMA_CUBES
 WHERE CUBE_SOURCE = 1
') 

-- Dimension Á¶È¸
SELECT * 
FROM OpenQuery(vEduDevOLAP,'
SELECT *
  FROM $system.MDSCHEMA_CUBES
 WHERE CUBE_SOURCE = 2
') 

-- Date Â÷¿ø Á¶È¸
SELECT * 
FROM OpenQuery(vEduDevOLAP,'
SELECT *
  FROM SYSTEMRESTRICTSCHEMA (
  $SYSTEM.DISCOVER_DIMENSION_STAT
, DIMENSION_NAME = ''Date''
, DATABASE_NAME=''Adventure Works DW 2008'')
') 

-- PARTITION Á¶È¸
SELECT * 
FROM OpenQuery(vEduDevOLAP,'
SELECT * FROM SYSTEMRESTRICTSCHEMA(
  $SYSTEM.DISCOVER_PARTITION_DIMENSION_STAT
, CUBE_NAME = ''Adventure Works''
, DATABASE_NAME = ''Adventure Works DW''
, MEASURE_GROUP_NAME = ''Sales Summary''
, PARTITION_NAME=''Total_Sales_2001''
)
')

-- AGGREGATION Á¶È¸
SELECT * 
FROM OpenQuery(vEduDevOLAP,'
SELECT * 
FROM SystemRestrictSchema($system.discover_partition_stat
        ,DATABASE_NAME = ''Adventure Works DW 2008''
        ,CUBE_NAME = ''Adventure Works''
        ,MEASURE_GROUP_NAME = ''Internet Sales''
        ,PARTITION_NAME = ''Internet_Sales_2003'')
')