|
|
You're in the
sql server data warehouse
group:null in Cubes measures
sql server data warehouse:
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
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. [quoted text, click to view] "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 [quoted text, click to view] "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
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. [quoted text, click to view] "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 [quoted text, click to view] "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
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? [quoted text, click to view] "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 [quoted text, click to view] "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 [quoted text, click to view] "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 [quoted text, click to view] "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 >> >
Don't see what you're looking for? Try a search.
|
January 2003
March 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |