Forum Replies Created

Viewing 6 posts - 1 through 7 (of 7 total)

  • RE: Connection failure in Analysis service

    Just to confirm.., when I said connect to the Analysis Server, I meant through the Analysis Services Console.

    Andrew Keenan

    http://www.iocore.com.au

    Andrew Keenan
    Consultant, Business Intelligence
    Technology Services
    KAZ
    E andrew.keenan@kaz-group.com

  • RE: Connection failure in Analysis service

    If Analysis Services on the server has been upgraded to Service Pack 3, you will need to run the SP3 update on every client that needs to connect to the...

    Andrew Keenan
    Consultant, Business Intelligence
    Technology Services
    KAZ
    E andrew.keenan@kaz-group.com

  • RE: Good client for Analysis Service

    From what I have seen of the ZapTech software, I can also vouch that it is really good.

    Another tool I also like is the Excel Integration software from...

    Andrew Keenan
    Consultant, Business Intelligence
    Technology Services
    KAZ
    E andrew.keenan@kaz-group.com

  • RE: How can I make a DTS step optional?

    You could set global variable flags in the package and use an ActiveX script in the Workflow properties for a task to determine whether that task should execute or not.

    One...

    Andrew Keenan
    Consultant, Business Intelligence
    Technology Services
    KAZ
    E andrew.keenan@kaz-group.com

  • RE: Report Generation

    Hi

    I have used or reviewed the following for both OLAP and RDBMS reporting from SQL and Analysis Services. Price differs, different tool for different needs:

    - Cognos Impropmptu and PowerPlay

    ...

    Andrew Keenan
    Consultant, Business Intelligence
    Technology Services
    KAZ
    E andrew.keenan@kaz-group.com

  • RE: Parent Child Relationships

    Hi

    If you want to have the same product under multiple hierarchies, you could do this by having the same product description but different product ID in the dimension. To...

    Andrew Keenan
    Consultant, Business Intelligence
    Technology Services
    KAZ
    E andrew.keenan@kaz-group.com

Viewing 6 posts - 1 through 7 (of 7 total)