29 august 2012 08:19I 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?
30 august 2012 11:27
Can you be more specific on query/issue as from your post not able to understand your exact problem.
Sachin Vashishth MCTS
5 septembrie 2012 07:20Moderator
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 | http://epmxperts.wordpress.com