| Author |
 Topic  |
|
|
roquesalde
Argentina
38 Posts |
 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 |
|
|
admin
1637 Posts |
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?
|
 |
|
|
roquesalde
Argentina
38 Posts |
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
1637 Posts |
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
Argentina
38 Posts |
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
1637 Posts |
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 |
|
|
| |
Topic |
|
Report Portal
Current Year - Time Dimension
