For production they will, at the the moment I was looking at the issue of joining into the multiple matching columns

The view works fine when deployed manually. I think i am going to have to create a dacpac and reference that

Nope, still getting a unresolved reference to object error when i try the build. Has this worked for you?

Ah good thought.

I thought i I created one to cover it it would try an evaluate that also and kick up an error.

I'll give it a go!

Thanks buddy

thanks

This is very old I know, but I am getting this error: Could not load the DLL C:\Program Files\Microsoft SQL Server\MSSQL12.VSQLDEV\MSSQL\Binn\xp_nysiis.dll, or one of the DLLs it references. Reason:...

Thanks Phil,

Don't suppose you know if you can get this free if you are an MCP?

Thanks, had come across it but haven't read anywhere anything for 2015. Must be part of SQL 2016 release.

Thanks but that is about memory not CPU and the link to the desktop

ah that's great! many thanks

partial re-writes of stored procedures on how the aggregations are done.

Thanks for that, the sort cost increases when doing the pre-aggregation, however the overall run time does down as well estimate IO etc

thanks, there is a message about spilling into tempdb. This is currently being run on a dev server though which is shared and much different from the production...

Thanks for the reply.

the table will be dropped and recreated form scratch once a week our of BAU and the used only to be absorbed into QlikView.

There is some conditions...

found this which seems a good start:

http://download.microsoft.com/download/0/F/B/0FBFAA46-2BFD-478F-8E56-7BF3C672DF9D/SQL%20Server%202012%20Tutorials%20-%20Analysis%20Services%20Multidimensional%20Modeling.pdf