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
3,123 reads
Introduction Period-over-period is an analysis technique in business that measures some value in the present and compares it to the same measurement in a comparable period of time in the past. The goal is to adjust the slice of the past you are viewing, so the same amount of time has passed in the two […]
2020-01-27
52,032 reads
Learn how to resolve a duplicate value error when processing dimensions in SSAS.
2020-01-20
9,818 reads
Learn how you can modify an SSIS package to dynamically process SSAS cubes.
2020-01-13
5,538 reads
Learn how to configure SQL Server and Windows to allow others to connect to an instance remotely.
2020-01-06
50,082 reads
Problem Developing OLAP cubes have always been fascinating to me. Right after completing the development of a data warehouse, my next line of action often becomes setting up Analysis Services for the warehouse. Although, there are multiple client tools readily available in the market to perform some analysis on this SSAS Server, sometimes it is […]
2019-12-31
5,116 reads
Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]
2019-11-04
8,862 reads
2019-10-28
5,764 reads
Overview of ETL Architecture In a data warehouse, one of the main parts of the entire system is the ETL process. ETL is the system that reads data from the source system, transforms the data according to the business logic, and finally loads it into the warehouse. While fetching data from the sources can seem […]
2019-10-21
12,914 reads
The Problem Recently, while working with one of my clients, I came across a script in which I had to introduce a scalar User-Defined Function in the SELECT statement. The SELECT used to return around 750K records. However, after introducing the UDF, the row count significantly increased to 826K. There were no other changes made […]
2019-10-14
4,295 reads
By Steve Jones
I’ve heard about Dapr a few times from developer friends, but hadn’t really understood...
By James Serra
Microsoft has a ton of data platform-related products, but there are certain areas where...
Choosing the right typeface for your presentation (or for that matter anything you create...
Hi Looking for a SQL script I can run as an agent job that...
Comments posted to this topic are about the item Import Multiple Packages to SSIS...
Ask SSC