Team System Cube Structure

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.

Answer this question

Team System Cube Structure

  • j42

    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.

    -tom

  • Team System Cube Structure