Build OLAP cube with Project 2007 + SQL2005

[Alain]

Hello,

I try to build an OLAP cube with Project Server 2007 and SQL 2005. I get the
following error :
Failed to build the OLAP cubes. Error: Analysis Services session failed with
the following error: Internal Error. The definition of dimension 'Task List'
refers to an ordering member property that was not found: 'Task Index'

Any idea how to solve this issue.
Thanks

 

[Paul Conroy]

Has the cube sucessfully built in the past ?

Have you tried deleting the OLAP database and rebuilding from fresh ?

P

 

[Alain]

I have never build the cube before. As I have no cube before, there is no
interference between the old one with the new one. The error message seem to
explain there is an inconsistency with the task table.

Thanks for help.

Alain.

 

[Marc Schoeni]

Alain,

have you followed the instructions from KB 921116?

http://support.microsoft.com/kb/921116/

Let us know if this helps...

Marc S.
MCP for EPM
www.diventis.ch
www.msepm.blogspot.com

 

[taruna.it]

Hi,

To ge the Data Analysis report in web access ,whether I need to
Install the project server 2007 as server farm mode? Because I could
not build the OLAP cube in server 2007 when I installed as a stand
alone mode.

Thanks
Arun

 

[Arun]

I installed Project server 2007 in server farm mode it is working fine.

Thanks
Arun