if you are struggling with pulling data from SAP, this list of essential SAP tables could be helpful DD02L SAP Tables DD03L Table Fields DD04L Data elements TADIR Directory of Repository Objects VARID Variant for Reports TFDIR Function Modules T100 Messages TSE05 ABAP Editor insert commands USR03 User address data USR02 Logon data USR01 User … Continue reading Important SAP tables
SQL Server 2012 and Hadoop
Seems to get a lot of attention from Microsoft. Richard Chin who is leading the SQL Server businesses for Microsoft had a long talk about it at the launch event. With a host of great features coming out in this release (MDS, DQS, PowerView just to name a few) of SQL Server, it seems a little … Continue reading SQL Server 2012 and Hadoop
xVelocity
Microsoft is re-branding its Vertipaq in-memory engine that is currently used in PowerPivot and naming it xVelocity. That's hardly worth a blog entry per se.. Howerver, and this is big, xVelocity now is added to both Analysis Services AND Database engines... Supposedly, this technology incrases preformance of the existing relational queries by 10-100... I will … Continue reading xVelocity
blunderfunding
Gartner's Doug Laney has coined this term to define IT investments that are justified by catastrophic losses of data... I like the term a lot more than I like his post but I feel like I need to give credit to where it's due so please read his thoughts on blunderfunding here...
Breakthrough Insights using Microsoft SQL Server 2012 – Analysis Services
Not sure if anybody is using Microsoft Virtual Academy.. if you are not - you should... What's the compelling event? Well, 7 freshly minted modules have just been posted for our perusal: Developing and Managing a BI Semantic Model Configuring and Securing Complex BI Applications in SharePoint Enriching your BI Semantic Models with Data Analysis … Continue reading Breakthrough Insights using Microsoft SQL Server 2012 – Analysis Services
Microsoft SQL Server 2012 Virtual Labs
Microsoft has posted 16 virtual labs online. The labs cover three major areas: Business Intelligence Mission Critical Operations Database Management Those of us who are trying to jump start Self Service BI in our organizations should checkout the following three: Creating a PowerPivot Model and Report in the Excel Client Defining DAX Calculations with Microsoft … Continue reading Microsoft SQL Server 2012 Virtual Labs
Parent Child in PowerPivot
EDIT: I recorded a detailed video on how to work with Parent Child hierarchies in Power BI: https://businessintelligist.com/?p=2603 Kasper de Jonge posted a great article about building PowerPivot hierarchies against dimension tables that implement parent/child relatioship... Basically, a new PATH() DAX function is used to build a string that contains a path from the leaf … Continue reading Parent Child in PowerPivot
Hierarchical Data
EDIT: I recorded a detailed video on how to work with Parent Child hierarchies in Power BI: https://businessintelligist.com/?p=2603 Hierarchycal Data is an interesting way to implement Parent/Child or tree-like relationships... Microsoft has posted a great tutorial here on how to convert data into the Hierarchycal format.
Hello world!
Welcome to my site... starting out with an obligatory Hello World!... I decided to name this site AQTInsight.. or phonetically, acute insight... or a cute insight... all of these work... and I also came up with a logo
business intelligist 