none
Report shows no updates RRS feed

  • Question

  • Every once in a while we bumped into complaint updates not show on our report dashboard. We use Tableau to retrieve information from our db, the updates stays the same.  We are curious to find out the root cause instead of reacting to issue each time.

    Background:

    Users update their progress to 100%, the dashboard display old percentage despite display 100% in the project.  When I check with our DBA, she responded she still sees the old percentage from PWA from her end but in the PWA it shows 100%. 

    Stop gap solution:

    What we did was just deleting that row and re-enter the value again but we wish to find the root cause.  Your thought?


    NLuu

    Monday, June 24, 2019 4:01 PM

All replies

  • Hi,

    If in PWA it shows the correct value, then the issue should be around the synchronisation or your connection between the DB and Tableau. On which DB your Tableau queries are? On the reporting Project DB? Or on a replicated DB?

    Note that PWA (project center for instance) shows the Reporting DB values. 


    Hope this helps,


    Guillaume Rouyre, MBA, MVP, P-Seller

    Tuesday, June 25, 2019 7:38 AM
    Moderator
  • On the Reporting PWA, we turned those off.  We use FluentPro DataMart to connect between PWA (online) to Tableau (onprem).  After the schedulers, approved again then the change reflected in the Tableau dashboard, root cause still not found where the issue was.  I notice ever since we implemented formula to display task status, we bump into this frequent strange issue. 


    NLuu

    Friday, June 28, 2019 3:39 PM