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?