[ mssql ] query OLAP cube from MSSQL Management Studio

1. connect > analysis service

Image

2.

– browse cube

– slide and dice

Image

NOTE that multidimensional expression (MDX) can be used to query

For example,

test_mdx

SELECT
{ [Measures].[Extended Amount] }
ON COLUMNS,
{ [Due Date].[Fiscal Quarter - Month].[Fiscal Quarter].&[1].&[7].&[20050713],
[Due Date].[Fiscal Quarter - Month].[Fiscal Quarter].&[1].&[7].&[20050714],
[Due Date].[Fiscal Quarter - Month].[Fiscal Quarter].&[1].&[7].&[20050715] }
ON ROWS
FROM "InternetSales"
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s