Blog

SSAS (SQL Server Analysis Services) – KPI – Comparing Date and Hour for the Previous Week or Multiple Values in your KPI Goal and Trend Expressions

What I wanted to do was to use a KPI in SSAS to compare values going back one week. But I wanted to get the same hour for the previous week. I could not find an example were it had used multiple values in a KPI Goal or Trend expression. All just used one value.   Example: ·         For my…

SSAS (SQL Server Analysis Services) Tabular – Error when Processing – OLE DB or ODBC error: Server: The operation was cancelled by the user ..

The above error is caused when processing an SSAS Tabular database.   NOTE:This only applies to when using MDX and an SSAS OLAP Cube to get your data into SSAS Tabular. NOTE 2:The reason that I use MDX and the SSAS OLAP Cube to get data in is for 2 reasons. ·         The first is that as we know it…

SSRS–Creating reports using Custom MDX or DAX to query SQL Server Analysis Services (SSAS) Cube both OLAP and Tabular (Not using the Wizard)

By default in SSRS you can query an SSAS Cube, but this is by using the drag and drop functionality. The issue with this is that it has quite a few limitations. One of the biggest limitations that I found is that you cannot use your own Custom MDX to create your data set. NOTE: You can use the same…

SSIS – Stopping an Error from Propagating to its Parent (Enabling an SSIS Package to continue when an error happens)

Due to our environment and packages we create, we have to enable the packages to continue even if it fails for some reason (Cannot connect to a Server for example) so that the rest of the data will be captured. In the past we configured the MaximumError count to be 100, but this is not ideal, because if another component…

WordPress Theme built by Shufflehound. Copyright @FourMoo 2021 | ABN 80 382 360 382