February 9, 2011 at 12:11 pm
Hi,
Is it possible to make a cube from 1 table only..That table has a primary key also.
Iam not able to make the cube as when i try to make it , it doesnt show the primary key in hte cube.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
February 9, 2011 at 1:55 pm
Yes, I just tested it with the query below. Other than warnings that I have no time dimension and that I *shouldn't* make a cube with only one dimension, it processed and worked as expected. I suspect you may not have a unique column for a primary key, which is why ssas is complaining.
Select 'Sir Lancelot of Camelot' As Knight
,'Seek the Holy Grail' As Quest
,'Blue' As Colour
,3 As Correct_Answers
,0 As Wrong_Answers
Union All
Select 'Sir Robin of Camelot' As Knight
,'Seek the Holy Grail' As Quest
,NULL As Colour
,2 As Correct_Answers
,1 As Wrong_Answers
Union All
Select 'Sir Galahad of Camelot' As Knight
,'Seek the Holy Grail' As Quest
,'Yellow' As Colour
,2 As Correct_Answers
,1 As Wrong_Answers
Union All
Select 'Arthur, King of the Britons' As Knight
,'Seek the Holy Grail' As Quest
,NULL As Colour
,2 As Correct_Answers
,0 As Wrong_Answers
February 10, 2011 at 8:16 am
yes the column is not unique but is a primary key..
what should i do?
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
February 10, 2011 at 8:27 am
SKYBVI (2/10/2011)
yes the column is not unique but is a primary key..what should i do?
Regards,
Sushant
Primary keys must be unique. Use your ETL process to degenerate one. Identity columns make for easy primary keys. If you are trying to load data directly from a flat file or other non-SQL source, you may have to stage it in a SQL database first. You may also find that if you degenerate dimension tables in your ETL, that your load into SSAS will be much faster.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply