I am running a financial report off of an ASO cube with type measures enabled. However, when i run the report in FR, that date data coming out is 1 day less...for eg 04/30/2012 comes out as 04/29/2012.
however, when i run the same ad-hoc report via smart view, it is fine and the date comes out as expected. this is happening only in FR.
Any help in this regard will be much appreciated.
I'm not sure what version you are running, but this was determined to be a bug that was fixed in 11.1.2.
Although not pretty, you can add a similarly named dynamic member that will advance your date for you that you could use in FRS. You could use the DateRoll function: DateRoll ([Date Dimension], DP_DAY, 1 ). Just an idea.