Re: Issue Building OLAP Cube and Data Analysis View in Project Server

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi Sushant,

Try posting on the server newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP



"Sushant" <Sushant@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C1FAC542-FC75-4A2D-B88E-3851DABA1C77@xxxxxxxxxxxxxxxx
Hi

We have been facing issues building the cube, every day we come accros
something new that causes the cube build to fail. Recently we rebooted the
server as part of our usual maintenance and cube started failing again.
The
error was
"Analysis Services session failed with the following error: Cannot
overwrite
an Olap database created outside of Project Server or by another Project
Server Site."

We tried following
We first Deleted the OLAP DB, then tried to create with the same name from
the UI(Server Settings ->Build Settings), it failed, then renamed and OLAP
DB
and built cube again, this time the cube started building but it fails
sometimes (no pattern identified). Also the DataAnalysis views stopped
building and the name if the OLAP DB does not appear in the Server
Settings-->ManageViews-->Newview-->Viewtype=DataAnalysis-->Analysis
Services
Database to be created = ??? there is no DB listed there.

What should I do get the OLAP DB Name in the drop down list so that my
Data
Analysis views start working?

Thanks so much!

--
Regards,
Sushant


.

Relevant Pages

  • Re: OLAP cube build stuck (Project 2003 Server)
    ... It looks like the OLAP build just died. ... I'm thinking a Project Server ... Concerning the admin permissions needed to build the cube: ...
    (microsoft.public.project.pro_and_server)
  • Re: OLAP cube build stuck (Project 2003 Server)
    ... cube will probably be enough - if not, ... Have you migrated the OLAP metadata repository to an sqlserver database ... identity used for communicating with the OLAP server a member of the OLAP ... I have installed SQL AS, ...
    (microsoft.public.project.pro_and_server)
  • Re: Issue with Migrating OLAP Cube
    ... See the section titled "Release Management" in the Analysis Services ... > OLAP Server Dev to OLAP Server UAT: ... > "Could not paste cube 'CUBENAME'. ...
    (microsoft.public.sqlserver.olap)
  • Re: OLAP Cube build failed
    ... Try posting on the server newsgroup as this one's closing down. ... FAQ Item: 24. ... > forgot to rename the cube on the copy. ...
    (microsoft.public.project.pro_and_server)
  • Re: Update resource tables and OLAP cube
    ... It sounds like your Project Server doesn't know how to talk to your Analysis ... Try using the PSComPlus tool. ... > "The cube is currently being built." ... >OLAP Specified" ...
    (microsoft.public.project.pro_and_server)