OLAP Cube Build in Test Environment RRS feed

  • Question

  • Hey there, I have a "test" environment which is simply another "PWA" created in central administration along with a set of "test" databases.

    When I build the OLAP cubes, at first I was getting an error because it was trying to overwrite the analysis database in production, so I changed the name of the analysis database to "test_".

    Well, the build worked, but it appears that in test, its pulling the data from the production database instead of test (I only have 14 projects in the test environment) and when I go into the data analysis too in PWAtest, it lists many many projects that I don't see when accessing Project Center.

    Where do I "point" to the test database as the source for the OLAP cubes build?

    Andy Novak, PMP, MBA
    University of North Texas

    Friday, May 20, 2011 8:06 PM