This is a known issue and was fixed in 6.3-2.
==== CL 9239 ====
@FIX: global resource tables were not getting created in new instances of the datawarehouse db, only on upgrades.
Upgrade your supervisor to 6.3-4 to resolve it, or run the following SQL when logged into your mysql server instance as root:
USE pfx_dw;
DROP TABLE IF EXISTS globalresource_fact;
CREATE TABLE globalresource_fact (
time_sk INT NOT NULL
, resource_sk MEDIUMINT UNSIGNED NOT NULL
, total MEDIUMINT UNSIGNED NOT NULL
, used MEDIUMINT UNSIGNED NOT NULL
)
ENGINE=MyISAM
;
DROP TABLE IF EXISTS resource_dim;
CREATE TABLE resource_dim (
resource_sk INT NOT NULL AUTO_INCREMENT PRIMARY KEY
, name VARCHAR(255) NOT NULL UNIQUE
)
ENGINE=MyISAM
;
INSERT INTO resource_dim
(resource_sk, name)
VALUES('1', 'qube')
;