Search results for query: *

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...

Not yet, but it is definitely on my ever increasing to do list!

avjoshi, I think you misinterpreted a few things I said. First Vendors CAN and DO generalize a number of things when asked - it's part of making a sale. The person who made this particular comment on performance was a programmer on the system, so for the type of query he was running he knew...

I agree there are places for both as well. However the point that MOLAP is good for one thing, ROLAP for something else is moot if the vendor is committed to one exclusive of the other. If it's a MOLAP vendor, it's an easy matter to set up your own 'Data Store', use tables from a staging area...

Thanks for the input Z3. Yes, we are looking at a "huge" amount of data (at or slightly more than 1 terabyte - which will grow quickly and will close to double in 18 mos when a new tower goes online). The idea of an organic company in an environment when everyone I'm talking to just bought a...

MDXer - thanks, I will ask about that. Also, we're now considering MicroStrategy as well. Major player, good CRM features, it's been mentioned by some of the people I've talked to (including here) and honestly - they're website doesn't suck like most of the others. A lousy website from a BI...