Microsoft Analysis MDX中,如何获取指定维度的详细信息?

[ue]

根据维度ID,返回该维度的详细信息
盼答~~~


先谢谢了~~~~

[迈克揉索芙特]

顶老陈

[ZscMKay]

支持！

[huoxudong125]

以前做bi都用傻瓜化的东西做报表，后来用sql server 2005 的bi学习过一段时间，最近才发现可以用dotnet也可以编写更加灵活美观的bi应用程序

[哥本哈士奇]

为什么不直接走adomd.net呢？
大体的思路就是检索adomdconnection下的各dimension，是一个集合，通过id检索就可以了。

[哥本哈士奇]

sorry,忘记楼主是要求从mdx中查了。

[sea_soul]

学习

[hero_hxiong]

共享知识

[SlaughtChen]

学习了

[yumi_yu]

mark

[zfh198601]

顶

[noble2wolf]

dddddddddddddddddddddddddddddd

[noble2wolf]

ddddddddddddddddddddddddddddddddd

[noble2wolf]

ddddddddddddddddddddddddddddddddd

[無名VF]

mark up

[又是违规昵称]

好东东啊，收藏了

[lgfaichl]

老陈有实力啊，争取顶到天上去

[bendanlzh]

xmla查询能为你提供一种选择,XMLA架构更开放而且编程实现不依赖于具体的语言，同时也能在微软的工具中查询。而且DMXml 也只是xmla协议中的一部分。以下是微软事例库查询：
获取该维度的详细信息：
<?xml version="1.0" encoding="utf-8"?>
<SOAP-ENV:Envelope
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Body>
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis"
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<RequestType>MDSCHEMA_DIMENSIONS</RequestType>
<Restrictions>
<RestrictionList>
<CATALOG_NAME>Analysis Services Tutorial</CATALOG_NAME>
<SCHEMA_NAME></SCHEMA_NAME>
<CUBE_NAME>Adventure Works DW</CUBE_NAME>
<DIMENSION_UNIQUE_NAME>[Dim Product]</DIMENSION_UNIQUE_NAME>
</RestrictionList>
</Restrictions>
<Properties>
<PropertyList>
<Catalog>Analysis Services Tutorial</Catalog>
<Content>Data</Content>
</PropertyList>
</Properties>
</Discover>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

获取该维度下的层级
<?xml version="1.0" encoding="utf-8"?>
<SOAP-ENV:Envelope
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Body>
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis"
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<RequestType>MDSCHEMA_HIERARCHIES</RequestType>
<Restrictions>
<RestrictionList>
<CATALOG_NAME>Analysis Services Tutorial</CATALOG_NAME>
<SCHEMA_NAME></SCHEMA_NAME>
<CUBE_NAME>Adventure Works DW</CUBE_NAME>
<DIMENSION_UNIQUE_NAME>[Dim Product]</DIMENSION_UNIQUE_NAME>
</RestrictionList>
</Restrictions>
<Properties>
<PropertyList>
<Catalog>Analysis Services Tutorial</Catalog>
<Content>Data</Content>
</PropertyList>
</Properties>
</Discover>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
获取该维度下某个层级下的level
<?xml version="1.0" encoding="utf-8"?>
<SOAP-ENV:Envelope
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Body>
<Discover xmlns="urn:schemas-microsoft-com:xml-analysis"
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<RequestType>MDSCHEMA_LEVELS</RequestType>
<Restrictions>
<RestrictionList>
<CATALOG_NAME>Analysis Services Tutorial</CATALOG_NAME>
<SCHEMA_NAME></SCHEMA_NAME>
<CUBE_NAME>Adventure Works DW</CUBE_NAME>
<DIMENSION_UNIQUE_NAME>[Dim Customer]</DIMENSION_UNIQUE_NAME>
<HIERARCHY_UNIQUE_NAME>[Dim Customer].[Dim Customer]</HIERARCHY_UNIQUE_NAME>
</RestrictionList>
</Restrictions>
<Properties>
<PropertyList>
<Catalog>Analysis Services Tutorial</Catalog>
<Content>Data</Content>
</PropertyList>
</Properties>
</Discover>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>

[cqhweb]

好东东...

[headsea]

最好用XMLA来获取schema之类的信息

[yangdingyu8686]

维度。PROPERTY("属性").value