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

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

  • 14 mai 2012 17:31
     
     
    Sign in pentru a vota
    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

     

Toate mesajele

  • 30 octombrie 2012 02:03
     
     
    Sign in pentru a vota
    1

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

    Rene Alvarez

     
  • 30 octombrie 2012 17:26
     
     Răspuns
    Sign in pentru a vota
    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

    • Marcat ca răspuns de WLID1966 8 noiembrie 2012 08:47
    •