I'm building a SAS cube in SAS Olap Studio by sourcing the cube from a star schema. I was expecting the studio to pick up my foreign keys and to suggest possible dimensions based on the foreign keys. Instead, I have to select the dimensions and keys once again. Am I missing something? Shouldn't the studio generate this for me?
Are the Foreign Keys only stored in the tables, or also in the registered SAS metadata? IIRC, if the FK info isn't stored also in the SAS metadata when the tables are registered OLAP Cube Studio won't pick them up.
Michelle
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.