Forum Replies Created

Viewing 11 posts - 301 through 312 (of 312 total)

  • RE: Which SQL exams should I take first?

    if your using sql2005 in a mainly BI role start with the MCTS 70-445: BI Implementation & Maintenance

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    January 30, 2008 at 9:26 am

    #773379

  • RE: SSRS - Specifying Test db and live db connections

    ok.

    thanks thats answered my question 😀

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    January 22, 2008 at 4:03 am

    #770407

  • RE: Anyone taken 70-445 (BI exam)?

    Hi guys,

    I've been doing the labs and I'm getting about 90% on the Measure Up pre-exam testing software for the 70-445 exam. With these sort of scores, do you...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    January 14, 2008 at 3:49 am

    #767607

  • RE: Data Mining tutorial for SQL Server 2005

    The MCTS 70-445 training kit book, goes through creating a test set and validation data set and then building and testing mining models.

    Good book in general

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    January 14, 2008 at 3:30 am

    #767595

  • RE: How to stop Data Flow from OLE DB to csv file if there are no rows

    Try using a temp table. you could do something like insert into #mytable (your already setting a parameter, so won't be much difference there.

    then use the split to...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    January 11, 2008 at 3:58 am

    #767019

  • RE: How to stop Data Flow from OLE DB to csv file if there are no rows

    I think he means assign the row count to a variable or temp table and then use conditional split against that.

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    January 11, 2008 at 2:55 am

    #767012

  • RE: Cubes and Views

    Hi Darren,

    I've been reading through the MCTS 70-445 BI Implementation & Maintenance book. Reading the posts I think I understand what you are trying to acheive.

    A similiar requiement is...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    December 12, 2007 at 9:46 am

    #759491

  • RE: multi level grouping ?

    Just a slightly different approach, but could you not create a union view from the three data sources and then use that view in the data set for SSRS, so...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    November 12, 2007 at 2:48 am

    #750175

  • RE: SSAS 2005 aggregations usage-based optimisation / COGNOS 8

    ok thanks.

    Appreciate your comments.

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    November 8, 2007 at 9:10 am

    #749532

  • RE: SSAS 2005 aggregations usage-based optimisation / COGNOS 8

    ok,

    Thanks for your reply. 😀

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    November 7, 2007 at 3:24 am

    #749025

  • RE: Business Intelligence Developer Certification

    check out the microsoft certification page for the BI certification.

    I've got most of the books listed, like step by step analysis services etc. Some ramble a little, but do...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

    October 30, 2007 at 5:56 am

    #746580

Viewing 11 posts - 301 through 312 (of 312 total)