Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
Excel Report based on MS_Project_SharePoint cube (2010)

Răspuns Excel Report based on MS_Project_SharePoint cube (2010)

  • Monday, 14 May 2012 5:31 PM
     
     
    Sign In to Vote
    0

    Hi,

    I'm trying to build an Excel Report in Dashboard Designer, based on the MS_Project_SharePoint cube (Project 2010).

    I used the two Measures :

    • Number of issues
    • Number of risks

    Bottom axis : Project_Department_Project.

    But the result is false: instead of the number of risk and the number of issues for each Department, the graph repeats for each department the Total number of risks and the Total number of issues for all the projects.

    What did I miss?

    Thanks

     

All Replies

  • Tuesday, 30 October 2012 2:03 AM
     
     
    Sign In to Vote
    1

    You will probably need to add "Project List" to your report as well and then summarize it.

    Rene Alvarez

     
  • Tuesday, 30 October 2012 5:26 PM
     
     Answered
    Sign In to Vote
    1

    Hi WLID1966,

    did you add the dimension Project Department_Project to the Cube: Project in your OLAP DB configuration in PWA? Since it's not an assignment cube, all dimensions that you added to your assignment cubes (e.g. Portfolio Analyser) will need to be added separately to project cubes (e.g. MSP_Project_SharePoint).

    Does that help? If not, try different settings/cubes. The phenomenon of always showing the whole total is usually by missing dimensions which cause the filters to fail.

    Kind regards,
    Adrian

    • Marked As Answer by WLID1966 Thursday, 8 November 2012 8:47 AM
    •