An Interview with SAP Mentor - All About SAP BI

It is wise to say that "Curiosity is the best teacher". I am always curious and wanted to know and learn BI (Business Intelligence) technologies. I am student of "Master of Business in ERP Systems" and last semester (Feb 2012) I studied SAP Business Intelligence. Since then I developed an interest into SAP BI and day by day my curiosity got bigger and bigger. With that, more and more questions started flowing in my mind (brain) and therefore I wanted to talk to someone who has been working with SAP BI and can answer my queries. I am fortunate that SAP Mentor "Joshua Fletcher" agreed to have a Google Hangout (video conference) with me and happily answered all my queries. This session not only answered my queries but also directed me to right path. To know how, please see following video


Thanks for your time

Angad Singh

http://about.me/angad.singh

Comments

Post a Comment

Popular posts from this blog

SAP HANA Input Parameter - Derived from Table - Use Expression in Filter Value

Image
Recently, I have experienced something while modeling HANA information view that I want to share with everyone.  Case:  Dynamic Filter for projection with current Fiscal Year and Fiscal Period.  Method: There are different parameter types that we can use to do this. I decided to use following "Derived from table" type as shown below:  Challenge: When filtering column then it displays list of values from the same HANA information view and we can select the date. Now, as the requirement is current Fiscal Year and Period so how do we filter the column to dynamically select current date in "Filter Value" section? Solution: Like everyone, I expected it to understand the expression. So I tried following and it worked. I used the expression  currentdate() I was aware that I could use expression in the "Default Value" section (as explained in SAP HANA Developer Guide) but didn't expect it to work in ...
Read more

SLT Replication Issue Due To Timeout Reading Logging Tables

In our company we use SAP LT (Landscape Transformation) replication server to replicate tables from SAP ECC system to SAP HANA in real time. SLT creates trigger for each table that we want to replicate and whenever there is change it stores the changes in the logging table. Later on, these tables are used to update replicated tables in SAP HANA.    This system is really useful when you really need real time replication to SAP HANA. However, it also causes performance issue if proper monitoring is not being performed. Just recently, we faced an issue where we were trying to replicate a large table "VBFA" to SAP HANA in production environment. Every time table replicate status changes to "ERROR" after the initial load. It started to fail when ever SLT tries to read change/delta stored in logging table. This tables replication worked fine in DEV and QA environment.   After troubleshooting and taking help from SAP support we found that in the program g...
Read more

Using Application Function Modeler To Create Forecast (APL) Procedure in SAP HANA

Image
In this blog or document, I have shared my experience gained while creating forecast procedure using following features of SAP HANA: APL (Automated Predictive Library) Forecast Function Application Function Modeler (AFM) I haven't seen any convincing blog which promotes this feature of SAP HANA. Personally, I believe it is really good feature for people with beginner or no SQL scripting skills as AFM is graphical tool. However, the end result is a procedure which can be used later for different purpose. I created this forecast procedure based on the use case provided by  Forefront Analytics . The use case instructed to use APL forecast function. The input dataset was provided by Forefront Analytics . I started my research on APL and my main focus was time series function i.e. " Forecast ". I learnt about APL installation and different APL functions as I progressed. I discovered about AFM when I was watching SAP Technology videos as part of my APL research.  I have...
Read more