AnsweredAssumed Answered

DWH and JS report

Question asked by Yaman_Yazgan on Jan 24, 2017
Latest reply on Feb 9, 2017 by SKJ

Hi all,


I want to ask how tables are populated in DWH? I have difficulties in gettin resource related reports (resource availability, capacity vs demand etc). When I look at the dataset from the report for resource availability report, it uses a few tables. Resources are ok, I can select records from the table.  For the other 3 tables the results are;

select * FROM dwh_res_period_facts pf (no record)

select * FROM dwh_cmn_period c (1 fiscal period)

select * FROM dwh_cmn_period_ln cln (1 fiscal period)


Previously only one fiscal was defined (01-01-16 / 31-01-16) and the fiscal period is in the table. Then we have defined all fiscal periods(monthly) for years 2016-2017-2018 and activated the year 2017.


Then we have run the update reports tables and LDW jobs. But the tables are not populated. What am I missing?