Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


MDX to manage a cube default

MDX to manage a cube default

MDX to manage a cube default

I have a number of source systems in my cube data, the facts therefore can be sliced by a SourceSystem dimension. There is a requirement to exclude one of the source systems from the default.

Normally a default on the dimension would include one or more source systems [Policy].[SourceSystem].&[601], but I in effect have to do the opposite and not use this default MDX in an inclusive manner, but rather use it in an exclusive manner (I.e. Default to exclude SourceSystem 501). So I can only see two options:

1) Use an MDX script that somehow works in the opposite manner as the example [Policy].[SourceSystem].&[601] to exclude (not include) 501 as a default position, or

2) Use the less preferred option by speficying all the SourceSystems, except 501, which must be included in a default position, for example include 101, 201, 301, 401, and 601, so using some sort of MDX script to specify multiple defaults, not just [Policy].[SourceSystem].&[601]
- this is the less preferred option as it will require maintenance if new source systems come on board

Are either of these two MDX scripts possible??

Hertfordshire, England

RE: MDX to manage a cube default

Could you Clarify what you mean by default?  MDX can touch so many places that he term Default is very confusing.

RE: MDX to manage a cube default

There SSAS2005 is a DefaultMember property for each Dimension attribute. In there you have the ability to use MDX to define the default that will apply across the cube.

Hertfordshire, England

RE: MDX to manage a cube default

You could try the Filter or IIF Functions to omit the values of the member you don't want included.

RE: MDX to manage a cube default

I am still at a loss as to how I would use it. For example the IIF (expression, true part, flase part) would require me to exclude 501 somehow. The DefaultMember property normally only requires a very simple MDX statement such as [Policy].[SourceSystem].&[601]. This would slioce the whole cube as a default start point with 601. Off-course if this property is left blank then the cube would default to the ALL member for that dimension. Is there not a way in MDX to say "Not 601" for example like in T-SQL where SourceSystem <> 601?  

Hertfordshire, England

RE: MDX to manage a cube default


I have a problem in runing clustering algorithm for anomaly detection on cube. I wand filter many of my transactions in filter wizard by MDX operator for creating normal data for training phase. But i don't know how i can write a Query In "MDX builder"???? please write an example. where is the all examples about that??? is there any book or pdf about that????

Please Guid me

RE: MDX to manage a cube default

In the absenswe of in depth knowledge of your problem, try the book "Fast track to MDX" by Mark Whitehorn which gives good guidance on MDX queries.


Hertfordshire, England

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close