Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Kimball Forum

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


Exisiting SQL Server 2005 cube, how to find storage mode ?

Kimball Forum :: Topics :: BI and Analytics

Go down

Exisiting SQL Server 2005 cube, how to find storage mode ? Empty Exisiting SQL Server 2005 cube, how to find storage mode ?

Post  alpha_a Tue Jul 31, 2012 9:05 am

Hello,

I have to work on an existing cube in SQL Server 2005 & would like to tell which storage mode it uses.
Simply right clicking the cube & viewing it's properties doesn't help.
Any suggestions ?

Thank you.

alpha_a

Posts : 12
Join date : 2012-07-31

Back to top Go down

Exisiting SQL Server 2005 cube, how to find storage mode ? Empty Solved

Post  alpha_a Tue Jul 31, 2012 10:24 am

I guess I found the solution myself.
I was trying to work it out on BI dev studio. I was able to get the storage mode using SQL Mgt studio.
I just went there, connected to the cube (under object explorer, Connect -> Analysis services), then right clicked the fact tables and dimensions, the storage mode is under properties.

alpha_a

Posts : 12
Join date : 2012-07-31

Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: BI and Analytics

 
Permissions in this forum:
You cannot reply to topics in this forum