Portfolio Analyzer

R

Raja

Hi,

I was trying to create a port-folio analyzer view in Project server.I was
able to build the cube and update the cube from the project web-access, but
when i tried to build a view using the cube it gave me an message saying that
the "cube was not build or there is no sufficen permisison to access the
cube" but i even tried giving permission to users to access the cube but
still i get this error. Can somebody help me out in this error?
 
M

Marco

Hi,

You have to add the users to the cube database roles in SQL Server analysis
Server.

Marco.
 
R

Raja

Hi Marco

i did that too.I added my user id to the cube and logged in into the project
server with my account(Administrator) but still i get this error.
 
R

Reid McTaggart

Do you have Office XP or Office 2003 installed on the computer you are trying
to use to create the OLAP view?
 
R

Raja

I was trying to create a view from Windows Server 2003 ?

this is the actual error that i get

Unable to access the Microsoft Office Project Portfolio Analyzer OLAP cube.

Possible Cause : The cube has not yet been built, or it is currently being
generated, or you do not have permission to access the cube.
 
V

Vadim Bogdanov

Raja,

there may be a number of reasons for this error.

The simpliest solution I'd suggest is to provide anonimous access to OLAP by
instruction here:


1. On the analysis services computer, copy the file Msolap.asp from the
Program Files\Microsoft Analysis Services\Bin folder to either the
Inetpub\Wwwroot folder or to a subfolder under Wwwroot.

2. To ensure that Msolap.asp is installed and working properly, in the
Address bar, type the URL http://www.AnalysisServerName/Msolap.asp, and
replace "AnalysisServerName" with the name of your server.

3. If everything is working properly, you should see a blank page, instead
of the message "The page could not be displayed," or a similar message.

4. Set Msolap.asp to use Basic authentication and Integrated Windows
authentication, as follows: Right-click Msolap.asp, and then click
Properties.

5. Click the File Security tab, and then edit the Anonymous Access and
Authentication Control box to make changes.

6. Make sure that both the Basic Authentication and Integrated Windows
Authentication check boxes are selected.

Setting up connection strings in the Portfolio Analyzer view

===============================================

Once the analysis server has been configured, the administrator needs to
follow these steps when creating Portfolio Analyzer views that are to be
viewed over the Internet:

1. On a machine that is within the intranet, log on to Microsoft Project Web
Access as an administrator.

2. Click Admin, and on the Administration overview page, click Manage views.

3. Click Add View.

4. Click the Portfolio Analyzer option button.

5. On the Office PivotTable toolbar, click the Commands and Options option
button.

6. Click the Data Source tab.

7. In the connection string, leave everything untouched, except for the
following: Add "http://" and "/" to the connection string; for example:

8. Data Source = myanalysisserver becomes Data Source =
http://myanalysisserver/

9. Insert 'Prompt=Yes' anywhere in the connection string.

10. Save your changes.




--
Regards,
Vadim Bogdanov
OLAP Extender - add any custom data to the OLAP cube
http://www.bogdanov-associates.com/eng.asp?rubr_id=484
 
E

Enomagic

Hi Vadim,
I am having issues with this too - although a slightly more specfic
scenario.

Connecting to the PS OLAP pages in PWA is fine - when I use a machine name -
but it will not work with a domain name.

E.g. if I have a server called Projectserver, and it has a DNS name of
Projectserver.company.com. Both resolve to the same ip and the same server.

When I connect using machinename - I can see the OLAP pages. When I connect
with the DNS name - I get an error saying unable to access the OLAP Cube.

Is there a restriction on how you can use OLAP in this way?


Thanks
Ben Fletcher
 
H

Hans Wurst

Hi there,

I did it as described above, but get an error saying that this feature is
only available with the Analysis Services for SQL Server 2000 Enterprise
Edition.

Is that the ppssible or did I something wrong?

Michael
 

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