<html xmlns
="urn:schemas-microsoft-com
ffice
ffice"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
****** http-equiv=Content-Type content="text/x-ms-odc; charset=utf-8">
****** name=ProgId content=ODC.Table>
****** name=SourceType content=OLEDB>
<title>.PowerPivot Get All DAX statements</title>
<xml id=docprops><o:DocumentProperties
xmlns
="urn:schemas-microsoft-com
ffice
ffice"
xmlns="http://www.w3.org/TR/REC-html40">
<o:Name>.PowerPivot Get All DAX Statements</o:Name>
</o:DocumentProperties>
</xml><xml id=msodc><odc:OfficeDataConnection
xmlns
dc="urn:schemas-microsoft-com
ffice
dc"
xmlns="http://www.w3.org/TR/REC-html40">
<odc:Connection odc:Type="OLEDB">
<odc:ConnectionString>Provider=MSOLAP.5;Persist Security Info=True;Initial -
Catalog=Microsoft_SQLServer_AnalysisServices;Data Source=$Embedded$;MDX -
Compatibility=1;Safety Options=2;ConnectTo=11.0;MDX Missing Member Mode=Error;Optimize -
Response=3;Cell Error Mode=TextValue</odc:ConnectionString>
<odc:CommandType>Default</odc:CommandType>
<odc:CommandText>
SELECT DISTINCT
, OBJECT_TYPE, OBJECT, EXPRESSION
FROM $system.discover_calc_dependency
WHERE OBJECT_TYPE = 'MEASURE'
OR OBJECT_TYPE = 'CALC_COLUMN'
ORDER BY 1
**</odc:CommandText>
</odc:Connection>
</odc:OfficeDataConnection>
</xml>
<style>
<!--
.ODCDataSource
{
behavior: url(dataconn.htc);
- }
-->
</style>
</head>
</body>
</html
