Key column of a dimension in SSAS

When defining the attribute, we always specify the surrogate key as the key column for any attribute. I was just thinking if we could make use of the natural key instead of the surrogate key. i.e., in case of a product attribute, the surrogate key say...

2009-04-23

2,629 reads

Blogs

I’ll be speaking at SQL Server Virtual Conference from C# Corner

By

I’ll be speaking at the SQL Server Virtual Conference from C# Corner, Friday Jan...

What is a model database?

By

Do you ever take a look at SSMS in the System Databases section? People...

Daily Coping 26 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

How to create a gantt chart for event rooms during a day

By PatrikW

Hi all, This will be my first ever post in a forum like this....

[ODBC Error]

By DBA_007

When backup job runs we are receiving the below error and database connection closes....

Error: The size necessary to buffer the XML content exceeds the buffer quota

By Jim-S

Hi Guys, I have a report named Master and a report named Child, Child...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers