Quote:
Originally Posted by dineshks  Yes, I am using the same repository. | According to Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service article: Quote: |
Organizations may have multiple Project Web Access instances on the farm. The information described in this article applies to each instance.
| Because of this, and the problem you're having, I'm inclined to believe that using a single OLAP Repository for multiple Project instances is not supported. Nothing definitive, of course, but I would consider it as a possibility.
__________________ Stephen Sanderlin
Founder/Owner - EPMFAQ
VP of Technology - MSProjectExperts
Microsoft Project MVP If you found this message useful, please click the Thanks button in the post!
This electronic message, along with any information, advice, and opinions it contains, are mine alone and are not representative of my employer. All information is provided in "GOOD FAITH" and on an "AS IS" basis only. I provide no presentations or warranties, express or implied, including implied warranties of fitness for a particular purpose, merchantability, title, and noninfringement. I strongly advise you to extensively test any changes, workarounds, or techniques described herein on a development system prior to implementation in a production environment, and you are hereby notified that I bear no responsibility whatsoever for any loss, harm, or otherwise negative outcomes resulting from your actions, whether or not said actions were a result of this electronic message, directly or indirectly.  |