Current day in reports RRS feed

  • Question

  • I set the schedule duration of one day. I need to make reports using PowerPivot. A simple tables that will contain the current day and the information related to this day. It is particularly important to do so when users open a report, all reports is active in the current date.
    Maybe someone knows which table can take days on the schedule or email a link to an example of how to do this?
    Wednesday, August 29, 2012 8:19 AM

All replies

  • Hi,

    Can you be more specific on query/issue as from your post not able to understand your exact problem.

    Thanks !!!

    Sachin Vashishth MCTS

    Thursday, August 30, 2012 11:27 AM
  • Any task related information be it duration or name or anything else is available in Reporting DB under task views(there are couple of them which would give values depends upon requirement) however for duration you can refer to MSP_EPMTask_Userview to get the same, as far as todays date is concerned you can use fucntion Today of power Pivot Date & Time function

    Let us know if this helps or provide some more information on what you are trying to achieve specifically & would be glad to help

    Thanks | Sunil Kr Singh |

    Wednesday, September 5, 2012 7:20 AM