WITH MEMBER [Measures].[FullDate] as NOW()
MEMBER [Measures].[Day] as DAY([FullDate])
MEMBER [Measures].[Month] as MONTH([FullDate])
Member [Measures].[Year] as YEAR([FullDate])
SELECT {
Measures.FullDate,
Measures.Day,
Measures.Month,
Measures.Year} on 0
from PNLDB_Cube;
--改进:
with member today as Format(Now(),'yyyy-MM-dd')
member year as year(today)
member month as month(today)
member day as day(today)
member quarter as Datepart('q',today)
member week as Datepart('w',today)--获取当天是这周的第几天,依赖set datefirst
member week as Datepart('ww',today)--获取当天是这年的第几周
select {today,year,month,day
,quarter,week} on 0
from [PNLDB_Cube];