Wednesday, March 7, 2012

Pass System date as parameter in OLAP report

Hi,

How to pass system date as parameter in a OLAP report? Also let me know how to pass parameter from One OLAP report to other?Hello,

I've used two separate methods for date driven reports:

1) Use the NOW() function to build strings representing members in your Date dimension. You would actually do this in the MDX.

2) Use data in your cube to dynamically determine what "today" is. In other words, find the last member in your Date dimension which has data and call that "today".

HTH

Todd

No comments:

Post a Comment