Recent content by Rob999

Hi Everyone. I need to add a calculated measure to my cube file for the number of occurrences of a transaction type based on a key field. If the transaction occurred, there will be a 4 to 5 digit ID, else a 0. The problem is when I do a Distinct Count by adding a new measure, I can't put a...

Hi guys, thanks a bunch for the replies. MDXer, I was hoping to just have one comprehensive view of the business - something '05 is supposed to allow. I believe a view would separate the data and I would have to do something to reconnect them at some point. But that may be my only option...

Hi everyone. I've looked around and haven't seen this, so here goes. I'm creating a Fact table of customer transactions where approximately 5 - 10% of the transactions belong to a "promotion" - type event, and get an alphanumeric Promotion Code for the transaction. I update all the other...

Thanks rwei, I've managed to make due in the interim through trial and error (and books online), but I'll look into these. Hopefully a new book will address Office XP and 2003!

Hello again everyone. Within 1 hour of the first table not being visible in the Enterprise Manager, but being available to the system, they're both now visible (and yes, I refreshed the tables view a number of times). I guess it might have been a network transmission problem - or something?

Hello everyone. I believe I'm the dbo on my database that I created under my windows login, which resides on a network server. Under this db, dbo is shown as the only user and I'm using Windows authentication. I've created a number of tables, both via query and DTS import. The last two...

Actually, I head that that particular VB test had a 1st time failure rate of about 75%. I passed it in 2001 (Exam Cram, Transcender, Oreilly's MCSD book and 2 years daily coding) by the skin of my teeth - my lowest score on my four exams by about a 100 points. Everyone thinks the Distributed...

Does anyone know about ETL tool throughput rates? Impressions or links would be useful, as I may have to make that decision if our CRM warehouse uses a vendor that doesn't have an ETL tool - like a Microstrategy. They pretty much recommend Microsoft DTS, while the Hyperion rep admitted that...

Thanks MDXer, We do have a very detailed set of questions we're asking. The vendors for the most part are hesitatnt to dish dirt on the opposition, but a lot of that seems to be based on a lack of info on their competitors. Of course, Microstrategy's website dished a lot of dirt, particularly...

I liked the Exam Cram book, though I don't know if you can still find it. Plus I used Transcender and worked with SQL Server 2K daily for almost a year by that time. Check out Amazon.com for reviews on the books.

Troytech was AWFUL. SmartCertify wasn't AS bad - but it wasn't worth the money and they had no specific exam materials. Just "Intro to" type courses. Cert Success = Transcenders + good study guide + experience. Use Amazon.com to find a good study guide, as the reviews are invaluable, as well...

Hi guys. I'm a VB6 MCSD (finished 10/02), and I've moved int a new project management - thanks in large part to the MCSD - so I'm not sure if I'll upgrade to .Net any time soon. I was only 1 test from my MCDBA when this position came along, but I devoted all my energy to project management...

Hello again. We're wrapping the requirements gathering stage (and my wife had our first baby a few weeks ago), so it's time to get back to round #2 of the BI vendors derby. We've been pretty straightforward with each vendor about who else we were looking at and some of them had no hesitation...

Thanks for the input JH. Because of numerous competitive advantages we have, the Data warehouse may not be as much about "keeping up" with our competition, as it is staying ahead. So I don't know that building the industry's best data warehouse (it's not going to happen - too many others have...

Thanks very much for the input! Just how much work is involved in building preaggregations for all of these combinations of data elements selected for reporting / cubes? Is it - as I believed was mentioned here - a matter of looking at what has been run consistently and then building the...