MDX函数妙用-获取当前相关日期

DeepMinder

于 2009-04-02 17:41:00 发布

阅读量3.5k

点赞数

CC 4.0 BY-SA版权

分类专栏： BI应用文章标签： date

本文链接：https://blog.youkuaiyun.com/RainyLin/article/details/4044311

BI应用专栏收录该内容

29 篇文章

订阅专栏

本文介绍了一种使用MDX（多维表达式）从一个完整的日期中拆解出年、月、日及季度的方法，并展示了如何通过创建计算成员来实现这一过程。具体包括：1. 定义了一个名为[FullDate]的计算成员，其值为当前日期；2. 分别创建了[WhatDay]、[WhatMonth]、[WhatYear]和[WhatQuarter]等计算成员，用于提取[FullDate]中的日、月、年和季度信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

WITH MEMBER [Measures].[Full Date] as 'NOW()'
-- The Second Calculated Member is the Day part of the first calculated member.
MEMBER [Measures].[What Day] as 'DAY([Full Date])'
-- The Third Calculated Member is the Month part of the first calculated member.
MEMBER [Measures].[What Month] as 'MONTH([Full Date])'
-- The Fourth Calculated Member is the Year part of the first calculated member.
Member [Measures].[What Year] as 'YEAR([Full Date])'
member [Measures].[What quarter] as 'Datepart(''q'',now())'
SELECT
{[Full Date],[What Day],[What Month],[What Year],[What quarter]} ON COLUMNS
FROM [adventure works]