BI-NSIGHT – SQL Server 2016 CTP 3.0 (SSAS, SSRS, SSIS) – Power BI (Chiclet Visual, SparkPost Content Pack, Weekly Service Update, Personal Gateway Update, Tiles in SharePoint)
I expected this week to be a really interesting week with SQL Pass happening. As I was sure to see some really good and interesting updates from Microsoft and it sure is living up to this. There has been a lot of information on Twitter and on other blogs, so here is my take on the developments. SQL Server 2016…
BI-NSIGHT – Power BI (Desktop Update, Service Updates, API Updates, Mobile App Update, Visual Contest Results, Content Pack – Stripe) – Office 2016 (Excel Updates, Power Query Update, Excel Predictions) – SQL Server Analysis Service 2012 Tabular Update – SQL Server Analysis Services 2016 Extended Events
So this week there was once again a whole host of updates with Power BI, as well as finally the official release of Office 2016. It sure is a busy time be in Business Intelligence space, especially in the Microsoft space. So let’s get into it… Power BI – Desktop Update So I woke up this morning to see that…
Power BI (Visual Contest, On the Go, Hyperlinks, Drill Up, Drill Down, tyGraph Content Pack) – SQL Server 2016 – CTP 2.3 (SSAS Tabular with a dose of speed, SQL Server Data Tools (SSDT), SQL Server Reporting Services (SSRS)) – Power BI (Personal Gateway for Power BI Update)
Right once again there is a lot to get into this week, and as with every week there are a whole host of Power BI updates. Power BI – Visual Contest I have to say that this is both a smart and fantastic move by Microsoft. This allows them to get or gain a whole host of new chart types…
BI-NSIGHT – SQL Server 2016 – Power BI Updates – Microsoft Azure Stack
Well I have to admit that it seems that the Microsoft machine has been working flat out to get out new products and updates. If my memory serves me, this is the third week in a row that Microsoft has released new products and updates. I am really enjoying it! But hopefully this will slow down, so that we can…
Sharepoint 2013 – refreshing excel workbook with direct connection to sql server analysis services (SSAS) cube
I have not blogged in a while, due to moving countries and starting a new job. So i do hope that this blog will help someone or let them know how easy it is to use SharePoint 2013 to refresh data in an Excel spreadsheet. What I needed to do, was to use an existing Excel spreadsheet which connected directly…
SQL Server Analysis Services (SSAS) – Updating Project with Partition information
I am sure that this has happened to someone else before. You are making a change to your SSAS cube, within your SSAS cube you have created your initial partitions. But on your production server you have programmatically added additional partitions. Now by mistake or just not thinking you deploy your project, and when it prompts to overwrite your current…
SSIS – Dropping Partitions in SQL Server Analysis Services (SSAS) with XMLA and Analysis Services DDL
Below are the steps that we have integrated into SSAS using SSIS so that we can then drop our old SSAS Partitions using SSIS and XMLA. Example: · We are going to drop our oldest partition from Measure Group called Fact InternetSales 1, which is in our Adventure Works cube. · The actual Cube partition name is called: o …
SSAS (SQL Server Analysis Services) – Getting all partition information from SSAS Database
I had a requirement where I wanted to find out and keep a constant record of exactly how my partitions were set up and created within SQL Server Analysis Services (SSAS). So below is a script that I found somewhere (If I find the source I will put it in hereJ) and how I inserted into a SQL Server Table…
SSIS – Creating new Partitions in SQL Server Analysis Services (SSAS) with XMLA and Analysis Services DDL
What I wanted to do is to create a process in SSIS that did not use code to create new SSAS Partitions using XMLA. NOTE: This is quite a long blog post, but it has all the details from start to finish to get this completed. Example: · We will be using the AdventureWorks2012DW data warehouse and Cube….
SSIS – Using SQL Server Analysis Services (SSAS) MDX query into Variable in Execute SQL Task
What I wanted to do was to get the output from my MDX query, and then use this in SSIS and take the output and put it into an SSIS Variable which could then be used later in your SSIS Package. Example: · We are going to get the Internet Sales Amounts for 2 days. o 01 June 2008…