Date Filtering in Excel from your Analysis Services Dimension
I recently had to set up another Date Dimension and went through the process of setting up all the properties in the date dimension so that when it is used in Excel, the end users would then be able to use the Date Filters built into Excel. The Excel Date Filters are very handy when creating Excel documents. As an…
OLE DB error: OLE DB or ODBC error: Invalid column name ‘xxx’.; 42S2
Yesterday I thought it would be a quick addition to add a new column to my Fact table. Then add the dimension to Analysis Services. And finally add the dimension to the cube. but I ran into the error below and after struggling for quite a while I found the issue. NOTE: This is possibly one of many solutions. I…
SSIS 2012 – Inserting data into a SQL Server Table from an MDX Query
The reason for this blog post, is I recently had a query if it was possible to get data returned from an MDX Query and then insert the data into a SQL Server Table. And the reason for putting it into SSIS was that we could schedule the job to run on a schedule. I have inserted pictures from my…
Date Filtering in Excel from your Analysis Services Tabular Model
Following on from how to format the date in Analysis Services UDM Model, today I found myself trying to do the same thing for the tabular model. Where Excel was viewing the dates as a label and not as an actual Date. And after some looking around it is fairly simple to implement so that you can then use the…
SharePoint – Power View URL Actions
This is related to using the PowerView reports in SQL Server 2012 using Analysis Services in the tabular mode. I thought it would be helpful to post some of the URL Actions that you can use with your PowerView Reports which will add more functionality to your reports and to your end users. So this will then enable you to…
SSIS – Process Cube with XMLA and Analysis Services DDL
Generating XMLA Script and data from Cube What I was looking to do, was to use XMLA and the Analysis Services Execute DDL Task in SSIS to dynamically process just a required partition that has already been created in SQL Server Analysis Services (SSAS). I found that doing this in SSIS was a quick and easy way in order to…
SSIS – Fastest or quickest way to move data on a local system – Interesting testing
Over the weekend I was doing some work to in order to catch up a lot of data that I had loaded incorrectly. Whilst I was moving this data around I for some reason or other opened up the Resource Monitor on my 2012 Server. What I saw below confused me quite a lot. Which I will explain after the…