Archives of the TeradataForum
Message Posted: Thu, 17 Jan 2008 @ 11:41:24 GMT
Subj: | | Use of Date Datatype for SQL Server 2005 Analysis |
|
From: | | Okell, Alan |
We are producing a Proof of Concept ROLAP implementation for a Business Analytical Application using Microsoft SQL Server 2005 Analysis
Services. The inability to filter on a Teradata Date datatype is obviously a known issue but I was wondering what experiences other sites have had
with the suggested workarounds:
- Create a view in Teradata and Cast Date column to Timestamp(6). Modify Analysis Services project to use View
- Use Business Intelligence Development Studio to add a Named Calculation
- Create / Use Surrogate Keys, Filter on Surrogate Key and displaying the actual date value (ie date_id, date_desc)
For now, dates in the Fact table are in Integer format.
|