Assignment of Source System ID in SAP BW

If a characteristic ZCUST_ID is coming from multiple source systems and is also defined as Master Data bearing InfoObject in SAP BW and is compounded with Source System ID (0SOURSYSTEM), then it becomes necessary to do Source System Assignment in SAP BW to let the system know which system the value for this characteristic ZCUST_ID is coming from.


This is true for even the delivered InfoObjects and even if that field is mapped to another field in several SAP source systems.

All you have to do is follow these steps to create the Source Systems ID’s and do the assignment.

1)      In the Administrator Workbench, choose Tools  à Assignment Source System to Source System ID.

Fig 01 – Assignment of Source System ID

2)      Choose Create.

Fig 02 – Create Source System ID

3)    Enter the logical system name and a description, and confirm you entries (in this example the name 

       would be BIDCL100 or DEVCL100).

4)   In the Source System ID column enter the ID name that you also entered in BW1 for the corresponding source system. (In this example it would be ID 01 or ID 02).

5)    Save your entries.

Fig 03 – Display Source System IDs

I hope this will be helpful to others.

*******
******
*****
****
***
**
*

Comprehensive List of BI Tools - 2 of 10 Parts

I'm continuing the series with some other BI Tools that I'm aare of in this Part. The Part 1 list is given here

Part 2 list continues here:

Teleview Features: -  Touted as Self Service Enterprise BI -  Comes integrated with a database, data capture and data processing component and an interactive     front end with multiple visualizations -  Data Integration and Data Processing -  Modular Architecture -  Role based security -  Dashboard Creator -  Works with Linux and Windows (64 bit for server and 32/64 bit client) Version: Website: http://abibasystems.com/teleview.htm Developed by: ABIBA Systems Private Limited

Datawatch Features: -  Is referred to as Monarch Report Manager on Demand (Monarch RMOD) -  Monarch RMOD can be integrated with CRM applications, Web Portals -  Can be installed on Windows Server 2008 R2, IBM AIX, Solaris, Linux – Red Hat 5.2 -  Application Servers: JBOSS, IBM WebSphere, Apache Tomcat -  Java-based desktop deployment Version: Website: http://www.datawatch.com/Monarch/Report_Management.php Developed by: Datawatch Corporations

Will continue with the list in other posts ....

*********
********
*******
******
****
***
**
*

Dates in WebI always in the different format 1/1/70

The date always displayed as 1/1/70 in WebI that are built on top of BEx queries.

SAP BusinessObjects 4.0 (Product: 14.0.0) Patch level 2.6

SAP BW: SAP EHP 1 for SAP NetWeaver 7.0 (Patch 08)

The BEx : BI AddOn 7.x on (based on 7.10); SP 10, Patch 1

Java Pug-in: Java version 6 Update 29 (build 1.6.0_29b11)

I’m using the WebI from BI Launch Pad which uses Java plug-in to work. I’m not using SAP Web Intelligence Rich Client (this one needs local client installation).

For e.g.:

Fig 01 – Wrong WebI dates

While it suppose to display

Fig 02 – Corrected WebI dates

The solution for this is given in this SAP Note. You will need an OSS ID to access the SAP service marketplace to see this note.


1648578 - date values displayed wrong

The issue is fixed in Patch 2.7 and has adapted as ADAPT01585086.

I hope this will help others. Please leave comments or suggest a coorection.

********
******
****
***
**
*

Some Options are disabled / not funtional in WebI 4.0 on top of SAP BW BEx Query

 SAP BusinessObjects introduced a new functionality where now WebI documents can be created on top of BEx query using BICS.


SAP BusinessObjects 4.0 (Product: 14.0.0) Patch level 10.0

SAP BW: SAP EHP 1 for SAP NetWeaver 7.0 (Patch 08)

The BEx : BI AddOn 7.x on (based on 7.10); SP 10, Patch 1

Java Pug-in: Java version 6 Update 29 (build 1.6.0_29b11)

I’m using the WebI from BI Launch Pad which uses Java plug-in to work. I’m not using SAP Web Intelligence Rich Client (this one needs local client installation).

1) The Scope of Analysis and View Script (previously View SQL) option in the Design mode of the Query
     Panel are not available if you use BEx queries as a source. You will see those disabled.

                    FIG 01 – The Scope of Analysis and View Script options disabled

 
2) In the Filter area in WebI on BEx, the AND operand does not change to OR
 
 

    Fig 02 – Query Filters using AND operand

 
If you try to double-click on this operand AND to try change it to OR, this will not work.
 
3) The search operands underscore (“_”) and percentage (“%”) doesn’t seems to work in WebI on
    top of BEx queries. Only operand “*” works. The obvious reason is the List of Values are not save
    on server.
 
 

 Fig 03 – Search Operand for List of Values

 
 

   Fig 04 – Search in Keys option

 
 
4) The Use Query drill also doesn’t work. Although you can check it in the Document Properties but it
    doesn’t work
 
 

         Fig 05 – Use Query Drill option in Document properties

 
At this time I could only find these options not to work. There could be other’s which I could not yet test.


Please update and let me know if anything here needs to be corrected or needs to be added here.


*******
******
*****
****
***
**
*