PS07 - OLAP Cube

[TroyS]

I see in PWA Server Settings, Cube, Configuration how to include the
Enterprise Lookup fields in the cube.

However, I want to include both Project and Resource Ent Fields in the
Timephased view called MSP_Portfolio_Analyzer.
The cube builds successfully, but it seems only the Resource Ent Fields show
up in the field list when i go to construct the view.

Why would the project Ent fields not be there as well....?
OR is this impossible to have both Project and Resource Ent Fields in the
MSP Portfolio Analyzer?

 

[Jonathan Sofer [MVP]]

You should be able to include both the Project and Resource fields if they
are lookup fields. In PWA>Server Settings>Cube>Configuration, make sure to
pick the entity Project and move all available custom fields to the right
and then the Resource entity and move all available custom fields to the
right as well. Then save and rebuild your cube.

Jonathan Sofer

 

[TroyS]

Is there any limitation to the number of dimensions you can have?
I see my Resource Lookup fields (eg Employee Type_Resource) but i'm not
finding the project lookup field (eg. BD Stage_Project)
In both the Resource and Project lookup, they are text fields. with a list
to select from.

I can see the BD Stage_Project field in the Project NonTimephased, but not
the MSP_Portfolio_Analyzer cube...
any other ideas about this?