Snowflaking and circular logical schema [nQSError:15009]
713519Oct 17 2009 — edited Oct 18 2009Hi, I have this physical Diagram and joins in BI Admin:
FACT_table(FK_order, FK_store, amount_measure)
ORDER(PK_order, client, FK_city)
STORE(PK_store, district, FK_city)
CITY(PK_city, city, region, state)
After dragged them in Business model layer I'd want to create 2 dimensions with snowflaking in City (highlighted in upper-case):
ORDER with levels: order, client, CITY, REGION, STATE
STORE with levels: store, district, CITY, REGION, STATE
I make logical complex joins and create the levels but when I check consistency I get:
[nQSError: 15001] Could not load navigation space for subject area Snowflake_TEST.
[nQSError: 15009] Multiple paths exist to table CITY. Circular logical schemas are not supported.
it seems this schema it's not supported, isn't it? is there any other way to build 2 dimension with snowflake on the same table (in this case City)?
Thanks,
Matthew