How to: View the XML Code for an Analysis Services Project

New: 14 April 2006

When you are working with an Analysis Services database in project mode, Business Intelligence Development Studio creates an XML definition for each object within the project folder. You can view the contents of the XML file for each object within Business Intelligence Development Studio. You can also edit the XML file directly; however, this is not recommended in most circumstances as you may make changes that make the XML unreadable by Business Intelligence Development Studio.


You cannot view the xml code for an entire project, but rather you view the code for each object because a separate file exists for each object. The only way to view the code for an entire project is to build the project and view the ASSL code in the <project name>.asdatabase file.

To view the XML code for an object

  1. Open the Analysis Services project in Business Intelligence Development Studio.

  2. Right-click the object in Solution Explorer and then click View Code.

    The XML code for the object appears in Business Intelligence Development Studio.

See Also


Building Analysis Services Projects

Other Resources

Reviewing Cube and Dimension Properties

Help and Information

Getting SQL Server 2005 Assistance