Monthly Archives: August 2014

Create table as select (CTAS) with “not null” column

PDW v1 | PDW 2012 | APS CTAS (Create Table As Select) is a common way on the Parallel Data Warehouse (PDW) to transform one table into another table for example for calculations or for ELT (Extract Load Transform) processes. … Continue reading

Posted in Allgemein | 1 Comment

The ‘KeyColumns’ #0 has NullProcessing set to ‘UnknownMember’, but the dimension doesn’t have UnknownMember set to ‘Visible’ or ‘Hidden’

SQL Server 2005-2014   By default, SSAS provides an automatically created member with the name ‘unknown’ for each dimension. This member is intended to be the home for all facts that don’t fit to a real member (provided from the … Continue reading

Posted in Allgemein | Leave a comment