Monday, November 21, 2011

Top 10 BI Predictions for 2012

Top 10 BI predictions for 2010 by Forrester Research.

Top 10 BI Predictions for 2012

Tuesday, November 15, 2011

Introduction to Hbase Video from Cloudera!

I listened to this video link posted in Cloudera - Big Data distribution company. It gives fairly vague idea about Hbase.

Since HDFS has the drawback of sequential access, Hbase is built to overcome this drawback and to make use of random access along with HDFS. Hbase is a combination of HDFS and Random access technology together.

Please find the link for the video here:
Introduction to HBase - Todd Lipcon (Cloudera)

Monday, November 7, 2011

Source system Analysis - SAP

This is the first data warehouse, I am working which has SAP as its source system. I don't have much knowledge on SAP process flow, tables etc. Have seen couple of screens where users query for some details. Last week for one of the data issues, I was searching online for the "Billing Document" flow. Initially assumed that all Billing documents are Invoices, later the below comments in the SAP discussion clarified the point.

1) What is the difference between billing document and invoice?

Billing document is a general term that includes - sales invoice, debit memo, credit memo and cancellation documents. In layman's term, invoice usually refers to the sales invoice, or what you send to your customer as your company's bill or charges. So, all billing documents are not invoices..But all invoices are billing documents . Usually, Invoice is document indicating to delivery goods and Billing is a receipt of payment

Tables are VBRK & VBRP. For flow, go to transaction VF03, enter document number and hit 'Display Document Flow' button on toolbar VBRK and VBRP holds billing/invoice details.


Also I found that SHKZG field is called return/cancellation flag. When this flag is set, It means that invoiced item is returned to its manufacturer. There are 2 ways of Invoice cancellation, 1) by issuing a Invoice cancellation billing document 2) by setting this return flag set along with Credit memo Billing document.

If I found more, Will post in my next blog.

Happy Learning!

Sunday, November 6, 2011

The Data Quality Chronicle – Big Data … Little Data Quality

The Data Quality Chronicle – Big Data … Little Data Quality

Fooled by "Ungroup by" Clause

Recently I have become active again in spending time online to improve my career and of course to write more blog posts and comments about the things I read online.

I came across this blog and was reading with interest till the end with full concentration. :D

Strated thinking during the halfway of reading this post, how this new "ungroup by" clause is possible. How the query mentioned by the author breaks the results by Year, since it was not specified.

At the end of the post, I came to know that it is April fool post.

"Like for Ungroup by"