gosh that does sound strange. So your test queries are coming back fine on
both dm's? My next step would have been to validate you ran the ETL ok - or
truncate the problem DM and re-run the ETL onto it.

Also; you are re-processing the Cube each time you change it's data source,
right?

"ERS Developer" <ERSDeveloper@discussions.microsoft.com> wrote in message
news:4C8EBB20-16DC-4347-ADF6-42040EAEA066@microsoft.com...
> Yes Joe,
>
> Let me give some more detail about this.
> Datamart1: Fact table has data for employee1, employee2, employee3 and the
> 3
> dimensions related to these 3 employees
>
> Datamart2: Fact table has data for employee4, employee5,employee6 and the
> 3
> dimensions related to these 3 employees.
>
> Now If i process the cube pointing to this Datamart1 and browse the cubes
> Dimesion 1 and 2 are fine and for dimension 3 it is showing null.
>
> But If I process the same version of the cube pointing to the datamart2
> and
> browse the cube all the 3 dimesions are showing the right data.
>
> I queried the datamart1 with inner join to fact and all 3 dimension
> tables.
> The results are coming fine.
>
> What is throwing me off is, if it fails for datamart2 then I can
> understand
> that cube is having some problems.
>
> Thanks
> S
>
> "ERS Developer" wrote:
>
>> Hi,
>> I have a simple cube with one measure group and 3 dimensions (A,B,C).
>> The cube is deployed and processed sucessfully.
>>
>> When I browse the cubes with Dimension A and B the measure is showing the
>> data. But when I start using the third dimension C the measure is showing
>> as
>> null.
>>
>> Any help is appreicated.
>>
>> Thanks
>> S