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

Sounds like you need to adjust your Dimension Usage tab in SSAS. If you
don't create the correct relationship - you will get funny results - such as
the same value in your counts all the way down as you browse the cube. When
I recently implemented a many to many cube this was a real challenge for
me - but I got it.

"ERS Developer" <ERSDeveloper@discussions.microsoft.com> wrote in message
news:180486EF-9187-470B-AFE0-FB6A0CCBF843@microsoft.com...
> 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

Thanks joe,

But processing the same cube against a different set of data and browinsg
the cubes shows the correct results for all the 3 dimensions.

So is that something releated to data or some corrupted files?

/
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

When you say different data - do you mean pulling from a DEV data mart
verses a TEST data mart?

I would construct some T-SQL against the data mart validating your figures -
then run that same code against the one your getting the funny results from.

That is part of our Testing cycles. We have scripts against the original
OLTP, and scripts against the data mart, and the same scripts against the
cubes - all 3 must match.

"ERS Developer" <ERSDeveloper@discussions.microsoft.com> wrote in message
news:247B5EF7-080E-4987-83A4-6A0518DA83F9@microsoft.com...
> Thanks joe,
>
> But processing the same cube against a different set of data and browinsg
> the cubes shows the correct results for all the 3 dimensions.
>
> So is that something releated to data or some corrupted files?
>
> /
> 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

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

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

Yes, I am processing the complete database itself with full process as option.

when I process the Cube wtih subset of data from datamart1 the values are
fine for all 3 dimensions.

From this we can confirm that data issues are causing this. Is would the
dimension data or the fact data causing this?

/
S

"Joe" wrote:

> 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
>

Hi,

Just an update. Looks like applying sp2 and processing the cubes solves the
problem.
Is there something to do with volume of data?

/
s

"ERS Developer" wrote:

> Yes, I am processing the complete database itself with full process as option.
>
> when I process the Cube wtih subset of data from datamart1 the values are
> fine for all 3 dimensions.
>
> From this we can confirm that data issues are causing this. Is would the
> dimension data or the fact data causing this?
>
> /
> S
>
> "Joe" wrote:
>
> > 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
> >

Never worked with Terabytes of data but you should be ok. Yeah - you wanted
SP2 for many other reasons too. If you started developing reports inside
BIDS you would have found some issues without the SP

"ERS Developer" <ERSDeveloper@discussions.microsoft.com> wrote in message
news:9F9D7D09-5A95-41E9-A615-B2086D4E143A@microsoft.com...
> Hi,
>
> Just an update. Looks like applying sp2 and processing the cubes solves
> the
> problem.
> Is there something to do with volume of data?
>
> /
> s
>
> "ERS Developer" wrote:
>
>> Yes, I am processing the complete database itself with full process as
>> option.
>>
>> when I process the Cube wtih subset of data from datamart1 the values are
>> fine for all 3 dimensions.
>>
>> From this we can confirm that data issues are causing this. Is would the
>> dimension data or the fact data causing this?
>>
>> /
>> S
>>
>> "Joe" wrote:
>>
>> > 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
>> >