Building a customized OLAP cube in PWA RRS feed

  • Question

  • I am trying to build a cube with a bit of customizations in the column names to be inlcuded. Where can i begin from, As per the instructions on The MS offcie site, it tells me to go to server settings>Enterprise options> Update Olap and resource table. But i cant see these options there.


    Thanks In advance

    Thursday, July 7, 2011 7:55 PM


All replies

  • mannu1982 --

    What version of Project Server are you using?  I don't recommend the commands you mention from either Project Server 2007 or 2010.  Are you using Project Server 2003, by chance?  If so, you cannot determine which fields (columns) to include in the OLAP cube.  Instead, Project Server 2003 automatically includes every Project, Resource, and Task outline code field, and you cannot change that.  The only thing you can change is the date range used to generate the project data in the OLAP cube.  Let us know if this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    "We write the books on Project Server"

    Thursday, July 7, 2011 9:08 PM
  • Hi Dale,

                I am using MS Project 2007. I had no idea how to create a Cube so i browsed on the net and came across a post with those commands i mentioned in my post earlier.

    How can i get data analysed in a cube for two plans?



    Friday, July 8, 2011 2:09 PM
  • Best place to start is Technet.


    Also, MSProjectExperts have some good books on this topic too.  They walk you step by step thru the process.  Is that right Dale?


    Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA
    Friday, July 8, 2011 3:09 PM
  • Hi Mannu

    Since you have mentioned you don't know much about Cube building process in 2007, hence assuming you haven't configured project server default cubes yet, as project server 2007 itself creates 14 cubes for reporting purposes which can be configured out of box for adding additional set of project server custom columns, now you would need to first build the cube and see how much default / configured cubes cater your requirement and then you can decide upon having a custom cube built if required, to start with i would suggest you go through the Technet article : Configuring Project Server 2007 to Use Cube Building Service : http://technet.microsoft.com/en-us/library/cc303402%28office.12%29.aspx

    Also would suggest to check this excellent blog post which covers most of the common cube build errors with resolution : http://blogs.msdn.com/b/brismith/archive/2007/02/14/common-error-messages-when-building-cubes.aspx


    Hope this helps   

    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
    Friday, July 8, 2011 3:12 PM
  • Sunil.

            I know there are 14 default cubes, i am working on the Project non phased cube. I need to get the resource name, project list, time and cost (actual, baseline and the custome fields (capital/expense) i have created on the report. how or in which cube can i add the custom field created?



    Friday, July 8, 2011 3:35 PM
  • All you have to do is create a EPM code.  Prior to building the cube, then you need to add the EPM code to one of the dimensions, ie Project, Resource, Task or Assignment.  OR do the same for measures.

    Basically, the cube names gives you a good idea of what the datawarehouse contains. 

    What specifically are you trying to do and what is the issue you are having?


    Michael Wharton, MBA, PMP, MCT, MCSD, MCSE+I, MCDBA
    Friday, July 8, 2011 4:01 PM
  • I have created an EPM Code and now i need to include that field in the default cube i am using (Project non phased cube). Is there a way i can get that field in the cube for my data analysis?



    Friday, July 8, 2011 4:30 PM
  • Hi Mannu

    My Aplogies, if i misunderstood and understated but again when you say  "i need to include that field in the default cube i am using (Project non phased cube). Is there a way i can get that field in the cube for my data analysis?"

    If i am understanding correct then you haven't tried adding your custom field to default cube using  Server Settings >> Cube >> Configuration >> here you can add your custom fields (depending upon what type of they are, as there are restrictions on what you can add and what you can't) Dimensions & Measures to the available cubes

    Apart from which it also allows you to define MDX queries for calculated measures as well for more reference have a look at this : http://technet.microsoft.com/en-us/library/cc197661%28office.12%29.aspx


    Also have a look at it especially for Custom field configuration in cube : http://www.projectserverexperts.com/ProjectServerFAQKnowledgeBase/Understand%20custom%20fields%20in%20OLAP%20cubes.aspx

    Let us know if this helps 

    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
    Friday, July 8, 2011 5:28 PM
  • Thanks Sunil,

    As per your instructions i tried adding the fields i am looking for but this is the error i am getting? It tells me " failed to save your custom fields.....ensure following rules are met.

    1.number of custom fields added as dimensions added does not exceed 100 in each cube.

    2.each custom field name is valid for OLAP.

    3.custom field, calculated measure and PS built in cube object names are distinct from each other."

    Where am i going wrong?

    With your suggestions i wasw able to get the required fields except for one, i am looking to filter with the column that displays the task type ( based on capital or expense). Can you tell me if there is any existing field i need to select for the data analysis?



    Friday, July 8, 2011 7:33 PM
  • Have a look at this post it contains what you can and can't add to OLAP cube , perhaps one of the description might be the answer for your error



    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
    Friday, July 8, 2011 8:31 PM
  • Thanks  Sunil , Micheal and Dale. With all your answers i was able to succesfully create and get the cutom fields in the cube created.

    I am now having this minor issue in my cube, I have selected the Proejct spend_type (Enterprise) in my cube to get the capital and expense cost. I have included this field as a column in my plan. But i only see resources with captial. Can i change that to be a drop down of capital /expense. Or this the default values taken when the project plan is built.


    Thanks In advance.



    Wednesday, July 13, 2011 8:15 PM
  • Hi Mannu

    Closing this thread assuming you have found an answer, if you still feel its not answered you may open a new thread for discussion or re open this thread for further discussion


    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
    • Marked as answer by epmXperts Sunday, September 4, 2011 4:37 PM
    Sunday, September 4, 2011 4:37 PM