Project Server 2007: Podcast – Talkthrough of OLAP Cube Building

This podcast is a talkthrough of the process of building a cube.  I forgot to mention firewalls which can also block access to SQL/Analysis Services - so see the TechNet artilces for details.  For other blog postings on this topic go to


Comments (9)

  1. peris says:

    I have the next method for creating tasks into a existing project:

    public void CreateTask(string ProjectID, string TaskName

    , string start, string duration)




    Guid projectGuid = new Guid(ProjectID);

    Guid sessionGuid = Guid.NewGuid();

    const string SESSION_DESC = "description";

    project.CheckOutProject(projectGuid, sessionGuid, SESSION_DESC);

    dsProject = new

    w2003wss1.ProjectDataSet(); w2003wss1.ProjectDataSet.TaskRow taskRow =


    Guid taskGuid = Guid.NewGuid();

    taskRow.PROJ_UID = projectGuid;

    taskRow.TASK_UID = taskGuid;

    taskRow.TASK_NAME = TaskName;

    taskRow.TASK_START_DATE = DateTime.Parse(start);

    taskRow.TASK_DUR = Convert.ToInt32(duration);

    taskRow.TASK_DUR_FMT = (int)PSLibrary.Task.DurationFormat.EstHour;


    Guid jobGuid = Guid.NewGuid();

    bool validateOnly = false;

    project.QueueAddToProject(jobGuid, sessionGuid, dsProject,



    jobGuid = Guid.NewGuid();

    project.QueueCheckInProject(jobGuid, projectGuid, false, sessionGuid,



    catch (Exception e)


    throw e;



    When QueueAddToProject() method is executed, an exception appears:

    System.Web.Services.Protocols.SoapException: ProjectServerError(s)

    LastError=GeneralOnlyInsertsAllowed Instructions: Pass this into

    PSClientError constructor to access all error information



    jobUid, Guid sessionUid, ProjectDataSet dataset, Boolean validateOnly)

    What happen? How can I solve this problem?

  2. cperis says:


    is it possible to modify from a Project Wrokspace the type of the default fields Probability and Impact from "Number" to "Choice"?


  3. Hi cperis,

    I haven’t tested, but I would imagine it would break things relating to the sync of the issue/risk information to the reporting database.  By all means test in a non-production environment and see what happens.

    Also it would be helpful to other readers to only post against relevant blog postings.  I reserve the option to remove non-relevant comment postings.

    Best regards,


  4. Hi cperis,

    or your other problem I suspect the dataset also contains non-new records that it cannot insert.


  5. cperis says:

    Hi Brian,

    thanks for your answer. I have tried to modify the type of this fields in a non-production environment, but the type appears to be "locked", but you do it dor all other fields.

    ¿What do you mean with "to only post against relevant blog postings"?


  6. I mean that you have posted a PSI coding issue about adding a task, and a WSS workspace issue as a comment on an OLAP cube building blog post. There are posts on use of PSI that would be more appropriate, and may even help answer your question if you looked for them – or post to a newsgroup.

  7. cperis says:

    Hi Brian,

    the post of peris is not mine. I am cperis, but not peris.


  8. Sorry cperis.  A case of mistaken identity.

    Best regards,


  9. cperis says:

    Hi Brian,

    it doesn’t matter, the names are nearly the same.

    Another question: Is it possible to allow a resource to give values to the Task Custom Fields when he creates a new Task in PWA or only the Project Manager can do it? That would be not very functional…

Skip to main content