Problem w/ OLAP cube

[Peter Sirmis]

Hi,

The OLAP cube doesn't seem to build properly if at all. The cube is
built every night at 12:00am but since last night is says it is still
initiated, not completed successfully. I updated it again today but it
still says that is initiated. (It usually builds right away after I
build it).



Anyone have any suggestions or idea of why this is happening?



Peter




<http://www.redknee.com/>

<http://www.redknee.com/>






Peter Sirmis

Trouble Ticket Coordinator




<http://ca.maps.yahoo.com/py/maps.py?Pyt=Tmap&addr=2560+Matheson+Blvd,
+Mississauga%2C+ON+L4W+4Y9&csz=2560+Matheson+Blvd%2C+Mississauga%2C+ON+L
4W+4Y9&country=ca> Redknee Inc.


<http://ca.maps.yahoo.com/maps_result?ed=T39FSep_0TrDhpsvRGiysMDZT4HBs8Y
T2m38hQT6GDTG&csz=Mississauga%2C+ON+L4W+4Y9&country=ca&new=1&name=&qty=>
2560 Matheson Blvd East
Mississauga, ON L4W 4Y9
Canada


(e-mail address removed)



tel: +1 905 625 2794



<http://www.redknee.com/site/confidentiality.html> E-Mail Disclaimer

 

[CQ]

Hi Peter,
We had the same issue on our system after we first went live. As I recall,
it turned out to be a permissions issue on the SQL server with our OLAPADMIN
userid. We had to give that user permissions to use our SQL server which was
separate from our Project Server.