none
Timephased odata dump taking long time to refresh RRS feed

  • Question

  • Hi, I am using Odata Timephased Resource and Assignment tables in my report. As data has grown, it takes long time to refresh. Is there anything that I can do to make it fast. Thanks!!

    Wednesday, January 25, 2017 8:28 AM

Answers

  • Hello,
    If you are using the OData feeds in your reports, trim the data as much as possible as source. That includes only selecting the columns you need and also filtering the data you need in the report. That is all you can do unless you are pulling the data down into a SQL database then reporting from the SQL database - the reports then would be quick!

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Wednesday, January 25, 2017 4:42 PM
    Moderator