Hi,

I've a cube based on a view.
The view is like this:
Select 1 as DimID, * from tableA
union all
Select 2 as DimID, * from tableB

I've a dimension which help the user to select only the data from the tableA
or tableB. This dimension is linked to the DimID column.

The default member of this dimension is "tableA".
When the user drill through, I've a result.
if the user changes to view the "tableB" and drill through, I received a
timeout error, but not after 30sec, just after the click!!!
but my SQL server used 100% of the processor and I must stop it to free the
resources.

I don't know what's appends.

Any idea?

Thanks

Jerome.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.595 / Virus Database: 378 - Release Date: 2004-02-25