Ah you're right. Shame...

This is a (modified) query of mine that uses a range. I constructed this query using the designer and the range operator, like I mentioned earlier.

At the end, I replaced...

It is not working as in ... ?

In your original question, you posted two clustered indexes, which is not possible.

Which one is it?

Can you post the table DDL?

Some sample data is appreciated as well.

I see. Take a look at this article:

Order and Sort with MDX in SQL Server Analysis Services[/url]

When you build your dimension, you need to include the ID (for example 01 for January) in the key of the month attribute. Then you need to put the OrderBy...

The analyst is just a spy from Microsoft trying to sell you an Enterprise license. 🙂

craig.bobchin (6/11/2014)

No error, it seems to just be passed by when I have bad credentials in the...

In the query designer, you can also create filter expression using a range. Simply set the operator to range. You now have two values you can specify. When you mark...

You need enterprise/BI for Tabular, but not for multidimensional.

The question is if you...

Small bit of advice: you probably don't want to give two different questions the same topic name.

Now everyone thinks this question is a duplicate of your other replication question.

There is a catch though:

SQL Server 2012 Service Pack 2 is available - but there's a catch!

Why doesn't this script work for you? Does it give an error?

Yet another great question thanks.

The page USER_NAME (Transact-SQL) does mention that dbo is returned for sysadmins in example B.

So it probably...