Project Owner and OLAP Cube

R

Robert

Hi,

There is a field named Owner in the Summary view of the Project Center.
How can we add this Owner field as a Dimension in the OLAP Cube ? I only
found the Assignment Owner.
Thanks for your help

Robert
 
N

NZ Projects

Have you tried creating a custom field with the formula [owner], then adding
it to cube you want to use ?
 
D

Dale Howard [MVP]

NZ and Robert --

I don't mean to rain on your parade, but you can't use a custom field with a
formula for this purpose. You cannot use fields in the OLAP cube unless you
extend the cube, right?




NZ Projects said:
Have you tried creating a custom field with the formula [owner], then
adding
it to cube you want to use ?

Robert said:
Hi,

There is a field named Owner in the Summary view of the Project Center.
How can we add this Owner field as a Dimension in the OLAP Cube ? I only
found the Assignment Owner.
Thanks for your help

Robert
 
N

NZ Projects

Is you're using 2007 then absolutely you can !

Dale Howard said:
NZ and Robert --

I don't mean to rain on your parade, but you can't use a custom field with a
formula for this purpose. You cannot use fields in the OLAP cube unless you
extend the cube, right?




NZ Projects said:
Have you tried creating a custom field with the formula [owner], then
adding
it to cube you want to use ?

Robert said:
Hi,

There is a field named Owner in the Summary view of the Project Center.
How can we add this Owner field as a Dimension in the OLAP Cube ? I only
found the Assignment Owner.
Thanks for your help

Robert
 
D

Dale Howard [MVP]

NZ --

Nobody said anything about 2007 in the original posts. I was assuming 2003.
If I'm wrong in that assumption, I apologize.




NZ Projects said:
Is you're using 2007 then absolutely you can !

Dale Howard said:
NZ and Robert --

I don't mean to rain on your parade, but you can't use a custom field
with a
formula for this purpose. You cannot use fields in the OLAP cube unless
you
extend the cube, right?




NZ Projects said:
Have you tried creating a custom field with the formula [owner], then
adding
it to cube you want to use ?

:

Hi,

There is a field named Owner in the Summary view of the Project
Center.
How can we add this Owner field as a Dimension in the OLAP Cube ? I
only
found the Assignment Owner.
Thanks for your help

Robert
 
R

Robert

Dale,
Sorry for beeing imprecise. In fact, I do use the 2007 version.

Dale Howard said:
NZ --

Nobody said anything about 2007 in the original posts. I was assuming
2003. If I'm wrong in that assumption, I apologize.




NZ Projects said:
Is you're using 2007 then absolutely you can !

Dale Howard said:
NZ and Robert --

I don't mean to rain on your parade, but you can't use a custom field
with a
formula for this purpose. You cannot use fields in the OLAP cube unless
you
extend the cube, right?




Have you tried creating a custom field with the formula [owner], then
adding
it to cube you want to use ?

:

Hi,

There is a field named Owner in the Summary view of the Project
Center.
How can we add this Owner field as a Dimension in the OLAP Cube ? I
only
found the Assignment Owner.
Thanks for your help

Robert
 
R

Robert

NZ,

I tried creating a custom field with the following formulas:
[owner] : refused by PWA 2007
[Assignment Owner] : accepted but generate an ERROR value

Any idea ?
Robert

NZ Projects said:
Have you tried creating a custom field with the formula [owner], then
adding
it to cube you want to use ?

Robert said:
Hi,

There is a field named Owner in the Summary view of the Project Center.
How can we add this Owner field as a Dimension in the OLAP Cube ? I only
found the Assignment Owner.
Thanks for your help

Robert
 
G

GirlGeek

NZ,

I tried creating a custom field with the following formulas:
[owner] : refused by PWA 2007
[Assignment Owner] : accepted but generate an ERROR value

Any idea ?
Robert

"NZ Projects" <[email protected]> a écrit dans le message
deA10CD3B8-E670-4973-93A2-3F443F76B__BEGIN_MASK_n#[email protected]...


Have you tried creating a custom field with the formula [owner], then
adding
it to cube you want to use ?
"Robert" wrote:

- Show quoted text -

Just a NOTE on 'Owner' field, by the way. In 2003, Owner and Manager
of a project are 2 different fields. Owner first created the project,
and is editable in PWA; Manager is the one who last Published, and who
the Updates go to. Are you sure you want to display 'Owner'? Or is it
'Manager'? Dale Howard and company have an excellent write-up about
this at http://www.projectexperts.com. I don't know 2007, so can't
speak to that. Dale?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top