Monday 15 August 2011

mdx - saiku Date Difference error -


I am getting wrong results while calculating the difference between two dates using the sync.

  / *** with question / member remedies. Detdif as DD ('D', CDAT ('20 March 2014'), CDAT ('April 1, 2014'), 3,3). DD, [Cube_AR] / *** output *** / 1 / *** estimated output *** / 30  

and I usually use double quotation marks around my " D ". DDI (" D "," CDAT ('March 20, 2014'), CDAT ('April 1, 19, 2014'), 3,3) {Remedy DD, measures. DF} [Cube_AR] on the column

is a strange day as the first day of 3 weeks?


No comments:

Post a Comment