Re: I'm looking for a metadata cube/dimension dependency report



Ok this is an awesome, awesome reporting tool. If my repository ever
gets seriously damaged, I have documentation that would help rebuild
it. The only thing that's missing is the ER diagram.

Here's are things I will (someday) change:
- It generated 500 pages of doc - so I'll probably remove most of the
carriage returns.
- Even though I told it to ignore 1/2 dozen cubes, it still included
them in the dimension listing. -- I'll have it ignore dimensions from
cubes that I'm ignoring!
- There is no mapping of what dimensions are used in what cubes -- only
what cubes use what dimensions. -- I'll add the opposite mapping as
well.
- It gives me an error message "This is not a valid action for the end
of a row." (I somehow got past this) -- Hope to fix that bug.
- It then generated some weird looking stuff at the end. -- probably
due to the above bug.

But, hey, I now have some automated documenation!

Nice job, Microsoft.

.



Relevant Pages

  • Looking for detailed programming reference for AMO for SQL Server 2005
    ... builds dimensions & cubes to SQL Server 2005 and AMO. ... MS documentation of the object model and class library pretty weak. ...
    (microsoft.public.sqlserver.olap)
  • Re: Analysis Manager Operations extremely slow
    ... > cubes each with about 9 regular dimensions, ... > I checked the mdb repository size to be close to 10MB. ... I migrated the repository to a local SQL Server instance ...
    (microsoft.public.sqlserver.olap)
  • Re: Processing of complex AS 2005 DBs - only reliable from BI Dev
    ... Could you run SQL Profiler and make sure that this is happening? ... You would see at the beginning statements to process all dimensions. ... is there anything special to cubes that fail? ... SQL Server Management studio. ...
    (microsoft.public.sqlserver.olap)
  • Re: Processing of Cubes/Dimension hangs
    ... Yes if a OLAP db has 5 cubes and 20 odd dimensions then ... and then hangs? ...
    (microsoft.public.sqlserver.olap)
  • Re: Error executing MDX query
    ... The cubes this error occurs for are 1.08 MB and 13.2 MB. ... The other 2 are 1680 and 2 members each. ... What are the sizes of the two dimensions that you are crossjoining? ... Blog: http://www.geekswithblogs.net/darrengosbell ...
    (microsoft.public.sqlserver.olap)