on 09-27-2016 6:18 PM
Hi, can someone provide me the definition of the table M_TIME_DIMENSION_WEEK from _SYS_BI schema. I have lost this table in my practice system and need to re create it
Hello Hari,
here is the create table statement for the table.
CREATE COLUMN TABLE "_SYS_BI"."M_TIME_DIMENSION_WEEK" (
"YEAR" VARCHAR(4),
"HALFYEAR" VARCHAR(2),
"QUARTER" VARCHAR(2),
"MONTH" VARCHAR(2),
"WEEK" VARCHAR(2),
"YEAR_INT" INTEGER CS_INT,
"HALFYEAR_INT" TINYINT CS_INT,
"QUARTER_INT" TINYINT CS_INT,
"MONTH_INT" TINYINT CS_INT,
"WEEK_INT" TINYINT CS_INT,
PRIMARY KEY INVERTED VALUE ("YEAR", "WEEK")
) UNLOAD PRIORITY 0 AUTO MERGE
Regards,
Florian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.