Oh well I sorted all this out and its still failing at the second package and I cant think why.

HEYLP :crazy:

Bit more information

I have a feeling it might be because of the connections ADO-NET and OLE DB

Dim_Child and Dim_Age are both OLE DB connections because no parameters are involved

Dim_CP_registrations has...

Brilliant, thanks for that. Its all becoming a little more logical now 🙂

Debbie

Just having a quick look at this again and Im thinking percentages are always created as calculated measures in Reporting Services which will then always calculate correctly no matter where...

Ill look into that!

Ive managed to make an age dimension that contains the following e.g.

Pupil ID Date OF Birth Month year Age

1 ...

I have put population figures in a dimension 'Dim_Population_ONS' and referenced this table from the area dimension because I thought that these figures were not specifically measurements about child protection.

However...

Im thinking it may be using Anaysis Services as a calculated name set but I still need the MDX.

Ive done a really basic MDX query with the details I think...

i created another fact table 🙂

Brilliant. I added the YEAR into the SELECT Bit so I can use it later on and it works a treat.

Thanks

Debbie

Is there anyway other than using this function of doing it. I dont really want to use a function on the query If I dont have too.

Ah ha. It turned out that ar DB team could still see the database but I couldnt. The database got deleted and then the project was reproccessed and it...

Im wondering if there are any useful documents on line that can give really good information on what CROSS APPLY is and how it can be used. Ive had a...

ahhhhh come on. I knew that I just wasnt thinking and put cross join instead of cross apply:-)

Thanks all.

I have just used the query in my original SP instead of the ridiculously long one and it works a treat.

I hope at some point I will be able...

Ooooh the first one brings bacl 12 rows and the next one brings back 9 rows.

Im going to have a look at both of them. I need to find out...