Hey Richard,

Take a read through this, in particular the section on 'Using the ObjectExpansion attribute'. I think what you're looking for is to set it to 'ObjectProperties', as 'EXpandFull'...

Glad it worked. BTW, the sites are sqldts.com and sqlis.com.

If you only need to parameterize the where clause item, then change your statement from

Select [field] from where .[batchname] = User::vFileName

to

Select [field] from where .[batchname] = ?

If...

With that volume of records, you should be using partitioning. If you do, not only should your query reposne time be improved but it could also allow you to...

Forgot to mention, if you want to see the xmla behind any given object in the SSAS database (cube, dimension, measure group etc) you can script nearly all (if not...

If you're new to *both* XMLA and SSAS, it could be a steep learning curve depending on your background. Does it have to be XMLA that you use? The...

Is there a requirement to actually have the two DSV's? ie you can bring in tables/objects from different datasources in to the one dsv?

No prob Sharon, hope it all works out 🙂

I haven't read his SSIS one (sorry Brian) but Brian Knight (one of the guys that started SQL Server Central and also...

Not saying it's a good example but it's a quick one (btw, you may also want to check out ssis.com, the sister site of dts.com for examples, i would be...

*Theoretically* you should be able to get this to work by changing one of the entries in the *source table* that feeds the Employees dimension. There must be a...

Hey Chris,

Looks like the threads not being closed has been a problem for other people though best as I can tell, may have been fixed (see this mySQL bug report)....

Ashok, unless you're using European number formating (where . = , and , = . ) you're 'conversion' won't actualy result in a number. And assuming you did convert...

The Datepart function definitely supports minutes (see here) so the problem may be with your input column data. I was assuming you'd push in a single datetime field, but...

Not quite sure why (maybe the flight recorder?) but your system wants to run a trace. Enable the user (who's on your connection) to do this (see here) and...

The requirement, or perhaps the description of it, sounds a little off to me. Converting a time 12:10 to 12.10 just seems wrong to me. I understand you...