dev

With UD Connect you can now integrate the data for the source object into SAP BW. You can either extract the data, load it into SAP BW and physically store it there, or, as long as the prerequisites for this are fulfilled, you can read the data directly in the source using a SAP RemoteCube. Example SQL Server 2008…

But there is one potential error when extracting data from SQL Server database…

The error message when executing an  Info Package to load/transfer data from SQL Server 2008 x64 to SAP BW NW7.

S:RSSDK:400 Cannot convert field DECIMALS of type NUM to int

to solve the problem you have to check the SQl Server “Unicode” Setting

Steps:

1.) Go to SAP BW > RSA1 > Source System > UD Connect > ….

Right Clik on the UD connection name and Click on  Connection Param.

3.)  Go to MDMP & Unicode Tab and Run Unicode Test you must have access to TCODE SM59

4.) If your target system is Unicode, then you have to tick Unicode for Communication Type for Target System.

5.) Save and Close the Source System Dialog

6. )re Run the Execution of Info package.

Good Luck

SAP Net Weaver 7 (SAP NW7) has a capability to store query bookmark on web application (Bex Web Analyzer). If we execute query from Query Designer, than it will launch a query in web application. The other way running a query is from Excel Ad In (Query Analyzer).

I like to run query from web application  compare to Excel Ad In, it has great presentation look and it can run anywhere with in browser.

The Problem is the “Save As” menu to “My Favorites“,”Bex Portfolio“,”My Portfolio” on web app query is visible and easily use , but there’s no “delete” button on web application query for “Bex Portfolio” item .  User can easily save layout but cannot delete them. Whoott……..!!

To delete a Bex Web Analyzer Bookmark - Bex Portfolio , follow this steps:

1.) Go To:

http://<servername>:<port>/irj/servlet/prt/portal/prtroot/com.sap.km.cm.navigation

or

http://<servername>:<port>/irj/go/km/navigation/

note:don’t forget to add ’slash’ (/) at the end of the url

2.) Fill User Name and Password , then click  Documents > Public Documents (see picture below) Or Entry Points> Public Documents

3.) Click the icon at the right corner of the Bex Web Application Item (see picture below)

and it is DONE! for “Bex Portfolio” item

4.) To delete another  Bex Web Analyzer Bookmark - My Favorites or Personal Folder :

Go To: http://<servername>:<port>/irj/go/km/navigation/

and explore the navigation menu. I can’t describe in detail because i’m not testing it on non admin user, yet.

Reference:

1. SDN Forum – Bex Web Favorites

First, if there is an error on the activation of a DataSource Object (DSO) or the Transfer Rule Object.

Run this transaction code:

RSRV: Analysis and Repair of BW Objects

Second, If an SAP BW InfoObject get an enhancement then it should be repaired too. Apply these steps:

Run this transaction code:

RSA1  :

Goto Top Menu and follow these steps:

Tools - Apply Hierarchy / Attribute Changes