Traditional web-based reporting with SAS BI tools

OLAP - Foreign keys

Reply
Occasional Learner
Posts: 1

OLAP - Foreign keys

Hi,

 

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?

 

Sanjeev

Contributor
Posts: 60

Re: OLAP - Foreign keys

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
Ask a Question
Discussion stats
  • 1 reply
  • 190 views
  • 0 likes
  • 2 in conversation