OLAP Project Connection

  • Thread starter North East developer
  • Start date
N

North East developer

Two plans that are updated daily with timesheets appear to have lost the
connection to the OLAP cube. An error occurred in another plan on the system
mid January and since then the timesheet updates have successfully been
accepted into the two individual plans but are no longer being included in
the OLAP build which takes place each night. Up to the date of the error on
the system occurring all time within the two plans is visible within the OLAP
cube.

The error in the 3rd plan caused a restore to take place and this seems to
have had a knock on effect with the other two plans. For reference there are
many other plans on the system which are all fine.

Any ideas.
 
M

Marc Schoeni

Hi,

There's a lot of things that can be done here... :)

I would recommend you to start with delete the entire OLAP cube in SQL
Analysis Services and rebuild it from scratch. Maybe you also want to
truncate the cube tables MSP_CUBE_ASSN_FACT, MSP_CUBE_TIME_BY_DAY and
MSP_CUBE_RES_AVAIL_FACT (typing this from memory so the names may not be
100% correct) before rebuilding the cube. Furthermore, restarting the Views
Notification services can help a lot at times.

Let us know if this helps...

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