Good morning.

We are building a client for MSAS in C++. The client accesses the
server through OLE DB for OLAP. However, we can not get access to
certain properties of levels from the schema rowsets, and thus are
considering using DSO to get the remaining properties we are
interested in. Specifically, we want to determine the uniqueness of
member *names* within a level (unique within level / unique within
parent / not unique) for a custom feature. We would appreciate any
help with the following questions:

1. Can we assume any user that has access to the cube through OLE DB
for OLAP will have read access through DSO. Do you need to be a member
of the 'OLAP Administrators' group to use DSO at all?

2. Is there information in BOL, or elsewhere, on redistributing DSO.

3. Is DSO replaced entirely in Yukon by AMO?

4. Are these properties accessible somewhere in the schema rowsets and
we just haven't found them?

5. Are there any source code examples of DSO access through C++ that
compile in Visual Studio .NET? Many of the examples we've found
compile in Visual Studio 6 but not .NET.

thanks for any help.

Chris

Yes. You are correct. You MUST be a member of the OLAP Administrators group
to use DSO.

See the SQL Server redist.txt on any SQL Server distribution. It spells out
what you can legally redistribute.

Yes. There is an updated version of DSO, called DSO9, but it can only be
used if to administer a cube which has had the Migration Wizard ran against
it and then never had it modified (i.e. DSO9 assumes that the only
structures in-place are those that the Migration Wizard does -- it will get
confused if it runs into something that you have changed by-hand). For most
things we recommend that you use the new AMO structures as it can navigate
any Yukon structure (whether it was created by the Migration Wizard, or the
Intellicube Wizard, or by-hand.

No. Member uniqueness is only visible via DSO

You are right most of the sample code out there is VS6; not .NET.
The best example of .NET code (although it uses VB.NET; not C++ or C#) is
the DSO/XML utility -- who's source code is available as a free download at:
http://www.microsoft.com/downloads/d...DisplayLang=en

Hope that helps.
--
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.

"Chris Stolte" <cstolte (AT) graphics (DOT) stanford.edu> wrote