How To Install SSAS 2019
In this article we walk through the steps to install SQL Server Analysis Services for SQL Server 2019.
2020-12-22
analysis services
Implementing Drill Through Actions in SSAS
Business users get great value from SSAS cubes. In this article, learn how to create a drill-through action in an SSAS multi-dimensional model cube.
2020-03-09
3,556 reads
Introduction to Attribute Relationships in SSAS
In this article, you will learn how you can set the attribute relationships between dimensions in SSAS.
2020-02-10
4,362 reads
Analysis Services : OLEDB Error while processing in SSAS
Problem This is one of the errors that I frequently encounter while deploying or processing SSAS OLAP cubes on the client's computers or on a remote server. Recently, one of my team members also faced the same issue and so I thought to write a resolution for the issue. The error is something like this: […]
2020-02-03
4,242 reads
SSAS Error: Duplicate attribute key found when processing
Learn how to resolve a duplicate value error when processing dimensions in SSAS.
2020-01-20
13,645 reads
Connecting to Analysis Services in Another Domain
Connecting to resources in untrusted domains with windows authentication can be tricky. Here's how to make it easy.
2014-10-06
7,194 reads
Dynamically set DTSDestination column name from variable
I need to be able to set the DTSDestination column dynamically using a variable for the column name. Here is the code I am using: strColName = cstr(DTSSource("ColName")) DTSDestination(strColName ) = DTSSource("QVal") I am getting the error "Invalid procedure call or argument: 'DTSDestination'". I'm sure that I am just missing something.Thanks!
2004-10-04
3 reads
RE: DB Design Question
1) Is 3rd normal form a good goal to shoot for when designing a DB? Or, is that probably "too normalized" in practice because it's probably "asking for trouble" later on when trying to optimize?I would personnaly say the goal is all normal forms that can be reached. I have studied and studied these to […]
2004-05-14
RE: Report Preview
The performance is NOT slow. It is in the design/layout mode when laying out the report that it is slow(insert more detail lines or whatever). I can mess around with the report changing properties like hiding a group header and all of sudden I will get the whole report in the Print Preview. However, I […]
2004-04-26
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers