SSRS报表中MDX语句数据集字段

最新推荐文章于 2022-10-01 14:11:03 发布

hxp42

最新推荐文章于 2022-10-01 14:11:03 发布

阅读量1.1k

点赞数

分类专栏： SSRS

本文链接：https://blog.csdn.net/hxp42/article/details/41678265

版权

SSRS 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Level" UniqueName="[维度名称].[维度].[维度]" />

<?xml version="1.0" encoding="utf-8"?><Field xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:type="Measure" UniqueName="[Measures].[ParameterLevel]" />

WITH MEMBER [Measures].[ParameterCaption] AS [XXX维度].[XXX].CURRENTMEMBER.MEMBER_CAPTION
MEMBER [Measures].[ParameterValue] AS [XXX维度].[XXX].CURRENTMEMBER.UNIQUENAME
MEMBER [Measures].[ParameterLevel] AS [XXX维度].[XXX].CURRENTMEMBER.LEVEL.ORDINAL
SELECT {[Measures].[ParameterCaption],
[Measures].[ParameterValue],
[Measures].[ParameterLevel]} ON COLUMNS ,
EXCEPT([XXX维度].[XXX].[ALL].Children,
{[XXX维度].[XXX].&[-1],[XXX维度].[XXX].[All].UNKNOWNMEMBER}) ON ROWS
from (select strtoset(@Parmeter) on columns from [CUBE])