Hi All,
Can anyone tell me whether TM1 9.1.3 supports ADOMD.NET?? and if so what library files do i need to reference?
Cheers
Shock
ADOMD.NET support for TM1?
-
George Regateiro
- MVP
- Posts: 326
- Joined: Fri May 16, 2008 3:35 pm
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: 2007 SP3
- Location: Tampa FL USA
Re: ADOMD.NET support for TM1?
As far as I know your two main options for .net data access are:
1) The .NET API - Add a reference to the APPLIX.TM1.API dll (it is in the TM1 bin directory) and try to connect that way.
2) Use the OLE DB ODBO adapter to get to the data (I dont remember the specific on how to do it, its been a while)
Personally I would stick with choice 1 since it gives you the most power. 2 is great for simple data requests, but the TM1 implementation of the driver is not entirely standard so you will have trouble with MSAS specific controls (I tried this out using the Dundas OLAP charts and tools, it did not go well since those were desinged for MSAS).
1) The .NET API - Add a reference to the APPLIX.TM1.API dll (it is in the TM1 bin directory) and try to connect that way.
2) Use the OLE DB ODBO adapter to get to the data (I dont remember the specific on how to do it, its been a while)
Personally I would stick with choice 1 since it gives you the most power. 2 is great for simple data requests, but the TM1 implementation of the driver is not entirely standard so you will have trouble with MSAS specific controls (I tried this out using the Dundas OLAP charts and tools, it did not go well since those were desinged for MSAS).