Your comments
Thanks! Makes sense now.
9 years ago
I see. I missed that. That was really what I was expecting for the behavior. I was not able to figure out how to select multiple tables. When I tried it did not look like they were selected. I will try again.
Please at least add a clear warning: This import will overwrite your current model. Do you want to continue?
Here is another example. If I remove the last section (in bold) then it works fine.
SELECT
SELECT
PIT.HUB_EMPLOYEE_KEY AS DIM1_EMPLOYEE_KEY,
PIT.PIT_LOAD_DTS AS EFFECTIVE_DATE,
HE.EMPLOYEE_ID,
NM.FIRST_NAME,
NM.LAST_NAME,
NM.GENDER,
NM.MARITAL_STATUS,
NM.SSN,
ADDR.ADDRESS1,
ADDR.ADDRESS2,
ADDR.CITY,
ADDR.STATE,
ADDR.POSTAL_CODE,
ADDR.COUNTRY,
CNTC.EMAIL,
CNTC.PHONE_NUMBER,
COMP.SALARY_BEGIN_DATE,
COMP.SALARY,
COMP.COMMISSION_PCT,
SAL.MIN_SALARY,
SAL.MAX_SALARY,
SAL.AVG_SALARY,
SAL.TOTAL_SALARY_TODATE
FROM
HUB_EMPLOYEE HE,
EMPLOYEE_PIT PIT,
SAT_EMPLOYEE_ADDRESS ADDR,
SAT_EMPLOYEE_NAME NM,
SAT_EMPLOYEE_CONTACTS CNTC,
SAT_EMPLOYEE_COMPENSATION COMP,
SAT_EMPLOYEE_SAL_SUM SAL
WHERE
HE.HUB_EMPLOYEE_KEY = PIT.HUB_EMPLOYEE_KEY
AND HE.HUB_EMPLOYEE_KEY = ADDR.HUB_EMPLOYEE_KEY
AND HE.HUB_EMPLOYEE_KEY = NM.HUB_EMPLOYEE_KEY
AND HE.HUB_EMPLOYEE_KEY = CNTC.HUB_EMPLOYEE_KEY
AND HE.HUB_EMPLOYEE_KEY = COMP.HUB_EMPLOYEE_KEY
AND HE.HUB_EMPLOYEE_KEY = SAL.HUB_EMPLOYEE_KEY
AND PIT.SAL_SUM_LOAD_DTS = SAL.SAT_LOAD_DTS
AND PIT.NAME_LOAD_DTS = NM.SAT_Load_DTS
AND PIT.ADDRESS_LOAD_DTS = ADDR.SAT_Load_DTS
AND PIT.CONTACT_LOAD_DTS = CNTC.SAT_Load_DTS
AND PIT.COMPENSATION_LOAD_DTS = COMP.SAT_Load_DTS
AND PIT.PIT_LOAD_DTS =
(
SELECT
MAX(PIT2.PIT_LOAD_DTS)
FROM
EMPLOYEE_PIT PIT2
WHERE
HE.HUB_EMPLOYEE_KEY = PIT2.HUB_EMPLOYEE_KEY
)
Sorry this should be a BUG.
This is very important. Especially with multi-table views. The view builder should be able to use the relationships between table to automatically populate the correct join conditions.
Found the error when I read all the messages - password was expired!
Thanks.
Thanks.
Along these lines, I would like to be able to change the color of a group of tables. In Data Vault I have Hub, Link, and Sat tables. If I could set all tables with a prefix of Hub_ to blue, etc. that would be great. Or have a way to categorize the tables and assign the color to the category so when I build a new table, I pick the vategory and the color, font, etc are automatically apploed.
Also this would be how to resize an element.
Thanks! Almost there - this time error was "unable to connect to database" (yes it is running on my local machine)
Thanks also for the tip on importing for SQL. I will give that a try!
Thanks also for the tip on importing for SQL. I will give that a try!
Customer support service by UserEcho
