Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

OLAP cubes created from Project Server 2007

0 views
Skip to first unread message

MSPLearner

unread,
Dec 30, 2009, 6:40:01 PM12/30/09
to
I am a Project Server Admin and an accidental DBA, so apologies for not
speaking DB language.

There are many project related cubes generated in Project Server. It uses
SSAS to create the OLAP cubes. I can locate and connect to the cubes (via
Excel) on the server running SQL Server & SSAS. I can also connect to the
Cube via SQL Mgmt Studio.

Question is how can I (what file type?) locate the equivalent of BIDS/SSAS
solution file that defines the cube definitions/structure - it appears well
hidden.

Any hints appreciated.

0 new messages