Building OLAP Cube, got error message...

[Jiaheng Qin]

Dear All,

I logged on into PWA as administrator, I go to the server settings - OLAP
Cub - Building
The system asked me to input server name and database name, I input such
name: project and OLAP
after several time of refresh, there is an error message:

Analysis Services query failed, following error occurs: can't connect to
Analysis Services server: project. Mistake: connection string need to be
defined in the property of server 9.0 during save period.

I seems that remark me to check *.ini

Because I used Chinese Project 2007 Server system, I don't know the
translation is exacted or not.

Is there any guidance from professionals ?

You may not influenced by my provided information, you just suggest me
common procedure on how to build the OLAP cube.

Thanks a lot.

Best regards

Jiaheng Qin

 

[Ben Howard]

Hi, check this to fix the problem.

http://technet2.microsoft.com/Office/en-us/library/091d4b0e-17ee-43a0-bdd9-b269f07f92471033.mspx

 

[Jiaheng Qin]

Dear Mr. Ben Howard,

Firstly, thank you very much for your kind and quick response.
I read the article you provided for me.
But I still can't find any solution. Do you have some steps on how to build
the OLAP Cube in Project 2007 Server, which step what need to be done.
Thanks a lot.

Best regards

Jiaheng Qin

 

[Ben Howard]

All the steps are in the link, but make sure you have created the repository
(option 2).

 

[Jiaheng Qin]

Thanks a lot.
In the project 2007 bible, they describe how to configure the building, but
the database they select is SQL 2000, it's quite different compare with SQL
2005.
I will read again and try to configure myself.

BR

Jiaheng Qin

 

[Ben Howard]

okay, the other place you might want to look at is Tony Zinc's blog - he
showed how to do this using SQL2005 -
http://www.pptspaces.com/msprojectr...st=cea5da16-0c29-40a7-845e-4eea7cbc844d&ID=31

This should help you.