You're lower levels would also have to be "hideable", or else it's not going to work. It looks like you have a level below city that would not meet...

I'm not sure something important isn't being overlooked. Consider the original table:

Note that the man/car has a primary key and two fks...

You have my sympathy in a way. I started when I was assigned to determine why a data cube created by a consultant was not producing the correct data....

You're welcome. I'm glad I was able to assist.

Getting my head around the concepts is easier in practise but when working in a team of 1 with no experience...

Without seeing the information I can't be sure, but it sounds odd to have the contact reference as both the fact table granularity and a dimension. Ralph Kimball refers...

My take, and many others, is that table names are singular. ...

You don't make clear the level of granularity for the fact table. If it is an individual call, you can have the phone number as a field and then...

Usually PK in this DIM table will be a surrogate key, new row gets then a new PK and new information entered into the FACT table will point to the...

Do you have all the foreign key constraints in place? If not, something may have crept in.

I'm not certain why your bosses allocated the resources to construct a cube and the ETL process to populate it. If all they needed was a server to query,...

Fear isn't the issue. In situations for which there is a simpler solution, they are a royal pain.

Unless you KNOW you will never use anything but US zip codes, consider making the field length 7 to handle Canadian zip codes. Recently went through a somewhat painful...

Not sure I get the sequential GUIDs comment. Do all the GUIDs in the different tables start with 00000.....01? Then they wouldn't be unique across the database. ...

Thanks for the tip, but what is the best practice here ?

Should you add it as a calculated column to yr data source view or to the underlying data table...

It's more work up front, but I think you would be better served creating a key column in the date dimension table. It would essentially be the number of...