2012 ASUG Business Objects Conference - Developer War

Created by Maria Wei

SAP BW BOBJ Expert

Good morning everyone. 

I want to share with you all our experience at 2012 ASUG Business Objects Conference. As many of you know we were selected to participate in the 2012 ASUG Developer war. Many thanks to the ATCG solutions team (Karthik Addula, Victor Ayers, Hong Wu, Tengran Liu, and Maria Wei) who work through the night to complete the presentation. This presentation was presented in front of thousands of conference attendees, sap customers, SAP SMEs/Mentors and Internal SAP executives. Please find our presentation (in raw format) on the bottom of this blog. 

Day 1:

11:30 am 

we were given the data. we immediately encountered our first challenge. We were told before the contest by Optimal Solution (sponsor) will provide OBDC connection to us. Due to some logistic issue, we had to work with the spreadsheet and load it into SQL server. But none of us are sql administrator. With the help of Tammy from ASUG, Mico Yuk and the Decision First Team, we were able to complete the SQL server Connection. our second challenge was tool selection, without a CMS, we decided to choose xcelsius (XML connection) and Visual Intelligence. 

10:00 pm

Design of our solution was complete. Our solution was composed of Xcelsius (KPI that identified the issue) and Visual Intelligence that provided real time data to further drill down and diagnose the issue. 

Day 2:

After many many bags of chips and many many bottles of beer we continued to work through the night 

4:00 am

Dashboard Functionality Development was complete

10:00 am

Dashboard Complete

12:00 pm

Visual Intelligence Dashboard Complete. Presentation Complete

Third Challenge: after meeting with the metor team, we were our presentation was too formal and we had to make it fun. We had 2 hours to come up with a new presentation.

2:00 pm

Laptop turned in. Dragon suit borrowed (Many thanks to Work Beast). Presentation done

5:30 pm

Dress rehearsal

6:30 pm

SHOW TIME

ATCG Solutions Team Presentation at SAP ASUG Conference Orlando 2012

This was recorded on my Iphone (thank you Abishek Parvathala from Oakley)

After thoughts

Unfortunately we did not win, Congrats to Optimal Solutions. But we will work harder and take your throne next year . Looking forward to this event next year. I really appreciate the hard work of all of my team mates. So i am going to embarrass them a little. Below is a picture of all of us on the night of presentation. Note: no one really slept the night before but we look fabulous.

From left to right: Karthik Addula, Victor Ayers, Tengran Liu, Maria Wei, Hong Wu

How to create Financial Reports by States for Tax Purposes

Created by Maria Wei

SAP BW BOBJ Expert

We are using logic in the tax jurisdiction code to USTX77705XXXXX. We are going to use Left(Right(Tax Jurisdiction,2),4) to get TX.

Step 1:

Enhance extractor with functional module 0FI_GL_40 enhancement

1. Go to RSA6.

2. Select your data Source 0FI_GL_40.

3. Select the "Enhance Extraction structure"

4. Give the Append Structure name. In our example we used ZZFIGL40APPEND. Note: you will need new append structure for each extractor.

5. Append the fields to extract structure (ZZ*). In our example we use ZZTXJCD. Note: use se11 to check the component type of the fields you are trying to append.

6. Goto CMOD

7. Give the project name-->Display. In our example we used ZBWEX

 8. Click Create à Component à enter RSAP0001

 9. Double Click on EXIT_SAPLARSAP_001 since we are enhancing transaction data extractor

EXIT_SAPLRSAP_001 -> Transaction Data

EXIT_SAPLRSAP_002 -> masterdata attributes

EXIT_SAPLRSAP_003 -> Master data Texts

EXIT_SAPLRSAP_004 -> Masterdata Hirarchies.

10. Double click on ZXRSAU01

11. You can write the code under the exist.

***Enhance 0FI_GL_40 Extract with Functional Location

DATA:  l_tabix like sy-tabix,

      L_S_FAGL_S_SREP_LINE_ITEMS like FAGL_S_SREP_LINE_ITEMS.

CASE I_DATASOURCE.

WHEN '0FI_GL_40'.

    LOOP AT C_T_DATA INTO L_S_FAGL_S_SREP_LINE_ITEMS.

   l_tabix = sy-tabix.

   SELECT SINGLE TXJCD From Bseg into L_S_FAGL_S_SREP_LINE_ITEMS-ZZTXJCD

     WHERE BELNR = L_S_FAGL_S_SREP_LINE_ITEMS-BELNR

           AND

           BUZEI = L_S_FAGL_S_SREP_LINE_ITEMS-BUZEI.

     MODIFY c_t_data From L_S_FAGL_S_SREP_LINE_ITEMS INDEX l_tabix.

     Endloop.

ENDCASE.

12. Save and activate the Code

13. go to Rsa3 select 0FI_GL_40--> unselect the ZZTXJCD under Hide column (by defalult new added fields goes under HIDE)

14. Save the datasource à generate Data Source

15. Check the data in RSA3.

Step 2: 

Enhance BW 0FIGL_D40

1. Replicate the datasource into BI side.

2. Go to BW, Create Xregion  and add to 0FIGL_D40. In the transformation edit the rule. Create a substring formula. Note you can not use Left(right) logic because the value is text. In this case we have to use substring forumla. 

3. Now you should be able to write  a bex report on GL based on States.

Edited: Maria Wei

SAP BW Report Financial (EHP3) 0FIGL_C30 only load Financial Statement Type (GL_FSTYPE) =1

Issue:
In BI content under report financial (EHP3) Finance:  0FIGL_C30 where data is only load with Financial Statement Type (GL_FSTYPE) =1. When you look at the DTP and transformation there is no filter nor formula. 


Solution:
You need to specify selection of 0GL_FSTYPE(Financial Stmnt Type) as 3 in the filter of DTP which loads data from 0FIGL_V30 to 0FIGL_C30. The system assumes default value of 1 for 0GL_FSTYPE if no selections are given in filter of DTP. Please make sure to use full load DTP.

- Edited by Maria Wei

Still working on it,...

Hello All, I am still working on the posts, will update this space soon