I have been using SQL 7.0 OLAP services for several months and am interested in hearing others experiences. I have found a number of problems with connectivity and functionality, but it seems to be an excellent first attempt.<br>
<br>
We found that you cannot use DB2 date fields as a datasource using either OLE DB or DB2 Connect. Apparantly OLAP services can only understand a timestamp field.
<br>
We found that you cannot use DB2 date fields as a datasource using either OLE DB or DB2 Connect. Apparantly OLAP services can only understand a timestamp field.