Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Rob999

  1. Rob999

    DISTINCT COUNT Where Value > 0

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

    Seldom used Dimension member

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

    Seldom used Dimension member

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

    Office Web Components - Pivot Tables

    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!
  5. Rob999

    Can't see new tables

    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?
  6. Rob999

    Can't see new tables

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

    70-176 Test (Visual Basic)

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

    ETL Tools selection

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

    DW Vendors

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

    anyone giving the 70-229 exam?

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

    MCDST troytec/braindumps ??

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

    I don't see many MCSD posts here

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

    DW Vendors

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

    DW Vendors

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

    DW Vendors

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

Part and Inventory Search

Back
Top