where the cube metadata information is store?

Question

where the cube metadata information is store?

snownieve

Grasshopper

Points: 24
More actions
April 15, 2004 at 11:34 am

#111048

Hi everyone,
I'm new to data warehouse and I need to find out where does the cube's information are stored at?
Now, when I open the analysis Manager, select the Cubes folder and i select a cube on the left inside window tree on the right inside window tree the meta data displays all the cube information, eg dimension, source table, measure, etc. I need to write a crystal report that display all the cube's dimensions and measures which are display in this metadata report but i dont know where is this information is store at. is anybody out there that knows about this please answer this thread......any help will be appreciated.
thanks

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 1

Unless you've moved your repository for Analysis Services to SQL Server, look for an Access database in the bin directory called msmdrep.mdb. This is probably where the metadata you're looking for is stored. Typical location is:

C:\Program Files\Microsoft Analysis Services\Bin\msmdrep.mdb

K. Brian Kelley
@kbriankelley

snownieve Grasshopper Points: 24 More actions · Answer 2

I cannot find this file in my C directory so i will assume that the repository has been move to the SQL server....if that the case where should I look?

thanks

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 3

That is set when you choose to migrate the repository, so it could literally be anything. As for the access file, even after the repository is migrated I think the file is left. Look inside the bin directory wherever Analysis Services was installed (the server itself).

K. Brian Kelley
@kbriankelley

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 4

A quick way to find the repository is to edit the repository connection string. To do this, righ-click the server in Analysis Manager and select 'Edit Repository Connection String...' . If it's still in access, it should be using the jet driver and probably has the path to the mdb file. If its using SQLServer, then it should have the datasource (server) and Catalog(database) information contained in it. e.g. Data Source=zapwksteve;Initial Catalog=AnalysisServicesRepository

Steve.

snownieve Grasshopper Points: 24 More actions · Answer 5

Thanks for your answers. However i found the access report "smsdrep" but it does not have the metadata information. Is there any other place that should i look?

Thanks,

ap

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 6

If the OLAPObjects (in the msmdrep access database) table is empty and your Analysis Manager shows that you have objects (ie catalogs, cubes etc) then I would be guessing that your repository is stored in SQLServer. If this is the case, then I would look at the repository connection string to find out the server and database.

Alternatively, depending on the doco you are trying to produce, you could look at using either the word document template posted at microsoft.com, or perhaps the XML documentation tool, also posted at microsoft.com.

Both links can be found on my earlier post http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=17&messageid=109407 , you're looking for the OLAP Scribe and the DSO/XML tool.

Steve.

snownieve Grasshopper Points: 24 More actions · Answer 7

Thanks Steve for the information.

I downloaded and ran the word document and even though it provides the information but the document is so difficult to read. Any particular cube data is distributed in some many different areas that makes the document very difficult to follows and it has over 250 pages....i don't think that any body use this tool...it is very frustrating since it looks that you need an engineering degree just to understand the result... i don't know if to laugh or cry

Does any body out there use the DSO/XML tool? Or is there any other script available???

Thanks,

aplaud Newbie Points: 3 More actions · Answer 8

Hello Everyone.

I found an excel document that provides the cube information in concise matter. It display each cube measure and dimension by page by cube..it is a great tool to have. Enjoy.

Here is the address: http://www.tomchester.net/articlesdownloads/doc_tool.xls

Thanks to Tom Chester----I'm very happy with this tool

Thanks to everyone.

A Bloke SSC Enthusiast Points: 127 More actions · Answer 9

BI Documenter might be what you are looking for. It does SQL Server and Analysis Services databases and supports SQL Server 2000 and 2005.

http://www.bidocumenter.com