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

Updated Pluralsight Course – Kubernetes Installation and Configuration Fundamentals

By

My updated course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want...

Power BI and a Star Schema

By

I sometimes get asked from customers if they should use a star schema or...

A New Git Default Branch

By

I learned a new trick from Andrew Pruski. In a blog on avoiding PowerPoint,...

Read the latest Blogs

Forums

poor query performance by joining large table and new CE

By tdo

We have a complex stored procedure working in our database. Some of the statements...

Problem with creating query for allocating amount

By Deimos_farm

good day i came a cross of a problem I have a query that...

Problem with Logic for new column

By kobinarashid

Hi guys, I have the following table DDL/DML CREATE TABLE #DailyOnHandForecast (Id INT, ItemNo_...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers