in the maintenance plan task for delete old bakcup file: if you specifiy "include subfolder" (sp1 only) you must add a "\" after the path specification, and always remember that...

Thank you very much Steve! As ever provide good idea and solutions! My compliments!

Ciao,

Marco.

Hi Steve, what is the addin you mention ? Are you refer the Sql Accelerator (Retail Analitics and Sales & Marketing) or there are something more that I NEED TO...

I think the problem is that you probably use two separated statement (and so, using odbc, it means two scope) for the select scope_identity ().

Use a unique statement for the insert...

May be you can use the sp_altermessage 515, 'WITH_LOG', 'true' to write to log!

Although I remember a very nice article by Amit Jethva just some day ago... take the time...

Hi Chris,

Which version of Excel are you using ?

With the XP or 2003 version there aren't problem! Just put the dimension in the pivot table schema, select a member that...

I also recommend Owc, due to cost and simpleness of use. A thing that I found very interesting is the "Office Xp web component toolpack". It contains a lot of...

If you don't want to use neither log table or sql server log then are not solution! Wait for Yukon!

But which kind of language you use to develop your...

Hi Nico,

do you know where I can see features of this new product "Excel OLAP reporting" ?

thank's in advance,

Marco.

Once again I have to give my thanks. I perfectly understood, what to do.

I think this is a very very useful techniques to get the YTD measures, and surely I...

Uhm... may be I'don't understand your last answer, what means a calc member in time dimension ?

It would means that I can add a calc member and set the parent...

Oh yes, may be! , I'm going to search this component!

Thank's once again, Steve.

Marco.

Hi Steve,

first of all thank you very much for your reply.

At this moment I have a separate cube for each distinct measures, and it work well. Although, my customers want...

Oh no, probably my question is written poor, I want to do a distinct count of customer, day by day, on Analysis Serivices, not Query Analyzer! I 'm talking...

Thanks dgermundson,

But How I can put your T-SQL query in Analysis server ?