Interactive Sort

I'm using the interactive sort in a report. Can I pass in the previously
sorted column so that a user could build a sort order of their choice using
two or more columns by appending their prior selections to the sort?Hi Brent,
Thanks for your posting.
From your descriptions, I understood you would like to know whether it is
possible to specify two or more columns to make interactive sorting. If I
have misunderstood your concern, please feel free to point it out.
Based on my knowledge, we are not able to use previously sorted column. To
make priority of sorted columns, you are encouraged to Parameterized
Sorting. Specify two or more parameters and then combile them in a dynamic
query. For more detailed information, see section "Parameterized Sorting"
below
Sorting Data
http://msdn2.microsoft.com/en-us/library/ms157313.aspx
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Intelligent "bubble up exceptions"

Hi,

I basically understood how to build bubble up exceptions... You i.e. can mark (by changing the background color to red) a region if in one the cities below the sales are dramatically below the targets... That's quite simple MDX...

A customer now asks for "make this pro-active/intelligent" meaning "change the background color to red if something on any level below this value is worth a look"...

This is something the Data Mining Add-Ins for Excel can do... You have a table in Excel and the Add-Ins allow you to find "special values" and mark them...

Did someone already build this into a standard cube? What steps do you have to perform?

THANKS,

I have only seen this with the ProClarity KPI Builder, part of ProClarity Professional. There is a template for "Bubble up exceptions" and I have tried it in a project. It works well.

Regards

Thomas Ivarsson