Page 2 of 5

BW – Delta Queue Update Method

Following my last blog post on Unclogging Queue Entries.

We know that we need to trigger delta update by creating V3 job to push the data into Delta Queue.
For note, these process are running on ECC-Side.
There are 3 different update method for this delta:
1. Direct Delta
• In this update method, data is directly transferred to Delta Queue and application tables at same time,
with every document posting
• Here, 1 document = 1 LUW (Logistic Unit of Work)
• Suitable for a small datasource type

2. Queue Delta
• In this update method, the records are first sent to ‘Extraction Queue’ using V1 update
Note: This ‘Extraction Queue’ entries recorded in serialize way. That’s why the queue delta are suitable for serialization document number.
• From ‘Extraction Queue’, we need to send the records to ‘Delta Queue’ using collection
run
• In this update method, we can collect up to 10,000 documents in one LUW

3. Unserialized V3 Update
• Here, the extracted data of an application is written to update tables using V3 update
• We need to send the data from Update Tables (SM13) to Delta Queue (RSA7) using Collection Run
• In this, serialization of documents is not guaranteed

Image above showing the difference of three update methods.
> Direct Delta VS Queue & V3 Unserialize
Data from transaction updated directly into Delta Queue using V1.
Meanwhile, Queue & V3 Unserialize have temporary table( Extraction & Update Table).
> Queue VS V3 Unserialize
Extraction suitable for serialization & V3 Unserialize are not.
Queue Delta check with LBWQ.
V3 Unserialize check with SM13.

source: http://scn.sap.com/docs/DOC-33012

Debug Story – BAdI not implemented for appset …

It was started couple days ago. Two of my colleagues reporting issue regarding write back data on a BPC Environment Model. We’ve never have this problem before. The write back engine run smoothly on every model in every situation.

So I start to debug several spots to understand what’s going on.

The error caused by Exception cx_badi_not_implemented which generated by method,
Find BAdI implementation,
GET BADI lo_badi
FILTERS
appset_id = d_appset_id
application_id = d_appl_id
module_id = ds_wb_param-work_status-module_id.

So, my first attempt I try to by pass this procedure by change flag ds_wb_param-execute_badi into abap_false.
But, on the following step there is more validation for this exception.

My second attempt would be checking the the object of lo_badi which reference into BAdI badi_ujr_write_back. There are two implementations using this enhancement spot. I’m guessing since this implementation we need to input appset_id, application_id, & module_id so we get the right implementation.
But the write back we used comes from standard process, it doesn’t make any sense if the implementation doing something wrong with standard process. So I crossed this possibility and start to think another option.

Then I tried to debug deeper.
The next guess would be my third attempt.
I found the same exception showed on method CL_UJV_VALIDATION_MGR -> CHECK_VALIDATION.
Try to dig deeper, I found the table UJV_MODULES which for BPC Validations – Module On/Off Table.
And there is only one record for that model. *AHA

So i googled little bit then found out that TCode UJ_VALIDATION which generate the record for tables UJV_MODULES.

Then I ask permission one of my senior if he still using the validation or not. Then Turning off validation for that model. It works like a charm.
Problem Solved

for further information on how UJ_VALIDATION works or how to use it check:
UJ_VALIDATION

BW – Collection Run for Entries Delta Update

So we found this problem regarding Delta Update on BW server.
After BW running on production phase for a couple days we saw the update are not running as they should. They’re some extraction that remain on yellow light. It seems like there are no data coming through anymore from ECC to BW side.

It turned out there are a lot of entries Queue-ing on ECC side. Using transaction SMQ1, we could see some entries are waiting in line to be extracted.

It’s like a ‘Clogged Pipes’.
So how do we overcome the clogged pipes? we need to take out the plug.
But, where is the plug in terms of data flow from ECC to BW?

What we don’t know is, there is a difference process to update Full/Initial Datasource and Delta Datasource. Full/Initial data extracted are store in Setup-Table.
If initialization is successfully extracted into BW PSA, delta generated on ECC. From then on, data collection stored in Delta Queue (RSA7) before extracted by Infopackage.

And now for the best part, Unclogging.
It turned out we need to do the V3 job, releasing the entries data delta into queue delta before delta info package is triggered from BW-side.
Go to LBWE.
By clicking the job control and scheduling the job. Data Entries that stuck on SMQ1 are flowing into Delta Queue RSA7.

After setting up the background job process( I think I need to create a blog post on how I do this) for every time delta infopackage requested, the ‘Clogged Pipes’ never seen anymore.

Multi Tenancy in Enterprise Resource Planning Trends

What is Multi Tenancy?

According to Gartner

Multitenancy is a reference to the mode of operation of software where multiple independent instances of one or multiple applications operate in a shared environment.

Single-Tenant vs Multi-Tenant?

> Single Tenant Model – Each customer gets a separate instance of the software which runs on a logically isolated hardware environment.
> Multi-Tenant Model – All the customers are served from the same common software instance and hardware infrastructure.

What’s the difference from today environment?

Quoting from Bill Harmer, Gooddata

In the old days, hosted systems were very common. IBM, CGI, and others allocated servers and provisioned software to run systems for customers–meaning one installation of the binary for each customer. Systems were accessed over dedicated connections, and the “server” industry boomed. Now, the public infrastructure (the Internet) is used to access those same systems. The software, in a lot of cases, is legacy on premise software that is being run in the vendor’s data centers and typically uses a VMWare, Xen or other system-level virtualization to manage the deployments. These 20-year-old hosted-style deployments are not only in use today, but are often slapped with the ubiquitous “cloud” moniker.

What does it do with ERP?

with the popularity of salesforce.com, cornerstone on demand, and other multi-tenants. Now we can see the use of multi-tenant everywhere. It’s not all about the trend, it’s the new era of software development where the old definition of ‘Write once and use it everywhere’ change into ‘Write once and use it for everyone’.
Everyone means multiple customer using the same instance of a software, this model would be advantage for the both sides. For Developer we only need to patch the software once for all customer. For customer we don’t need to setup the infrastructure,which means it would save hell of the money for IT implementation.

And for SAP?

You think that SAP are not prepare for this trend? i’ll give you a hint, they are well prepared.
for the last years SAP already acquiring some cloud multi-tenant across the world:
http://www.ariba.com/ -> SD & FI
http://www.successfactors.com/ -> HCM
http://www.workday.com/ -> HR & FI
https://www.concur.com/ -> Travel Expense
http://www.fieldglass.com/ -> Vendor Management Systems (SD)
https://www.hybris.com/en/ -> SD

Those company acquired in the range of 2011-2014.

More over, John Appleby, stated that SAP HANA will support a ‘True Cloud Multi-Tenancy’.

“The Public Cloud version will use database multi-tenancy, which is quasi-multitenant from a cloud perspective. ABAP Code-lines, configuration tables etc. will not be shared yet between customers on one SAP HANA container database. This is expected to come in time, as SAP HANA supports true cloud multi-tenancy.”

With a lot of technology acquired across module by SAP, I think they are pretty serious to join the era of multi-tenant. Although i don’t know how they’re going to integrate all of their ‘New Acquire Product’ into SAP in the future. Either they have a independent module for travel expense, maybe? or they took all of the engine inside and put it into SAP-ABAP-HANA style?
It’s a lot of possibilities what they could do with those technology.
But, according to the history of their acquisition, I strongly believe that they’re going to do the right thing.
For instance, the acquisition of company name Outlooksoft in 2007, which turned out to be SAP BPC nowadays, integrated so well with SAP ecosystem. Now with SAP BPC 10, they have a new look SAPUI5’s style, the program looks more ‘SAPed’. They even create specific BAdI to accommodate the BPC engine so they could integrate logic script – ABAP – package (excel EPM) so well.
You get the idea, right?


So, How strategic is S/4HANA to SAP?

To put this into context, Hasso Plattner, SAP Chairman of the Executive Board, was quoted as saying:

“If this doesn’t work, we’re dead. Dead in the water.”

Paradoks Kepercayaan Diri

Di tulisan saya sebelumnya mengenai orang-orang yang saya temui di acara TechInAsia di akhir tulisan saya bertemu dengan ibu-ibu dari Venture Capital yang mengomentari sebuah startup yang belum matang.
‘No Apps, No Income, Only market share’, begitulah komentar ketusnya mengenai startup tersebut.
Kemudian kemarin saya menemukan tulisan di Medium yang bercerita tentang kegagalan startupnya.

5 Reasons Why My IoT Startup Failed

Mungkin itu kali ya kalo startup kita masih setengah setengah atau belum siap, terus dengan pedenya kita menghampiri investor seolah-olah bilang bahwa produknya bakalan menghasilkan keuntungan sepanjang masa.
Saya mengutip sebuah teori dari Dunning-Kruger, yang saya temukan di artikel medium tersebut.

The Dunning–Kruger effect is a cognitive bias wherein unskilled individuals suffer from illusory superiority, mistakenly assessing their ability to be much higher than is accurate.”

jika divisualisasikan,

Dunning-Kruger Effect

Mungkin Teori tersebut serupa dengan quote dari Bertrand Russel dari yang pernah saya baca di Logicomix,

The Paradox of Confidence

“One of the painful things about our time is that those who feel certainty are stupid, and those with any imagination and understanding are filled with doubt and indecision.” Bertrand Russell

Awesome Strangers – Tech In Asia Jakarta 2015 at Balai Kartini

Lama ga tulis blog karena kesibukan Go-Live akhirnya muncul niat kembali buat nulis.
Kali ini saya mau buat diary (bukan diare), tentang my lately awesome day. Berkumpul dengan kalangan-kalangan sejenis saya yang passionate di bidang teknologi & bisnis.

Dua hari ini 11-12 November 2015 Tech In Asia (techinasia.com) mengadakan acara yang berlokasi di Balai Kartini, Jakarta. Tech In Asia yang sudah terkenal dengan berbagai liputannya tentang start-up di wilayah asia ini bisa dibilang sukses dalam mengumpulkan Investor, Developer, Founder, Media, & Calon User dalam satu tempat. Acara dibagi dalam dua hari, dengan menghadirkan berbagai macam pembicara yang dibagi dalam 5 stage (Main Stage, Developer Stage, Marketing Stage, Fin-Tech Stage, & Mobile Stage ). Dan semua pembicara menyampaikan keynote-nya dalam bahasa inggris. Hal ini bukan tanpa alasan, karena jika dilihat dari peserta yang datang 30% diantaranya merupakan orang asing.

Karena satu dan lain hal, saya hanya bisa datang untuk 1 hari pertama saja. Alasan cukup kuat, kerja. hhe..
Namun saya sudah cukup puas dengan berbagai hal yang saya lihat. Dan mendapat beberapa pengalaman & networking baru.
Untuk mengingat-ingat kejadian yang seru kemarin saya akan berbagi pengalaman di acara tersebut.

Begitu datang dan registrasi saya kagum dengan jumlah peserta yang datang. Di acara-acara teknologi yang biasa saya datangi kebanyakan yang datang adalah para geek developer atau mahasiswa.

Dalam satu hari tersebut saya bertemu beberapa orang yang menarik. Dengan siapa saja saya berbicara:

#1 The Guy from Criteo
Di main stage untuk acara pertama saya persebelahan dengan seorang developer dari perusahaan bernama Criteo. Nama yang asing bagi saya. Menurut penjelasanya, Criteo adalah perusahaan asal Perancis yang bergerak dibidang marketing ads. Perusahaan tersebut membuat suatu algoritma untuk merekomendasikan kepada user produk yang disarankan berdasarkan aktivitas user tersebut. Keren. Akhirnya saya bertemu dengan seorang data scientist untuk pertama kalinya.

#2 Si Bule Cewe Wangi
Kemudian sebelah saya berganti dengan seorang cewe bule. Tingginya ga jauh beda sama saya sih. Dengan pakaian kerja yang casual, sleveless, dan yang paling kerasa adalah baunya yang wangi banget. Berasa di surga. Kita cuma sesekali berinteraksi, terutama saat mengeluhkan audio yang kurang jelas dalam beberapa sesi. Saya rasa bulenya adalah seorang jurnalis. Karena dengan seksama dia mencatatkan hal hal didalam notepadnya.

#3 Tim Pantauharga
Setelah memutuskan untuk keluar dari stage saya mencoba mengelilingi stand2 startup yang ada disana. Yang menarik perhatian saya pertama kali adalah pantauharga.id
Startup yang memenangi Hackathon Merdeka 2015. Aplikasi yang dibuat untuk memantau harga barang-barang komoditas di tiap daerah. Diharapkanya semua pengguna dapat menginput dan update harga untuk tiap-tiap daerah sehingga bisa dipantau persebaran harga untuk daerah satu dengan yang lainya. Aplikasi ini menarik saya karena Papa saya merupakan pedagang komoditas di pasar tradisional. Dan beberapa tahun yang lalu saya kenalkan internet untuk pertama kalinya, beliau langsung mencoba untuk men-google hal yang serupa diaplikasikan oleh pantauharga.

#4 @dondyb, bos Infinys Indonesia, Premium Cloud Company
Oke saya suka bapak ini saat menyampaikan presentasinya di dev-stage. Gayanya yang eksentrik dan penuh semangat dalam menantang para developer yang ada untuk membuat aplikasi berbasis cloud ataupun environment semacam Amazon Web Service adalah cara marketing plus motivasi yang bagus. Dengan muka Indonesia banget beliau luwes dalam menyampaikan keynote-nya dengan selipan selipan bahasa inggris yang berkelas. Yang paling saya ingat dari keynote beliau adalah,

#5 Marketing Guy from Teamchat
I must admit, that this guy is the most interesting guy I found in entire expo. Teamchat adalah startup asal India yang menyediakan API untuk ecommerce dan Smart Robot. Kita ngobrol cukup lama bercerita tentang bagaimana kerennya teknologi yang dia punya. Bagaimana dunia ecommerce dimasa depan dengan hadirnya robot sebagai asisten. Bagaimana robot bisa menemani kita saat chatting dan menyajikan data yang kita perlukan. Sekilas saya ceritakan dia tentang hubot yang saya kenal terlebih dahulu. Setelah menjelaskan bahwa saya adalah seorang Konsultan SAP, dia langsung kaget. Usut punya usut ternyata tim mereka sedang mengembangkan interfacing chatbot mereka dengan SAP. Wow!. I never thought that would be possible. But if it’s true that would be awesome. Semacam itu kalimat response saya. Kemudian dia meminta kontak saya dan kita bertukar informasi kontak. Dan berjanji akan menghubungkan saya dengan their tech-guy, since I have a little experience in chatbot & SAP. And he’s not lying 🙂
Oh and btw, he said that the founder of this company also the founder of elance.

#6 Sales Woman from Amazon
Di booth ini saya berbincang-bincang yang teknikal. Tak dikira jika seorang sales dapat mengetahui pengetahuan hal yang teknikal untuk produknya. Karena saya berencana untuk menggunakan AWS untuk webapps saya namun saya masih belum bisa menentukan produk AWS mana yang akan dipakai. Nora, nama sales Amazon yang berasal dari Malaysia berjanji akan mengirimkan brosur produk-produknya. Sebelumnya juga Nora menjelaskan produk-produk mana yang sebaiknya digunakan sesuai dengan kebutuhan saya. Akhirnya pertanyaan yang saya simpan selama ini terjawab sudah oleh orang Amazon-nya langsung.

#7 Ibu-ibu Asisten Venture Capital
Di akhir acara hari tersebut saya sudah merencanakan untuk melihat keynote dari Bapak Menteri Pedagangan, Martin Lembong. Saya ingin melihat apa pandangan beliau mengenai industri teknologi berupa startup, apakah merupakan bisnis yang didukung oleh pemerintah atau tidak. Namun fokusnya bukan di Bapak Martin Lembong. Namun ibu-ibu sebelah saya. Jadi ceritanya ada 2 orang asing (mungkin jepang) yang saya yakini adalah executive di salah satu venture capital, dan seorang ibu-ibu, orang kepercayaan bapak-bapak venture capital tersebut. Rupa bapak-bapak ini serupa dengan Guy Kawasaki gitu lah. Makanya saya bilang orang Jepang.
Ibu-ibu ini ketus, atos, dan berbicanya sarkasm banget.
Seperti contohnya karena ada keterlambatan dari Bapak Menteri, TechInAsia mengadakan show sambil menunggu datangnya Pak Menteri dengan memanggil founder startup-startup untuk melakukan public pitching, berharap ada Venture Capitalist yang tertarik dengan produk mereka. Setiap startup yang diundang maju dan menjelaskan produknya tentang apa, ibu-ibu selalu mengomentari dengan gaya khasnya yang ketus dan kemudian diamini oleh bosnya. Seolah-olah ibu-ibu ini orang kepercayaanya banget.
Salah satunya, beliau berkomentar saat ada startup yang memiliki produk ride-sharing. Beliau langsung berkomentar ‘Well, I won’t get in the car with bunch of stranger. That’s scary’.
Lalu disaat startup tersebut bilang bahwa aplikasinya belum siap masih sekadar komunitas beliau bilang,
‘No apps, No income, only market share, why do I want to invest in your startup’.

For The Recap of TIAJKT15 go to: https://www.techinasia.com/tiajkt2015/

Happy and Unhappy Family

Recently, I read a book, Zero to One, written by Peter Thiel. He was the founder & ex-CEO of Paypal.
The book is about how to do a great business, notes on startups and mainly talks about how to build better future.

But, right now I am not talking about the book overall. I really like about one of the chapter he was quoting from one of the book written by Leo Tolstoy, Anna Karenina

If translate it into bahasa would be like this,

“Setiap keluarga yang bahagia itu serupa,
setiap keluarga yang tidak bahagia, tidak bahagia dengan caranya masing-masing.”

I love the idea how he put it on this book by saying that that quote on family is different in business world. He’s saying that,

“Business is the opposite. All happy companies are different: Each one earns a monopoly by solving a unique problem. All failed companies are the same: They failed to escape competition.”

I recommend this book if you’re looking for business book that easy to read on. It’s not like reading Intelligent Investor or Moneyball that confusing with many stranger word as non-economic person.

Dillinger.io – My First Love Online Markdown Editor

I’ve already member of github for so long. But never have I wrote any good repository on my github account. Mostly because me, as a developer didn’t have a time to working on a good documentation.
I know that was wrong but now I must get rid of that laziness behavior, by creating my first ‘good’ repository.
Which is I must write a good documentation (readme.md file) in order to be understand well enough by the other.
Since I am not that good in grammatical this is a serious challenge for me.

But then the other problem comes up. I am not aware that writing on Github using Markdown.
As stated by github,

Markdown allows you to write using an easy-to-read, easy-to-write plain text format, which then converts to valid HTML for viewing on GitHub

Instead of read till the end of paragraph from Markdown-Basic , I try to search the webapps to accomplished my needs.
After a few tools that I’ve found that I am falling for Dillinger.io Online Markdown Editor.

11-29-2015 1-33-10 PM

The simple User Interface with two column layout, the left-side as the editor and the right-side as the preview screen makes me comfortable writing some readme.md file.
The method I am using by following the template that have been written by default on the left-screen then I just editing some stuff with my words.
I don’t need to remember how to Indent, how to create list, how to create a link, or how to create some console command looks. It’s already been there.
All you need is your word to change the default text and removing some text that you don’t need.

Nothing Good Gets Away

This is the letter from John Steinback, the writer of The Grapes of Wrath, East of Eden, and Of Mice and Men—all classics, to his son who recently feel in love.

John Steinback’s Nothing Good Gets Away

New York
November 10, 1958

Dear Thom:

We had your letter this morning. I will answer it from my point of view and of course Elaine will from hers.

First—if you are in love—that’s a good thing—that’s about the best thing that can happen to anyone. Don’t let anyone make it small or light to you.

Second—There are several kinds of love. One is a selfish, mean, grasping, egotistical thing which uses love for self-importance. This is the ugly and crippling kind. The other is an outpouring of everything good in you—of kindness and consideration and respect—not only the social respect of manners but the greater respect which is recognition of another person as unique and valuable. The first kind can make you sick and small and weak but the second can release in you strength, and courage and goodness and even wisdom you didn’t know you had.

You say this is not puppy love. If you feel so deeply—of course it isn’t puppy love.

But I don’t think you were asking me what you feel. You know better than anyone. What you wanted me to help you with is what to do about it—and that I can tell you.

Glory in it for one thing and be very glad and grateful for it.

The object of love is the best and most beautiful. Try to live up to it.

If you love someone—there is no possible harm in saying so—only you must remember that some people are very shy and sometimes the saying must take that shyness into consideration.

Girls have a way of knowing or feeling what you feel, but they usually like to hear it also.

It sometimes happens that what you feel is not returned for one reason or another—but that does not make your feeling less valuable and good.

Lastly, I know your feeling because I have it and I’m glad you have it.

We will be glad to meet Susan. She will be very welcome. But Elaine will make all such arrangements because that is her province and she will be very glad to. She knows about love too and maybe she can give you more help than I can.

And don’t worry about losing. If it is right, it happens—The main thing is not to hurry. Nothing good gets away.

Love,

Fa

DL is Deprecated, Please Use Fiddle

I encounter this problem after installing ruby 2.1.0 on my windows computer.
Even it’s just a warning message but it’s kinda annoying.

I’ve found the solution by comment the line on the warning message’s line.
If you are using ruby 2.1.0 and windows the file dl.rb located on \Ruby2.1.0\lib\ruby\2.1.0


require 'dl.so'

begin
  require 'fiddle' unless Object.const_defined?(:Fiddle)
rescue LoadError
end

# this warning is annoying
# # warn "DL is deprecated, please use Fiddle"

module DL
  # Returns true if DL is using Fiddle, the libffi wrapper.
  def self.fiddle?
    Object.const_defined?(:Fiddle)
  end
end


according to http://stackoverflow.com/a/15601984/1446163

The message you received is common when you have ruby 2.0.0p0 (2013-02-24) on top of Windows.

The message “DL is deprecated, please use Fiddle” is not an error; it’s only a warning.

The source is the Deprecation notice for DL introduced some time ago in dl.rb ( see revisions/37910 ).

On Windows the lib/ruby/site_ruby/2.0.0/readline.rb file still requires dl.rb so the warning message comes out when you require ‘irb’ ( because irb requires ‘readline’ ) or when anything else wants to require ‘readline’.

You can open readline.rb with your favorite text editor and look up the code ( near line 4369 ):

if RUBY_VERSION < '1.9.1' require 'Win32API' else require 'dl' class Win32API DLL = {} We can always hope for an improvement to work out this deprecation in future releases of Ruby.

Voila! the message is gone.

© 2018 Rijdz

Theme by Anders NorenUp ↑