Well THATS a thousand times easier!!

Thank you 🙂

My source dates have been amended to how the user wants to view them CONVERT(VarChar(50), [Date], 103) AS [Date] Perfect for the user. Rubbish for the order by.

This is the...

Ive sorted it 🙂

The user friendly dates dont order properly. In the data source Ive created any OrderBy column that sorts.

Then using this http://dinesql.blogspot.co.uk/2011/04/ordering-attribute-members-of.html

I sent this up as...

As an addition to this I used the MDX filter to do a between clause

[SEN].[Statement First Issued Date].[01/01/1994] :[SEN].[Statement First Issued Date].[07/11/2002]

and again this doesnt work because you can only...

Here I go running tests with the new Logging In Integration Services

Test 1.

the package says its worked (All tasks go green. Usually the two cubes go to red and I...

I dont want to get to excited but I think you can set up error logging through Integration Services....

I could be wrong I need to test but.........

I shall try to...

Night mare.....

Im scuppered again.... I was very excited about setting up the log files to see what happens in the overnight process.

but if you can only set them up manually...

Argghhhhhhhh

And now I have another issue.

I go into Process, Change Settings and add in the settings to log any errors. Click OK and use.

Then when I go back the...

Sounds like you are having the same kind of week as me. The good news is I have managed to fix the dimension that was causing problems. I had some...

Ive got the same issue with the managers over here. They have no clue how a show stopper like this can change things.

Ive had a fail on a dimension over...

Oh no! 🙁

This has been my least favourite issue this year. Ive still not got my issue resolved at all.

Thanks for the extra advice. Ill get myself a block of...

herladygeekedness (8/31/2012)

---

I may have found a way around the cube being offline - when you go to process, check the options for ignoring errors. It's maybe not the best...

Yep and Ive asked for this already a fair few times....

right......

Trying very very hard to get my head round this but there are so many pieces to it, it gets very complicated.

herladygeekedness (8/31/2012)

---

The script is the second step in my...

Thanks loads for that

herladygeekedness (8/31/2012)

---

Not sure I can be much help, but "stuck for months" got to me.

When I get a cube processing error, I usually can fix it by...