提问人:Jeevan 提问时间:7/24/2023 最后编辑:Jeevan 更新时间:7/24/2023 访问量:17
MDX 查询设计器在列中提供 null 值
MDX query designer giving null values in column
问:
我正在使用报表生成器创建 MDX 查询,由于某种原因,其中一列显示 null 值。我知道该列有数据,但不确定为什么 MDX 会给出空值。
谁能帮忙解决这个问题?这是我的查询:
SELECT
NON EMPTY { [Measures].[Premium LCL] } ON COLUMNS,
NON EMPTY { (
[D_BU].[Business Unit Number].[Business Unit Number].ALLMEMBERS *
[D_Policy].[OriginalPolicyID].[OriginalPolicyID].ALLMEMBERS *
[D_Revenue_Attribute].[InsurerName].[InsurerName].ALLMEMBERS *
[D_Client].[ClientName].[ClientName].ALLMEMBERS *
[D_TransactionDate].[Accounting Month Number].[Accounting Month Number].ALLMEMBERS * [D_TransactionDate].[Accounting Year].[Accounting Year].ALLMEMBERS *
[D_TransactionDate].[Accounting Month Year].[Accounting Month Year].ALLMEMBERS * [D_PolicyExpirationDate].[Expiration Month Year].[Expiration Month Year].ALLMEMBERS * [D_Policy].[InceptionDate].[InceptionDate].ALLMEMBERS *
[D_Product].[Product Line].[Product Line].ALLMEMBERS *
[D_Product].[Product Coverage].[Product Coverage].ALLMEMBERS *
[D_BU].[Region Name].[Region Name].ALLMEMBERS *
[D_BU].[Branch Name].[Branch Name].ALLMEMBERS *
[D_CarrierPayee].[Placement Market Group].[Placement Market Group].ALLMEMBERS * [D_Industry_SIC].[SIC Level 2 Name].[SIC Level 2 Name].ALLMEMBERS *
[D_Industry_SIC].[SIC Level 3 Name].[SIC Level 3 Name].ALLMEMBERS
) } DIMENSION PROPERTIES MEMBER_CAPTION ON ROWS
FROM
(
SELECT
(
{[D_BU].[RegionName].&[GGB UK - Underwriting],
[D_BU].[RegionName].&[GGB UK - Specialty],
[D_BU].[RegionName].&[GGB(UK & Ireland)] }
) ON COLUMNS
FROM
(
SELECT
(
-{ [D_BU].[BranchName].&[Re Centre],
[D_BU].[BranchName].&[UK&Ireland] }
) ON COLUMNS
FROM
(
SELECT
(
{ [D_TransactionDate].[Accounting Year].&[2019] : null}
) ON COLUMNS
FROM
[Model]
)))
WHERE ( [D_BU].[RegionName].CurrentMember ) CELL PROPERTIES VALUE
答: 暂无答案
评论