T O P I C R E V I E W |
roquesalde |
Posted - 12/21/2009 : 05:49:03 Hello,
I´ve a problem with time dimesion, shows the current year as 2020, before this not happened, which may be the problem?
Regards
Roque A. Salde www.corebi.com.ar |
5 L A T E S T R E P L I E S (Newest First) |
admin |
Posted - 01/20/2010 : 20:55:43 The equivalent MDX expression to "getdate()" in t-SQL:
SELECT [Measures].Members ON COLUMNS, {StrToMember("[Date].[Calendar].[" + Format(Now()-1, "MMMM d, yyyy") + "]")} ON ROWS FROM [Adventure Works]
Please try this option: Admin > Settings > OLAP report > Time Dimension - Current Day = Formula |
roquesalde |
Posted - 01/19/2010 : 10:46:10 Hi, thanks for your help. The last row shows 01/12/2010, because this cube has a target measure, this measure is automatically calculated. Wich is the equivalent mdx expression to "getdate()" in t-sql?
Regards
Roque A. Salde www.corebi.com.ar |
admin |
Posted - 01/18/2010 : 19:48:47 Please try to run this MDX against your cube:
Select non empty [Time].[Date].Members on rows, non empty { [Measures].AllMembers} on columns From [My Cube]
What is the last row you see? |
roquesalde |
Posted - 01/18/2010 : 07:18:41 Hi, the problem was because I have values for year 2020, I correct that but the mdx query to obtain de current day don't work, could you send me the correct mdx expression?
Regards,
Roque A. Salde www.corebi.com.ar |
admin |
Posted - 12/21/2009 : 16:42:51 Please go to Admin > Settings > OLAP Report > Time Dimension - Current Day. The default method is "Last member that has value for any of the measures".
Does year 2020 have value for any measure? Which method did you select?
|