Project Accounting Cube - Missing project code





Description of Issue

Project code in Project Master does not display in Project Accounting Cube.



Context
  • Cubes

  • Project Ledger

  • Microsoft Excel



Cause
  • Project Code added before cube job ran

  • If Monthly Amounts are zero and nothing allocated detail lines that are unposted or posted transactions it will not display on cubes display



Resolution

This is working as designed. Posting a single transaction to the project will populate monthly amounts. Then wait for cubes to run overnight and it will pull in as expected.



Additional Information

The project code will show in pivot table filter just not display on screen for data due to lack of monthly amounts.

Please review the Master Article - Cubes Reporting with Excel for all Cubes related topics.