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.