Documenting Cubes 1

[Flybridge]

I am having to document some cubes, which is rather laborious. The data is obviously stored somewhere.

Does anyone know where the meta data is stored and how to access it? I'd rather just write a few queries than spend ages typing into a spreadsheet.

Thanks.

Flybridge


'The world isn't round - it's bent!' Spike Milligan

 

[mrdenny]

By default there is an Access database (yeah, it's actually access) which stores the meta data. If the DBA changed the config this would have been changed to a SQL Server.

The access database will be in the install folder somewhere.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Flybridge]

Any idea where I can see this in Enterprise Manager?

From memory we think it was changed to SQL Server - and we can't see an Access file in the MSSQL folder. But nothing obvious jumps out when looking at Enterprise manager.

Thanks.


'The world isn't round - it's bent!' Spike Milligan

 

[MDXer]

The AS repository is pretty unreadable. I remember a while ago there were a few free tools on various web sites that would document the cube structure into Excel.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[Flybridge]

Thanks.

Didn't find much when I searched in Google, but I did find a reference to OLAP Scribe on the Microsoft download page. That puts it into a Word doc.

Great!

Only a slight criticism, it doesn't show all the info needed e.g. which columns are used as keys and names, but you can't have everything for free can you


'The world isn't round - it's bent!' Spike Milligan

 

[MDXer]

Found the site I was thinking of finally.

It has been a couple of years since I used it so I'm not 100% sure on what it does now but I know it did what I needed at the time.

[URL unfurl="true"]http://www.tomchester.net/[/url]

The cube documentation tool is what you want to look at.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[Flybridge]

Thanks MDXer.

That looks really useful.I'll give it a try the next time I can connect to a cube.


'The world isn't round - it's bent!' Spike Milligan

 

[justins707]

Not sure if you explored the Olap Scribe. It is a utility that will document your Analysis Services Database in MS Word.

Here is the link:

http://www.microsoft.com/downloads/...5b-4022-429f-a9d5-dfe00e8545bd&DisplayLang=en

gl,

Justin

 

[rickdll]

There is SQL documentation tool called BI Documenter -

http://www.bidocumenter.com

which i think does what you are asking for.

BI Documenter can document your Analysis Services (SSAS) databases as well your SQL databases (all the same document too).

Hope this helps you.