Topic
1 reply Latest Post - ‏2007-01-25T19:09:14Z by SystemAdmin
SystemAdmin
SystemAdmin
1189 Posts
ACCEPTED ANSWER

Pinned topic Getting started with Project Console... Advice?

‏2007-01-25T18:54:53Z |
Hello,
Does anyone have advice on how to get started with Project Console? I have stepped through the tutorial, but it does not help unless I want to start a Classics CD company. The existing schema for the demo does not work well with my ReqPro and ClearQuest databases. I have different naming conventions so I recieve many errors when I try to use the Designer to pull data for my projects.

I have seen the PJC training slides and they are not really helfull, so I don't believe that is the answer.

Does everybode learn through trial and error... the Designer aspect of this tool is not trivial

Any help would be appreciated.
Jason
Updated on 2007-01-25T19:09:14Z at 2007-01-25T19:09:14Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    1189 Posts
    ACCEPTED ANSWER

    Re:Getting started with Project Console... Advice?

    ‏2007-01-25T19:09:14Z  in response to SystemAdmin
    Once you understand the concepts, it is fairly easy to translate that into
    your own environment.

    Basically what you are doing with a collection task is first defining the
    objects that you are going to copy from the source to your data warehouse.
    When your defining the objects, keep in mind a few things:
    1. Your not using ProjectConsole to create and maintain a complete backup
    of the data out of your source
    2. Do not try to collect data on multi-line fields (such as history or
    Notes log from ClearQuest) - this will cause you to run out of disk space
    for your ProjectConsole database very quickly as this environment is a
    warehouse and not a relational database.
    3. Collect the type of data that will help you to make the type of
    decisions you are looking for; you may want to also collect some
    additional information such as owner, submit date etc. that can help your
    Project Managers manage better.

    You then can either use the Wizard to create all the underlying tables and
    structure or you can do this manually (this is where you can use the
    tutorials to show you what you need to do when).

    Once you've gotten this far, you then need to schedule the task to run at
    a predetermined time on some set schedule or manually fire it off.

    After you've successfully collected data, you can then go into the
    Dashboard to create various charts to analyze this data.

    Cheers,

    Debra

    Debra Johnson
    PPM Marketing Engineer
    Rational software
    IBM Software Group
    Boulder, CO
    Telephone: 303-558-3301
    Cell: 303-775-9168
    debrajoh@us.ibm.com

    dw-ratdisc-admin/Raleigh/IBM@IBMUS
    Sent by: pjc-bounces@lists.ca.ibm.com
    01/25/2007 11:54 AM
    Please respond to
    pjc@lists.ca.ibm.com
    To
    pjc@lists.ca.ibm.com
    cc

    Subject
    pjc Getting started with Project Console... Advice?
    Hello,
    Does anyone have advice on how to get started with Project Console? I have
    stepped through the tutorial, but it does not help unless I want to start
    a Classics CD company. The existing schema for the demo does not work
    well with my ReqPro and ClearQuest databases. I have different naming
    conventions so I recieve many errors when I try to use the Designer to
    pull data for my projects.

    I have seen the PJC training slides and they are not really helfull, so I
    don't believe that is the answer.

    Does everybode learn through trial and error... the Designer aspect of
    this tool is not trivial

    Any help would be appreciated.
    Jason
    _______________________________________________
    pjc mailing list
    pjc@lists.ca.ibm.com
    Unsubscribe: pjc-leave@lists.ca.ibm.com

    _______________________________________________
    pjc mailing list
    pjc@lists.ca.ibm.com
    Unsubscribe: pjc-leave@lists.ca.ibm.com