Forum Replies Created

Viewing 15 posts - 721 through 735 (of 1,353 total)

  • RE: using Case statement

    Homework problem?

  • RE: Lots of small dimensions

    Is it over kill to go through the process creating staging and live tables and building etl packages to populate StoreUsers, AppointmentTypes and FittingRooms dimensions?

    No, it's not overkill. The...

  • RE: Career future , stay or switch

    Do what you like and are good at. BI may pay well, but a good number of people in it don't do very well. Lots of failed projects...

  • RE: SSAS - Date Dimension ties wrong dates to hierarchy

    I wouldn't use composite keys at all ever. In this case, each month gets one field with a number corresponding to its place in the calendar and another field...

  • RE: Date Filter in Excel for pivot table with cube data source not filtering

    You're welcome. Glad to have helped.

  • RE: Access Disdain

    For example the truly awful "diagram" view in the Access UI uses an inferior pictorial notation (don't ever call it an Entity Relationship Diagram please!) that is completely non aligned...

  • RE: Access Disdain

    I have never known a programmer to say - let me implement with tried and true methods that do the job at hand.

    You never talked with me when I...

  • RE: Access Disdain

    The way I did it was to read the user name from the environ variable.

    I used the user name to determine the group. The permissions were based off the...

  • RE: Access Disdain

    fairly easy to defeat

    Really? I'd be interested in how (as the information is increasinly losing relavance with the passing of years since it worked). I never found it...

  • RE: Access Disdain

    OK, what I asserted above is: There have been better alternatives to MS Access for developing "multi-user line of business applications and data marts" since the mid-1990s.

    There are way...

  • RE: Access Disdain

    Also, I'm unclear on the current state of Access development - do you feel the product is moving forward

    Although I remain a big fan of Access development if its niche...

  • RE: Access Disdain

    As a front end to a real database

    As you said, Access may be often misused. I would NEVER use it as a front end to a "real" database,...

  • RE: Access Disdain

    I'm glad to read something so positive about MS Access. Without it, I might not be were I am today. I learned database design, application design, UI design...

  • RE: How to break into data warehouse management

    I don't know how different the two versions are. As for certifications, they help to break in inasmuch as they show you're willing to put in the time. ...

  • RE: How to break into data warehouse management

    Yes, that's what I'm refering to, and no, the Express edition will not suffice. That is a very scaled down version of SQL Server.

Viewing 15 posts - 721 through 735 (of 1,353 total)