Is it possible to open the Team System OLAP cube in cube designer hosted in an Analysis Services project I am interested to find out about dimension attributes, perspective definitions, dimension usage in measure groups etc. Thanks in advance.
Yes, you can download a project of the deployed cube by opening BI Development studio and choosing "New Solution". For the solution type, specify "Import AS database", and then provide the connection information to the warehouse (the data tier name, and "TFSWarehouse"). You must have appropriate permissions to read the metadata of the cube.
At this point, a new project will be created on your local disk, and you can review the structure of the cube there.
Team System Cube Structure
j42
At this point, a new project will be created on your local disk, and you can review the structure of the cube there.
-tom