It's a known flaw in the IIF evaluation. Check out this page as a suggested work around, there are others on the web.

And if it *is* a homework problem, a quick google search produces some approaches that use SSIS transforms to handle this problem.

OWC is a client technology, and am guessing you're using BIDS on your local - have you tried to install /update your local machine?

Create the target (perhaps using something like this) and load it. Your constraint of wanting to do a SELECT INTO but not being able to see/utilize [server2] from [server1] makes...

From what I understand, it would influence the use (or not) of the next couple of entries (i.e. datastore Page and HashPage size). They're probably set to 8kb. Assuming it's...

Funnily enough, that works (adding the spaces) but does mean you'll need to clean them up before loading to your target.

Hey Phil, whadidya call me?!?! LOL

I know, it seems strange but i couldnt think of how else to describe it.

Maybe a better way is - ragged right only...

As is often the case, you're right Koen, but I'm also a little right... 😉 I looked only at the CUBES rowset, which *does* have the datetime of...

Quick response - I would go with a scripting approach like this[/url]. Does this suck? Yes.

Longer response - the definition of ragged right is that all columns are fixed width...

Should be able to use the DMV's if you're on 2008+

http://msdn.microsoft.com/en-us/library/hh230820(v=sql.110).aspx

So if you had special gift wrapping (a service) would you be as concerned that your "Product" dimension contains "Services" as well? I guess I'm not seeing the problem here....

I'd leave them in as "products" and utilize another attribute to allow for filtering of "type". e.g. these could be considered "fees & charges" vs "seat".

A variant on this is...

You're trying to use a flathead screw driver as a chisel.... not the right tool for the job. It's doable but there are other approaches much better suited. Powershell...

So, will there be a dimensional attribute that the user can select to inform us of the 'selected' period (eg month)? Or alternatively, will they need ot select a forecast...

Confusing much? 😉

I guess another way to ask this is, are you looking to have a measure that shows whatever actuals exist plus whatever forecast exists (ie for whatever...