none
OLAP weeks split over months RRS feed

  • Question

  • Hello all

    Trying to do a weekly analysis on the resources based on the Portfolio Analysis Olap Cube.

    unfortunately, I'm in front of a problem some weeks are split over month which is not giving accurate numbers.

    How can I avoid this issue and have 1week by week!


    Jérome


    • Edited by Jérome Charlon Wednesday, January 29, 2014 8:03 PM missing information
    Wednesday, January 29, 2014 7:55 PM

Answers

  • Jerome, I do not know of a workaround for this when you are pulling the data from the OLAP cubes. However, if you use a straight SQL query in Excel, you can retrieve week by week data which is not split by year or month. Please see the answer in a previous forum for instructions:

    http://social.technet.microsoft.com/Forums/projectserver/en-US/55707746-6790-4531-981d-8ee20e99e2b0/time-reporting-in-excel-for-project-server-2010?forum=projectserver2010general

    Hope this helps!
    • Edited by ElliJ Thursday, February 6, 2014 12:09 AM formatting
    • Marked as answer by Jérome Charlon Tuesday, February 11, 2014 2:55 PM
    Thursday, February 6, 2014 12:06 AM

All replies

  • The weeks between years will not line up as you can see.  I'm sure that you have thought of this but I would suggest that you use months. 

    Cheers!


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Wednesday, January 29, 2014 8:42 PM
    Moderator
  • yes I saw and this is my issue.

    my client wnat to manage by weeks as month is to high granularity.

    is there any way of configuring the cube to add a time dimension so that we have good week calculation?

    regards


    Jérome

    Wednesday, January 29, 2014 8:49 PM
  • Jerome, I do not know of a workaround for this when you are pulling the data from the OLAP cubes. However, if you use a straight SQL query in Excel, you can retrieve week by week data which is not split by year or month. Please see the answer in a previous forum for instructions:

    http://social.technet.microsoft.com/Forums/projectserver/en-US/55707746-6790-4531-981d-8ee20e99e2b0/time-reporting-in-excel-for-project-server-2010?forum=projectserver2010general

    Hope this helps!
    • Edited by ElliJ Thursday, February 6, 2014 12:09 AM formatting
    • Marked as answer by Jérome Charlon Tuesday, February 11, 2014 2:55 PM
    Thursday, February 6, 2014 12:06 AM
  • Hello Elij

    thanks a lot,I'll look at it as it may answer to my problem.

    I'm currently using olap cube that are built by Project Server but this could help.

    thanks again.

    regards


    Jérome


    Thursday, February 6, 2014 1:16 AM
  • Elij

    thanks a lot, I started to bypass the cube and life feels different.

    thanks to your blog http://projectserverpants.wordpress.com/2012/09/08/45/ I manage to do what the cube disallowed me to do

    regards


    Jérome

    Tuesday, February 11, 2014 2:54 PM
  • Glad I could help! 

    Elli J Project Solutions Specialist Blog: http://projectserverpants.wordpress.com/

    Tuesday, February 11, 2014 5:39 PM