Hi there,

I have a cube that I am trying to build with multiple partitions, and
each partition has its own fact table (its a long story). The original
fact table I used when I built the cube was empty and had was called
CONTRACT_TABLE_CUBE. The monthly fact table is called
CONTRACT_TABLE_CUBE_MONTHLY20030131.

Anyway the drill through is not working, returning an Incorrect Syntax
Error, 4200. I ran a trace on the relational server to see the request
comming in and the following is a snippet of what I got....

SELECT "dbo"."CONTRACT_TABLE_CUBE"."ENHANCEMENT_AMOUN T",
FROM "CONTRACT_TABLE_CUBE_CURRENT_MONTHLY20030131",
"dbo"."ConvertedCurrency",
"dbo"."CONTRACT_TABLE_CUBE_CURRENT_MONTHLY20030131 " AS
"dbo"."CONTRACT_TABLE_CUBE"


The problem seems to be comming from using AS in the FROM clasue to
create an alias table for the SQL query. Is there some setting that
should be set to allow the above type of query to work

The Analysis server is 2k, with SP3 and the RDBMS is MS-SQL 2k with
SP3. Any help would be greatly appreciated.

Thanks in advance
JPO