You have an orphaned fact record, with no key lookup to the Dimension. As mentioned process the dimension. You may have to consider how the data is moved, (what the...

Have you had a look at the FILTER function?

I use

SQL Server 2008 (or other year version) MDX

Step by Step

It is not light reading but it brings you into the world of MDX in at a comfortable...

When you create a report it is customary to point it to test data. When a report is published the connection should be pointing to a live database. Since the...

Since this creates a table you are looking at a relational database that happens holds dimensional data. These serve as the basis for the cube (itself a database-non relational) but...

When your code reaches the statement

if (@Due = 'All') set @sql = 'Select * From ##temp'

It is realising that @due has not been declared. The '@due' in the string above...

Lowell's solution is a good one. The Image datatype is deprecated thus the need for varbinary(max).

Hi - If I understood correctly :

It looks like your first step is a [boxes] entity/table.

A stored procedure could go through the order, determine how many boxes are...

I suggest also running

dbcc useroptions on the database(s) the report points to.

This will let you know for sure the language setting used on the target.

Regards.

"But something like "amount of purchases last 12 Month" < 6 might be useful, and categories might mess this up "

A good point but it still all fits. If the...

Hi - to answer your question, create a domain admin account on your network if you haven't done so already. Use this same account to run the Agent service on...

I suppose create a trace in profiler to see what connections to your database are coming from other servers and using the account that ssrs is running under. If the...

One reason I think this is not a good practice is that the cardinality can be quite high. This can be valid to do if business regards this as important....

It is suggested you use a single domain account for all SQL server agents, a domain admin to allow access to share folders. Make sure it has 'log on as...

Do dbcc useroptions to see what lanugage you are using. Us_English will recognize 10-11-12 as Oct 11 2012. But British English will see it as Nov 10.

From here do...