I actually thought the same thing but thought I was being a little pedantic. Good point about the user not knowing what is showing on printed matter.

I am going to...

Thanks for the response.

I managed to trace the problem and found that there is a dimension called 'Aggregation' that runs MDX from itself and that is causing the problem. It...

SSC-Enthusiastic

You are the best. I have been trying to come up with something to overcome the 1000 limit on and off for the last few weeks.

Brilliant solution and thanks to...

I finally have a solution:

1. Create a variable that I fill with a sql script to get all the where clauses from a parameter table

2. Create a ForEach Loop for...

This is a quick and crude example. Apologies if I cause offence on the data, its just a quick example I often use.

In this example Cus_Name ACME appears twice

CREATE TABLE...

Thanks, SSC-Enthusiastic. I accept your point and I will be picking the tutor's brain when I attend the course.

I have more of an idea now on how I may base...

Thanks for the replies. Unfortunately, the Conditional Split functionality is not much use to me as some of the records will fail multiple rules. I need to have a separate...