Adding a measure to the cube ?

[Schlamper]

Hallo,

I read some of Hugues Perrons posts about adding a dimension/measure
to the Olap-cube. They've been a well introduction and a help to
start.
Unfortunately I could not find the mentioned article related with this
topic, so some difficulties still exists.

This is the way I am trying to add the measure:

First I extended the msp_cube_assn_fact -table, adding a column for my
new data. In the "UserStagingTablesUpdate" function no code is
running.
In the "UserOLAPUpdate" function I use my own connection to connect to
the database. Then I select, calculate and update the
msp_cube_assg_fact table with my favored data.
Now i add the measure to the msp_assn_fact measures-collection using
the addnew-method. This step is successful.
The next step, adding this measure to the MSP_PORTFOLIO_ANALYZER
measures-collection using the "add" or "addnew" method failed. The
object is unable to support this method.
The Microsoft msdn article doesn't give me a hint, so do the analyzer
help files.

Has anyone any idea, what's wrong?
Where can I find Hugues article about adding measures to the cube?

We are using:
- MSProjectProfessional/Server2002 SP1
- MS SQL-Server 2000 SP3
- MS SQL-Server Analysis Services 2000 SP3
- Windows 2000 Server SP4

Regards

 

[Dale Howard [MVP]]

Schlamper --

Refer to the following link for downloads from Hugues Perron:

http://www.projectserverexperts.com/Project Server Downloads/Forms/AllItems.htm

Hope this helps.

 

[Hugues Perron]

Hi Schlamper,

If you still have problem, you can contact me directly, I could take a look
at your code !

Hugues