hi,
Is it possible to change default hierarchy of a dimension by program or
AS2005 UI?

For example, the account dimension in finance cube in adventure dw has
'account nember' as default hierarchy, I just want to change it to 'accounts'
hierarchy.

Thanks for any help.

Xie Zheng

seamus

Ther eis no notion of default hierarchy.
in BI dev studio we choose the first hierarchy (whether attribute hierarchy
or user hierarchy) that we find to browse in the dimension browser....
In the cube browser when you drag the dimension we select by defualt the
first user hierarchy and if there is none, then the first attribute hierarchy.
But this is not a engine setting, this wa sjust a choice we made in our
browser as we thought it was the way must user would expect it to work.
In other words it is up to the client tool to decide the behavior for
selecting default hierarhcy when user is dragging the dimension in rows or
column...

"Xie Zheng" wrote:

Many thanks. I think I get your point.

In fact, we are just implementing a bi project with a client tool. When
opening a cube, not like excel pivottable shows blank query, this client tool
will automatically execute a query based on default member of default
hierarcy of dimensions(I think this is friendly for user guide). But since
the default hierarchy of some dimensions is not the item user mainly cares
for, an additional action to select other hierarchy has to be made every time
which maybe let user feel a little un-comfortable. It's able to adjust
default member but it seems to be a pity for default hierarchy in server end.


"Thierry" wrote:

Actually there is a default hierarchy -- it is the first visible
user-defined hierarchy in the dimension. If there are no user-defined
hierarchies then it will be the first visible attribute hierarchy.

This can be found in the MDSCHEMA_DIMENSIONS schema rowset:

http://msdn2.microsoft.com/en-us/library/ms126180.aspx

DEFAULT_HIERARCHY
DBTYPE_WSTR

A hierarchy from the dimension. Preserved for backwards compatibility.



But I believe there was some issue when you change the default hierarchy
(drag the default one to be the first one). If you make sure that you create
the dimension with the default hierarchy as the first one, then you should
see it show up correctly as the DEFAULT_HIERARCHY for the dimension.

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Xie Zheng" <XieZheng (AT) discussions (DOT) microsoft.com> wrote

Thanks, We have learned the DEFAULT_HIERARCHY property can work well by such
as AdomdClient. We are just confused that no place to change its value once
dimensions were created in server end. I think we have to pay attention to
the issue of hierarchy order when begining to create dimension.

It's true that draging the hierarchy within dimension attributes tree panel
does not work.

"Akshai Mirchandani [MS]" wrote: