MDX中上年没有数据时怎么判断?我用IIF判断为什么会失败的?
0
为什么我用IIF来判断上年没有数据时返回其他值会失败的?
WITH
MEMBER [Measures].[Prior Period Reseller Sales Amount] AS
(
ParallelPeriod(
[Date].[Calendar].[Calendar Year],
1,
[Date].[Calendar].CurrentMember
),
[Measures].[Reseller Sales Amount]
)
,FORMAT="Currency"
MEMBER [Measures].[Prior Period Growth] AS
(
([Measures].[Reseller Sales Amount])-([Measures].[Prior Period Reseller Sales Amount])
)
/
([Measures].[Prior Period Reseller Sales Amount])
,FORMAT="Percent"
MEMBER [Measures].[没有上年数据] AS
IIF([Measures].[Prior Period Reseller Sales Amount] IS NULL,0,1)
SELECT
{
([Measures].[Reseller Sales Amount]),
([Measures].[Prior Period Reseller Sales Amount]),
([Measures].[Prior Period Growth]),
([Measures].[没有上年数据])
} ON COLUMNS,
{
Descendants(
[Date].[Calendar].[Calendar Year].[CY 2006],
[Date].[Calendar].[Month],
SELF
)
} ON ROWS
FROM [Step-by-Step]
WITH
MEMBER [Measures].[Prior Period Reseller Sales Amount] AS
(
ParallelPeriod(
[Date].[Calendar].[Calendar Year],
1,
[Date].[Calendar].CurrentMember
),
[Measures].[Reseller Sales Amount]
)
,FORMAT="Currency"
MEMBER [Measures].[Prior Period Growth] AS
(
([Measures].[Reseller Sales Amount])-([Measures].[Prior Period Reseller Sales Amount])
)
/
([Measures].[Prior Period Reseller Sales Amount])
,FORMAT="Percent"
MEMBER [Measures].[没有上年数据] AS
IIF([Measures].[Prior Period Reseller Sales Amount] IS NULL,0,1)
SELECT
{
([Measures].[Reseller Sales Amount]),
([Measures].[Prior Period Reseller Sales Amount]),
([Measures].[Prior Period Growth]),
([Measures].[没有上年数据])
} ON COLUMNS,
{
Descendants(
[Date].[Calendar].[Calendar Year].[CY 2006],
[Date].[Calendar].[Month],
SELF
)
} ON ROWS
FROM [Step-by-Step]
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
2 个回复
luruyin861583 - 一句话介绍 2016-04-07 回答
赞同来自:
天桥下的郑成功 - Hadoop大数据开发工程师、数仓架构师、熟悉数据仓库设计、Hadoop、Spark、HBase、Hive、SSIS等开发 2016-04-04 回答
赞同来自: