Specifying Default Hierarchy for dimensions in Analysis Services

Specifying Default Hierarchy for dimensions in Analysis Services

Post by sandh » Thu, 20 Jun 2002 07:37:41

Is there a way to specify a hierarchy as the default for dimensions
with multiple hierarchies in Analysis Services 2000? Or is the first
hierarchy that is defined assumed to be the default?
In OLAP Clients such as ProClarity, its useful to be able to control
the defaults.

1. Creating dimension hierarchies in OLAP Services

Creating a dimension hierarchy in OLAP Services is done by importing the
underlying relational table for that dimension.

Has anyone come across a third-party (or Microsoft) product for
creating/maintaining a hierarchy where there is no data (e.g. in preparation
for inputting budget data)? I have achieved the desired result using Excel
and creating columns with parent-child relationships, but it's clumsy.

P Taylor

2. Allow user to use Ent Mgr on a single database on the server

3. Specifying An Analysis Services Database?

4. Creating a Stored Procedure to Update a table

5. Analysis Services. SQL Server 2000 Analysis Services

6. CASE Statement in Sybase XI

7. Analysis Services, Dimension Member ordering, Calculated Members


9. A question about virtual dimension in MS SQL Server2000 Analysis Service

10. Sql Server 2000 Analysis Services - Not able to process a dimension

11. Dimension Ordinal in Analysis Services?

12. Analysis services - adding information columns to a dimension

13. Memory Error processing large dimension - Analysis Services 2000 Standard Edition