Does anybody know if possible or how to dynamically sort dimension members by
member properties in OWC10 instead of setting sort property in AS?

Thanks in advance.

Yan

if no luck here try this:

microsoft.public.office.developer.web.components

yes i believe it's possible but I don't know how - I normally use AS and
haven't had the need to change that in the front end.

"yan" <yan (AT) discussions (DOT) microsoft.com> wrote

Yes you can. Check BOL. You can sort by name, key, or another field -- which
may just so happen to be a member property :-)

See BOL under the topic:
Specify Ordering and Uniqueness (Dimension Wizard)

--
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.


"yan" <yan (AT) discussions (DOT) microsoft.com> wrote

But it was in OWC .. then he need to use ADOMD to do so ?

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

Setting up that property sorts the members on the server-side when it is
exposed to the client. The sort sequence will be for everyone; not dynamic
per query or per user.

If you want sorting on the client-side, then sorry -- I don't know -- I'm
not an expert on the client-side. OWC does support sorting, I don't know if
it is flexible enough for what they want.
--
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.


"Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote

Thank you, Michael and Dave.

Yes, I want sorting on the client-side -- in OWC. So far as I know OWC does
support sorting by dimension members but not by member properties.

Does anybody know the other ActiveX control instead of OWC could achieve that?

Thanks,

Yan


"Dave Wickert [MSFT]" wrote: