Can any one direct me to some site where I can find a good sample of cube
documentation?

I need to
1. Explain the structure of the cube
2. give information on admin areas such as processing, permissions etc.
3. And maybe explain the logic in the cube - there are several dimensions
in the cube that are sued to derive a report, but they may not make sense
to the user as such - things like a distinct count measure meets a goal if
the type of sales order is so and so....this will be built into the front
end, so no problem there. But the front end allows the user to export the
cube into a pivot table - and there the user will need to understand what
is what....How do we prepare a document for that?

TIA

--
Message posted via http://www.sqlmonster.com

Look at OLAP Scribe as a cool tool to do this.
http://www.microsoft.com/downloads/d...DisplayLang=en

It is implemented as Word macro -- feel free to modify it to pickup other
settings/structure that you wish.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"bill via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

I just tried to run this macro against my MSAS 2000 install and it keeps
failing with a VB script error. Something about subscript out of range.
This is where "Debug" takes me:

If DimensionItem.DimensionType = 1 Then strDimensionType =
"Time" Else strDimensionType = "Standard"
-> strStructure = strClassType(DimensionItem.SubClassType)
If DimensionItem.IsVirtual Then strStructure = "Virtual"

in BuildDimensions.

I'm a VBA idiot, can someone shed some light on this?


Thanks a lot-
Malcolm



"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote