Angad Singh's Blog

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...

Recently, I was given a task to test reports in BI portal. The testing is critical phase before and after the upgrade for any kind of system. So while running some of the reports I was getting following error: "Error in BW: error creating tmp table" These reports are basically BEx queries which talk to InfoProvider (cube, multi-provider or virtual cube) to get the data. However, I really didn't know what to do. It was my first week of job and I hardly knew anything about their BW system. One of the team member who as a mentor suggested me to look/search for this error in SCN and SAP notes. After a one hour search I found few queries on SCN talking about similar issue and there was information on SAP note to follow. So based on given information I advised the BW person to execute the following report: "SAP_DROP_TMPTABLES" The error might be due to inconsistency in temporary /BI0/0*  tables after the upgrade from BW 7.0 to 7.3. Problem was resolved after r...

With the release of ANZ University Dashboard 2013 Competition information I have started to practice and create something that I wanted to do for long time. I wanted to build an interactive resume which would be more interesting to read. In fact, I found a sample resume created with SAP Business Objects Dashboards at this  location . This sample is really good. I am sure if I learn and practice more SAP Dashboards then I would be able to do similar. At this point, I have created a basic one. You can also get more samples and templates within the software. Please go to File > Templates or Samples. With these samples you can really watch how do each component work. Fig 1 shows that you can use tabs to browse to different sections. I also put social media links by using their favicons. Video 1 shows how selecting or hovering your mouse over each label and button changes displayed text. You can access the dashboard at following link: Resu...

Few weeks ago, I went to Victoria University SAP Students Association meetup. There were numbers of SAP students who were going to finish (and had finished) Masters of Business in ERP systems. After talking to few students I found that they were trying to enter SAP world with knowledge that they earned while studying their Masters only. Apart from that they didn't try anything exciting or new in SAP technologies. In fact, some of them never heard of SCN before or they simply ignored what lecturers mentioned. University is doing it's part by providing us defined curriculum and system for time we are enrolled. We as "students" should invest our own time to learn SAP products and solutions where ever possible. I am also student at Victoria University and studying same course. However, recently I have done a unit  bco6181;  which equipped me and others fellow students with capability and confidence to use different medium to learn SAP technologies. I am going to show y...

This week, I came across an issue where we spent half an hour to add Google search into Internet Explorer as default search engine. It supposed to be very easy but Google search was not listed in IE add-ons anywhere. If you are using Internet Explorer 9 or above then please follow these steps: Go to Tools > Manage Add-ons > Search Providers > Find more search providers Now, you can see that there is no "Google search" listed under search add-ons So, the trick is to edit the URL and go to US add-ons website. Please note that when you go to US website then it defaults to "Pinned Sites" webpage. So please change it to "Add-ons" again. Now, when you click on "search" section then you can see that "Google search" is visible. Click on "Google search" > Add to Internet Explorer > Tick the box to make it default > Add Once you are done then please close everything and restart Internet Expl...

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

#BODevs first meetup was help in Melbourne on 9 th  May, 2013. This meet up was proudly organized by David McAmis . Fortunately, I attended this event and met interesting people with deep interest in SAP Business Objects BI Platform.  So, it all started with meeting and greeting. I was the first one to arrive and David was already there. Later, we had free (at least not for David. So thanks David) pizza and drinks. Once everyone was settled and filled their appetite then real fun began. David started with introduction from everyone. I found that there were people in the room from whom I can learn a lot. David gave us an update on BI 4.1 and explained how the things are changing. He also gave us live demonstration of SAP Visual Intelligence with his own #BODevs attendees data. We shared our experiences and talked about different people in SAP BI world. So I must say overall it was wonderful experience for BI curious person  like me. If you are in Australia and wo...