With all my experience in AS, the following are the two features I
would love to see in it:

1.
Properties for Calculated Members

2.
"Default Set" - per dimension (Just like "default member")

Thx

If you have something you'd like to see in a future version of SQL Server,
please send it in an email to sqlwish (AT) microsoft (DOT) com. That gets your wishes
directly into the inbox of the folks who actually make the product
decisions. You may not necessarily get anything other than an autoresponse,
but it will be read by members of the development team.

--
Sincerely,
Stephen Dybing

This posting is provided "AS IS" with no warranties, and confers no rights.

"Harsh" <creative (AT) mailcity (DOT) com> wrote

Currently - there is no 'default set'.

It picks two dimensions - one for row and one for columns.

And the 'default set' for those two - is all the members of their
first level - below 'All Level'.

It picks the dimension highest in the aplhabet order... and then shows
it on rows. And puts measures on the columns (analysis manager does
that)

Some browsing tools - pick the first two dimensions in an alphabetical
order for rows and columns (Crystal)

Some browsing tools pick time for the columns. And 'All level' of the
dimension highest in the aplhabet order for rows...


All this is too inconsistent. And third party tools make their own
decisions...

This is where I would love to have the control...

Define what dimensions show up on rows and columns...

and then - define - what members from each one of them show up as
well...

The idea of showing Time or Measures on columns by default is not
bad... however... not always the best one.


There are lots of properties for 'Dimension Type' and that's what the
tools use... to display the defaults... however...


It would be best if:

1. Define what dimensions are primary (by default on rows/ columns).
Even this could be MDX driven

2. Define what's the default set for these two dimensions. (Easier if
default set is only for the primary dimensions). The default set would
get active when those dimensions are dragged onto rows and columns.
Option to 'Aggregate' the defaultset when they are on the slicer. Or
default on a seperate defaultmember when the dimension is on the
slicer.

Ah, I misunderstood you.

I thought you meant that for every dimension you define a default set and then the user could have the option of just selecting the name of the dimension and the default set would be supplied.

What you actually mean is to define what should by default appear on the rows and columns if the user doesn't select anything. Is that right? I've a couple of comments on that:
1) What if the user didn't want anything at all on a particular axis?
2) Why should a default set be limited to only containing members from a single dimension? As we know tuples in a set can be made of of members from different dimensions - why not a default set work the same way? [In this case a default set would be defined as a property of a cube rather than a dimension]

Some interesting points anyway.

Regards
Jamie


"Harsh" wrote:

You have a good point about Tuples...



I have been requested for this "hopping" from one hierarchy to another
also. But doesn't it seem like something a browsing tool would do?
i.e. find the current leaf member in the other hierarchy and display
their parents etc. It doesn't even have to restricted to leaf members.
It could happen at any common level.

I can't think how any feature changes in analysis services could help
in this though.


This is definitely needed!

Sorry - I misundertood your idea in my last posing:

I solved your issue once through Custom Member Formula / Custom Rollup formula.