Log på
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Excel Report based on MS_Project_SharePoint cube (2010)

Svar Excel Report based on MS_Project_SharePoint cube (2010)

  • 14. maj 2012 17:31
     
     
    Log på for at bedømme
    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

     

Alle besvarelser

  • 30. oktober 2012 02:03
     
     
    Log på for at bedømme
    1

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

    Rene Alvarez

     
  • 30. oktober 2012 17:26
     
     Svar
    Log på for at bedømme
    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

    • Markeret som svar af WLID1966 8. november 2012 08:47
    •