on 07-17-2017 7:00 AM
Hi,
I created a temporal join with following tables:
Orders_Data:
CREATE COLUMN TABLE "KABIL"."ORDERS_DATA" ("ORDER_NUMBER" BIGINT,
"CUST_NO" INTEGER,
"PROD_CODE" INTEGER,
"ORDERED_DATE" DATE,
"QTY_ORDERED" INTEGER,
"AMOUNT" DECIMAL(10,2));
INSERT INTO "KABIL"."ORDERS_DATA" VALUES(34578,91,611,'2014-06-14',25,570);
INSERT INTO "KABIL"."ORDERS_DATA" VALUES(34579,93,624,'2014-07-15',67,1000);
INSERT INTO "KABIL"."ORDERS_DATA" VALUES(34671,94,624,'2014-08-28',75,12000);
INSERT INTO "KABIL"."ORDERS_DATA" VALUES(34685,91,639,'2015-07-26',34,17000);
Customers_data:
CREATE COLUMN TABLE "KABIL"."CUSTOMERS_DATA"("CUST_NO" INTEGER,
"CUST_NAME" NVARCHAR(100),
"SHIP_CITY" NVARCHAR(50),
"SHIP_COUNTRY" NVARCHAR(50),
"VALID_FROM" DATE,
"VALID_TO" DATE);
INSERT INTO "KABIL"."CUSTOMERS_DATA" VALUES(91,'Max Video','HOUSTON','USA','1900-01-01','2014-12-31');
INSERT INTO "KABIL"."CUSTOMERS_DATA" VALUES(91,'Max Video','LOS ANGELES','USA','2015-01-01','9999-12-31');
INSERT INTO "KABIL"."CUSTOMERS_DATA" VALUES(92,'Sound Vision Corp','BANGALORE','INDIA','1900-01-01','9999-12-31');
INSERT INTO "KABIL"."CUSTOMERS_DATA" VALUES(93,'Practical Periphrals','SYDNEY','AUSTRALIA','1900-01-01','9999-12-31');
INSERT INTO "KABIL"."CUSTOMERS_DATA" VALUES(94,'Cash 4 Checks','PARIS','FRANCE','1900-01-01','9999-12-31');
And i create an Attribute View for Customers Data and select all the fields for output.
the attribute view name AT_CUST_TIME_DEPENDENT
finally i create an analytic view (AN_TEMPORAL_JOIN) and use the ORDERS_DATA table in data foundation section and AT_CUST_TIME_DEPENDENT attribute view in star join section.
i joined the table following conditions:
when i activate this view its shows :
Message : Repository: Encountered an error in repository runtime extension;Model inconsistency. Attribute ORDERED_DATE not found in analytic view.
What to do for this error?
And whenever i validate my join its shows : Table or View not found.
Hi Kabil,
In the attached screen shot of your issue, Ordered_Date is created as Measure. Could you please change it to Dimension and then activate the view. I have tried the same and its working fine for me.
Please let us know whether it is working or not after modification.
Thank You,
RP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Kabil,
not sure if you can try this - Instea of creating the attribute and analytic views, can you please change those to calculation views (as per best practices only CVs should be considered now) - try it and see if by having the different view type would solve the error.
On another note, do you need to have the star join or can it simply be an inner join (from 2 sources) - join node from HANA?
Finally, I assume, your tables/views were activated successfully and you can do a data preview on them?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.