I am working on SSAS05 with an Oracle ds., connected with Native OLE DB
/ MS OLE DB Provider for Oracle.

The "normal" datatype of the table keys in the .dsv in the property
window appears to be System.Int64.

If I create a Named Query the datatype of the key of the Named Query
table is automatically changed to System.Decimal.

The effect of the change to Decimal is that now I cannot join the table
with any other in the dsv because I get: "The my_source and the
my_destination columns have different datatype" and the join is not
made.

A solution is to change ALL of the tables in my dsv in Named queries,
which I do not want to do if poss.

Is it a bug? Can I change the datatype of Named Queries columns? How?

Any suggestion?

Thanks

Enzo