Question Re: issue with temporal join temporal column attribute.. in Technology Q&A

issue with temporal join temporal column attribute..

former_member383962 — Mon, 17 Jul 2017 06:00:15 GMT

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:

Join type is Inner.
Temporal Column: Ordered_date
From column: Valid_from
To column: Valid_to

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.

Re: issue with temporal join temporal column attribute..

SergioG_TX — Mon, 17 Jul 2017 10:33:58 GMT

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?

Re: issue with temporal join temporal column attribute..

Former Member — Mon, 17 Jul 2017 11:23:55 GMT

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,

Re: issue with temporal join temporal column attribute..

Former Member — Thu, 07 May 2020 16:00:57 GMT

kabilarasan

Did you ever find a solution to how to properly setup a Temporal Join using the Data Foundation and Star Join objects of an Analytic View? I'm having a similar issue.

Thanks,

Scott