Thank you sushila.  I am always happy to give people an alternative way to think about things.  

joe joe,

You can also use regular expressions.

Example:

SELECT * FROM Test WHERE TESTVAL NOT LIKE '[AB]%' AND TESTVAL NOT LIKE '_[0-9]' AND TESTVAL NOT LIKE '_[0-9][0-9]'

This will choose any values...

Joejoe - if you need values that are embedded like a24b101, then you can use this code - else - just follow the previous suggestions.

First of all - the way...

Remi,

First of all, Thank you.

I know I can do this in SQL exactly as you listed, but where in Analysis Services can I type in a query like this?  I...

Back in the late 90's, when I was still primarily a programmer, I wrote a program that would import data from any source and put it into our systems standard...

Ok, so After reading the last post in here, I got pulled of to create a "Quick" Data Warehouse  (Star Schema DB, Data Cubes, BI Portal) for another client, and just...

"are you passing the uername & pwd on the DTSrun command line?  Or are you using xp_cmdshell, and setting the run as user on the sql agent step? "

Steve,

Neither.  I right...

Steve,

Now talk about a cool function with lots of power.  You just gotta ignore the Analysis Services help on that function, and do some exploring of your own.  In the...

While this was orginally scheduled to run at night, during the testing phase, I discovered this error.   Since then- I have right clicking the job and starting it manually. 

The...

I have been having issues with both the Oracle OLEDB abd Oracle ODBC drivers when using them in DTS.  Seems that if you use multiple versions of Oracle on different machines,...

Thanks SteveFromOz - That's about what I thought...

Now the fun part - trying to get the guy to leave well enough alone and let the working product be.

Wish me luck!

SteveFromOz,

FollowUp:  I am using reporting services to attach to a SQL Analysis Server.   The reporting services server is in a domain that does not have permissions to the domain with...

I agree about the trap part.  My boss understands and I am to create two seperate versions of the cube, one with totals generated by BI Portal (the client is...

Ok - now I have the Monthly Totals, YTD totals, and Previous Year Monthly Totals, and Previous Year YTD Totals, all except the monthly totals are calcualted members.  Yes, I...

Thanks stevefromOZ. 

I am attempting to use this, and figure I will be able to get it to work, but as in all things - its never quite as simple...