BI Summit

All About implementing Business Intelligence solutions

Thursday, August 1, 2019

Stock Prices ETL :TD Ameritrade API

›
I was think few days back about how BI could work with Stock Prediction. To do it first I needed regular stock price data from the interne...
Monday, November 5, 2018

SSIS Error: Execute Sql Task failed

›
Error: SQL SPLoadxxx:Error: Executing the query "EXEC SPLoadxxx ?" failed with the following error: "Multiple-step OLE DB o...
Wednesday, September 7, 2016

SSAS 2012 Tabular Cube:Attributes(columns) not visible

›
Issue is where your table in the model diagram has both Measure and Attributes and you add a new column to the table in model diagram. Aft...
Friday, May 27, 2016

Convert Views to Tables

›
Recently I wanted to create a StoredProcedure to convert all the views which read millions of records to tables in a database. The Reason...
Monday, February 29, 2016

SSAS: Dimension Parent Child Hierarchy recursive

›
In the last post I showed you know to build a Parent-Child Hierarchy. This time we implement the same Parent-Child Hierarchy in a different...
Thursday, February 11, 2016

SSAS Dimension: Parent Child Hierarchy

›
Building a Parent Child Hierarchy looks complicated but is easy if all the rules are followed correctly. I will here list down few steps wh...
Thursday, June 11, 2015

Bug: SQL 2014 SP1 truncates decimal values.

›
Hi , I noticed a wierd thing with SQL Server ServicePack 1 SQLServer2014SP1-KB3058865-x64-ENU.exe from https://www.microsoft.com/en-us/do...
›
Home
View web version

About Me

Nishil Jain
View my complete profile
Powered by Blogger.