none
OLAP Virtual cubes in PS 2010: what are their components ? RRS feed

  • Question

  • Hi,

    I read somewhere that the 3 following OLAP Cubes in Project Server 2010 are virtual cubes built with the "aggregation" of several other cubes. What are these "primary" cubes?

    Thanks

    • MSP_Portfolio_Analyzer
    • MSP_Project_SharePoint
    • MSP_Project_Timesheet
    Wednesday, December 25, 2013 5:56 PM

Answers

  • Hi robert,

    Please find cubes related information in the link below:

    http://msdn.microsoft.com/en-us/library/office/aa974558(v=office.14).aspx

    Following are the three default virtual cubes that combine data from the other cubes:

    • MSP_Project_Timesheet combines the Assignment Timephased, Resource Timephased, and EPM Timesheet cubes.

    • MSP_Project_SharePoint combines Project Non-Timephased, Issues, Risks, and Deliverables cubes.

    • MSP_Portfolio_Analyzer combines the Assignment Timephased and Resource Timephased cubes.

    Hope this helps


    Guillaume Rouyre - MBA, MCP, MCTS

    • Marked as answer by Robert6156 Friday, January 3, 2014 1:00 PM
    Wednesday, December 25, 2013 6:13 PM
    Moderator

All replies

  • Hi robert,

    Please find cubes related information in the link below:

    http://msdn.microsoft.com/en-us/library/office/aa974558(v=office.14).aspx

    Following are the three default virtual cubes that combine data from the other cubes:

    • MSP_Project_Timesheet combines the Assignment Timephased, Resource Timephased, and EPM Timesheet cubes.

    • MSP_Project_SharePoint combines Project Non-Timephased, Issues, Risks, and Deliverables cubes.

    • MSP_Portfolio_Analyzer combines the Assignment Timephased and Resource Timephased cubes.

    Hope this helps


    Guillaume Rouyre - MBA, MCP, MCTS

    • Marked as answer by Robert6156 Friday, January 3, 2014 1:00 PM
    Wednesday, December 25, 2013 6:13 PM
    Moderator
  • To understand the Total fields and Dimensions available in the 14  OLAP cubes available in Project Server 2010, it is helpful to group the OLAP cubes based on the Total fields and Dimensions they have in common with one another. Therefore, consider the following logical groupings for the fourteen OLAP cubes:

    Assignment: The Assignment Non Timephased, Assignment Timephased, MSP Portfolio Analyzer, and MSP Project Timesheet OLAP cubes contain assignment data. Each of these OLAP cubes includes many of the same Total Fields (such as Actual Cost, Actual Overtime Cost, Actual Work, and Actual Overtime Work) and many of the same Dimensions (such as Assignment Owner and Project List)

    Project Workspace:The Deliverables, Issues, MSP_Project_SharePoint, and Windows SharePoint Services (WSS). This data includes Risk, Issues, Document, and Deliverable information about each project.

    Timesheet: The EPM Timesheet and Timesheet OLAP cubes contain timesheet data. You can use these two OLAP cubes to report on Actual Work Billable and Actual Work Non Billable, for example.

    Project:The Project Non Timephased OLAP cube contains project data. Although this OLAP cube contains some information in common with several others, the common information is so limited that I include it in its own group.

    Resource: The Resource Non Timephased and Resource Timephased OLAP cubes contain resource data. These two OLAP cubes do not contain any Total fields in common, but do contain several Dimensions in common (such as Booking Type and Resource List).

    Task:  The Tasks Non Timephased OLAP cube contains task data. This OLAP cube contains only one Total field and six Dimensions, two of which it has in common with other OLAP cubes. Because this OLAP cube contains so little information, and has so little in common with other OLAP cubes, I include it in its own group.

    In other way you can conclude :


    MSP_Project_Timesheet:: combines the Assignment Timephased, Resource Timephased, and EPM Timesheet cubes.
    MSP_Project_SharePoint :: combines Project Non-Timephased, Issues, Risks, and Deliverables cubes.
    MSP_Portfolio_Analyzer :: combines the Assignment Timephased and Resource Timephased cubes










    kirtesh


    • Edited by Kirteshtiw Wednesday, December 25, 2013 7:10 PM
    Wednesday, December 25, 2013 7:07 PM