Server and column collation conflicts in properties of a login

Problem: Error: Cannot resolve the collation conflict between “Danish_Norwegian_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the UNION operation. (Microsoft SQL Server, Error: 468) when clicking “Securables” in properties of a server login. Setup: Server is set up with collation: SQL_Latin1_General_CP1_CI_AS The database, or more precisely, the columns are created with collation: Danish_Norwegian_CI_AS Login is set up with default…

Read More

Rolling period with shell dimension SSAS

Often I meet the business requirement of listing data for the last X months. In this blog post, I will try to give my shot at, how this is done elegantly and with maximum flexibility. We start of backwards and enhance the Data Source View in the cube with a custom Named Calculation called UtilityKey (or whatever you like)…

Read More