How to find published cube in SSAS

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

How to find published cube in SSAS

Author

Topic

learntsql

524 Posts

Posted - 2013-11-19 : 11:37:35

Hi All,

I am recently looking into some existing application(unfortunately no KT has given me on this)
There is a SQL agent job created to refresh the cube but in Analysis service i am unable to find that cube.
I can also see model (solution) files in some drive for this cube.
Is there any way to find the cube from SQL Agent job or any other way to find it?
Please help me with some solution.
Its really appreciated.
TIA.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-11-20 : 02:18:58

First thing to see is if you've access to the cube. FOr that you might need to check with dbas. Once you find that cube really exists then you can request access to see it.In case it doesnt exist, you might have check within your source code repository to see if analysis service project is present somewhere.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

learntsql

524 Posts

Posted - 2013-11-20 : 02:23:38

Thanks Visakh,

I checked with my DBA i did not have an access for this cube.
I might be getting it today.
Thanks for you quick help.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-11-20 : 02:36:52

quote:
Originally posted by learntsql

Thanks Visakh,

I checked with my DBA i did not have an access for this cube.
I might be getting it today.
Thanks for you quick help.

you're welcome

Once you get it
You can open it in Business Intelligence STudio by choosing File-> Open-> Analysis Services Database and giving server name and cubename and you'll get entire cube project created on your Business Intelligence STudio with all Dimensions, Measures, Calculations, Partitions etc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources