19 สิงหาคม 2553 14:30
Hi at all,
in our environment we build Portfolio_Analyzer cube in complete way. We have some custom field with lookup table associate.
In data analisys view, we can filter our views using this custom fields values correctly.
I.E. (the custom field TEAM_LEADER based on a lookup table with key (code of resource) and description (name of resource))
Now, in my dataAnalisys view filter, i can see TEAM_LEADER filter, and, if i expand this, i see all keys (code of resource). This work but it's not so usefull.
In your opinion is it possible to have in these filter (on Custom field based on a look up table) both key and description together?
In order to semplify our filtering work, is there some customization to get this?
23 สิงหาคม 2553 22:23เจ้าของ
Very good question Paolo. The field you need is MemberDescription from the reporting database table MSP_EpmLookupTable but we just bring the MemberValue in as you have found. I don't know of any good examples of extending the Project Server Analysis Services database in this way. I did 'have a play' and this was in 2010, and went to the dimension in the cube and used the right clikc option Script Dimension as ALTER to New Query Editor Window. In that window I then changed MemberValue to MemberDescription and executed this statement. I then used the Right click option to Process the dimension, and under Change Settings I checked Process affected objects. and then OK and OK again. This updated my dimension and also the related cubes.
I could then browse my cube and see the description from the lookup table rather than the value.
The down side of this method (apart from being 'unsupported'...) is that the next time you build the cube it all gets thrown away and you would need to re-apply this workaround. But it does at least give you an idea what needs to be done, and you should be able to use the hooks into the cube build process, such as the event handlers for CubeBuilt and CubeProcessed. Unfortunately I don't see a lot of guidance on using these specific event handlers.
Perhaps others from our community can pitch in here...
Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page