TM1 Forum

Posted: **Mon Oct 26, 2009 10:07 am**

Is it possible to use databse table data for dimension creation or loading in TM1 TI when each table comes from 2 different databases but resides on 1 actual Database hardware. For example if I'm using MS SQL 2005 AdventureWorks & AdventureWorkDW sample database? If not...how do you accomodate such instances?

Code: Select all

SELECT 
AdventureWorks.HumanResources.Employee.EmployeeID,
AdventureWorksDW.dbo.DimEmployee.FirstName, 
AdventureWorksDW.dbo.DimEmployee.LastName,
AdventureWorks.HumanResources.Employee.Title,
AdventureWorks.HumanResources.Employee.MaritalStatus,
AdventureWorks.HumanResources.Employee.Gender,
AdventureWorksDW.dbo.DimEmployee.DepartmentName
FROM
AdventureWorksDW.dbo.DimEmployee,
AdventureWorks.humanresources.Employee
WHERE AdventureWorksDW.dbo.DimEmployee.EmployeeKey = AdventureWorks.humanresources.Employee.EmployeeID

Posted: **Thu Nov 05, 2009 3:24 pm**

You should be able to, but you might consider making a view and using ODBC to query the view. ODBC is a little bit flaky, so best to uncomplicate the query from TM1 to SQL Server.

You can even query databases from separate servers.

Posted: **Thu Nov 05, 2009 3:39 pm**

I agree, I'm not sure how TM1 would a where statement when using 2 different databases.

Posted: **Fri Nov 06, 2009 2:32 am**

But for ODBC you need to create a ODBC Driver for each data source. So what's the best approach when you need to combine 2 data sources either for creating hierarchy dimension or cube loading.

TM1 Forum

ODBC Source from 2 Database

ODBC Source from 2 Database

Re: ODBC Source from 2 Database

Re: ODBC Source from 2 Database

Re: ODBC Source from 2 Database