Instead of RANKX(ALL(whatever)

You could use RANKX(ALLSELECTED(whatever)

Hi Robin,

I think everyone's MDX journey is a little like that 😀

The problem you are having is because what you are asking MDX to display is the minimum/maximum of all...

I can verify that it does have to be unicode, having done a worldwide DW myself. You're lucky you are building from scratch and not having to switch over like...

What you have to have in mind about the WHERE clause in MDX is that in it you are supplying the context for the query (I think originally it was...

I have received an answer on the MSDN forums (word, Greg Galloway! ). It would seem that this problem is caused by overloading an INT data type. I changed...

Thanks for your comment, although that's not really the issue. The reason I am doing it in MDX is that the client needs to analyze the data dynamically and won't...

The Step by Step books are normally good. I don't think there's one out for SSRS 2012 yet but since general report development is not radically different in 2008 you...

This is a good place to start http://technet.microsoft.com/en-us/library/bb522859.aspx

🙂

Happy to help Dave 😀

Apologies I don't think my first post was that clear!

When I say composite key I mean you set it in the Key Columns property of the dimension attribute. So in...

Have you tried using composite keys for the different attributes of the hierarchy?

So at the Vehicle Code level the attribute key would be:

VehicleCategoryKey+

VehicleTypeKey+

MakeKey+

ModelKey+

VehicleCodeKey

If you don't do that then you can...

I don't know but the product help documentation can be found here:

http://www.idera.com/help/sqldoctor/3-0/default.htm

Your answer will most probably be in there. If not try the Idera support page for help.

Good Luck 🙂

Hi,

It's a little hard to tell without knowing your data structure but it seems as if your measure called "LatencyDays" needs to be split via a dimension.

It looks as...

Firstly your initial approach if I'm interpreting you correctly is a very bad idea. What happens when a user needs to see more/different data on a report? Add new column,...

There is some useful information here http://social.msdn.microsoft.com/Forums/sqlserver/en-US/d898e73c-344b-4639-b716-b3b2674b32d6/ssrs-and-teradata

They talk about parameters with teradata in SSRS (scroll down a bit).

Hope it helps 🙂