Exisiting SQL Server 2005 cube, how to find storage mode ?
Page 1 of 1 • Share •
Exisiting SQL Server 2005 cube, how to find storage mode ?
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.
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
Solved
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.
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
Similar topics» ????? ????? ?????? ???? SQL Server 2005
» Can't find the solution?
» Burst Mode [BM] Quest for Partner Digimon
» tx-nr515 remote - how to use the "custom" mode button
» suntrust consolidation loan - Find cash in the same day at Same Day Loans No Credit Check
» Can't find the solution?
» Burst Mode [BM] Quest for Partner Digimon
» tx-nr515 remote - how to use the "custom" mode button
» suntrust consolidation loan - Find cash in the same day at Same Day Loans No Credit Check
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum