crystalempress
Programmer
Does anyone know how to create a calculated member in a cube trying to find the datedifference between a specific date and the current date? Using sql2005
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Calculated Member using Current Date
- Thread starter crystalempress
- Start date
- Status
- Thread starter
- #2
crystalempress
Programmer
I can get it this far where I don't error out?
with MEMBER [MEASURES].[monthdiff]
AS 'DateDiff ("m",
[Written Date].[Fiscal].[Day],
now())'
select [MEASURES].[monthdiff] on columns,
[Written Date].[Fiscal].[Day] on rows
from sales
but for each row I get back 24079
with MEMBER [MEASURES].[monthdiff]
AS 'DateDiff ("m",
[Written Date].[Fiscal].[Day],
now())'
select [MEASURES].[monthdiff] on columns,
[Written Date].[Fiscal].[Day] on rows
from sales
but for each row I get back 24079
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question