Is there anyway to alter the joins outisde of the cube editor schema?

When I have construct the joins in query analzyer, the data results is fine
but the joins via AS is not matching my results.

I'm curious to know is there anyway, to customize or alter the joins that
SSAS 2K builds?

Hi,

Consider using the Optimize Schema. The aim is to get a query that does not
make any join! Seach "Eliminate Joins between Fact and Dimension Tables" on
http://www.microsoft.com/technet/pro...cspg.mspx#EDAA

Remember that if you use the Slices AS2K will make a join with the
dimension's base table/view. There is away to change this behavior by
modifying the registry for more info check
http://www.microsoft.com/technet/pro...cspg.mspx#EDAA

Hope it helps,
TR.

"SAM" wrote: