IT博客-SAP BI Blog - Collingwood Park

Currency Conversion in BPC

Jonathan Ji — Thu, 17 Sep 2009 07:19:00 GMT

I got a few error messages when trying to run Currency Conversion for Consolidation Application in SAP BPC 7 NW, finally everything works. Now would like to share as below:

1. The Currency Conversion Script Logic:

The standard Script Logic is:
*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %C_CATEGORY_SET%
GROUP = %GROUPS_SET%
TID_RA = %TIME_SET%
RATEENTITY = GLOBAL
OTHER = ENTITY=%ENTITY_SET%//For More than one other scope parameters: OTHER = http://ENTITY=%ENTITY_SET%;INTCO=%INTCO_SET%...
*ENDRUN_PROGRAM

I got an error message of "Member "USD" not exist" when run the data package.

This SDN thread provides a solution: https://forums.sdn.sap.com/message.jspa?messageID=7718017

Add: SELECT(%CURRENCY_SET%,"ID",CURRENCY,"CURRENCY_TYPE='R'")

However it did not work for me, still have the same error.

Then I found another SDN thread: https://forumsa.sdn.sap.com/message.jspa?messageID=8026975

The last post is very important, you SHOULD adapt the standard Script to your own Dimension names. Then the script passed the validation.

2. The P_DataSrc Dimension Properties:

Data Package is still not work, with an error of "Package status : RUNNING".

The third SDN thread is really helpful: https://forums.sdn.sap.com/thread.jspa?threadID=1432486&tstart=1

After I added properties of "DATASRC_TYPE" and "IS_CONVERTED", my package finished successfully.

Jonathan Ji 2009-09-17 15:19 发表评论

BPC Template Version

Jonathan Ji — Fri, 04 Sep 2009 04:22:00 GMT

Could not find the Template Version is stored as a web admin parameter in table UJA_USER_DEF!? And what is the usage of the BPC Process Chain Type, "BPC: Modify Dynamically"?

Jonathan Ji 2009-09-04 12:22 发表评论

Web Interface and Cookie

Jonathan Ji — Thu, 07 Aug 2008 08:41:00 GMT

"No seesion cookie" parameter has been added at the end of URL generated for BPS Web Interface by below SAP notes (BW 3.5 SP21&22).

Note 1023893 - BPS Web: Connection time out / session cookie

Note 1132985 - Follow-on note for Note 1023893 - no sessioncookie

However when testing in SE80 or SICF, or creating iview in EP, cookie might cause issues. Then please manually add parameter "sap-syscmd=nocookie" at the end of URL.

Something else of BSP:

Stateful or Stateless Programming?: http://help.sap.com/saphelp_nw04/helpdata/en/d5/6b113a2604c679e10000000a114084/frameset.htm

Jonathan Ji 2008-08-07 16:41 发表评论

Check SAP Note in German as well

Jonathan Ji — Fri, 18 Apr 2008 03:52:00 GMT

Got an error message of "incorrectly defined FRANGE row in the THX_FROM for inforobject" when executing Key Figure Definition in the BW Query, it was caused by excluding selections in the Query Definition. However could not find a SAP Note in English, and was told by a OSS message that Note in German 1160835 can correct the bug.

I think I could only find it if I had used "BRAIN 415" to search a SAP Note in German. So when could not find a note next time, try in German. But how to understand the content then? By Google...http://translate.google.com/translate_t

-------------------------------------------------------------------
1160835 Note - The definition does not figure. BRAIN 415

Summary

Symptom

Query execution:
It is the message "Incorrect FRANGE line in the THX_FORM to InfoObj " BRAIN 415th

Further terms

Parenthesis. Indicator definition. Explain query.

Cause and conditions

The filter is a stapled feature.
The definition does not figure.

Solution

BW 3.0B / BW 3.10 Content
            Please use the specified corrections management. For the SAP BW releases 3.0B and 3.10 are also up to no longer support packages delivered.

BW 3.50
            Play the Support Package 23 for 3.5 (BW3.50-Patch23 or SAPKW35023) to your BW system. The support package is available if the notice 1146357 with the short text "SAPBWNews BW SP23 NetWeaver'04 stack 23" is released for customers who support this package closer describes.

In urgent cases, the correct leadership of uranium used.
These guidelines can even before the release of the support packages available for advance information available. In this case, however, the short text, the word "pre-release".

Data header


Release Status: Released for Customer
Released on: 15.04.2008 10:40:56
Priority: Correction with medium priority
Category: Program Error
Primary Component: BW BEX-OT-OLAP Analyzing Data

Affected Releases

Software component                        From release                To release And Release        Following
SAP_BW                                          30                                    30B          30B
SAP_BW                                          310                                  310           310
SAP_BW                                          35                                    350           350
SAP_BW_VIRTUAL_COMP                  30350                               30 B         30B

Corrections Instructions

Correction Instructions    Valid     Validity of Up           software Component                type *)
991214                            30B             30B          SAP_BW_VIRTUAL_COMP               C
References                                  Last Correction Change
J19K029019                                15.04.2008 08:44:46

*) C correction, preliminary B, A reworking, m still not certain work Attributes

Attribute                                                               value
Downtown Port UpPort WF             examination necessary UpPort

--------------------------------------------------------------------

Not bad Huh?

Jonathan Ji 2008-04-18 11:52 发表评论

How to Load a Flat File into BW-BPS Using a Web Browser V 3.0 - System Files

Jonathan Ji — Tue, 08 Apr 2008 06:21:00 GMT

In SAP How-to document "How to Load a Flat File into BW-BPS Using a Web Browser V 3.0.PDF", you might notice there are no Chapter 11 and 12 as indicated in Version History. although March 2006 version PDF file can be found, the "Chapter 12.3: Fix for CX_SY_REF_IS_INITIAL exception. Change Event Handler: OnInitialization " part is still missing.

Fortunately the system files are archived in SDN -> Articles (by date), then the new code is:

* event handler for data retrieval

* call initialization here
call method application->initialization(
runtime = runtime
page = page
request = request
response = response
navigation = navigation
version = 300
).

runtime->keep_context = 1.

Jonathan Ji 2008-04-08 14:21 发表评论

5 T-codes

Jonathan Ji — Mon, 31 Dec 2007 23:53:00 GMT

1. RSSMQ: check user authorization

2. SE38: run program "WRITEQUERY". "EXCEL" unselected can have more than 256 columns.

3. SCU3: Evaluate logged table;

4. SM30: maintain table TVARV - Variable selection of Query;

5. RSRV: Analysis and Repaire of BW objects;

Jonathan Ji 2008-01-01 07:53 发表评论

Q&A

Jonathan Ji — Fri, 07 Dec 2007 16:12:00 GMT

Some friends asked me BI technical questions; I think it is a good idea to have a post to host all.

Q: When I create the infosource, there are two methods, one is infosource with flexible update, the other is infosource with direct update. can you explain the difference between them in detail? Thanks.

A: Flexible update is via update rules, master data (Hierarchy is not applicable) with flexible update is considered as a Data target; Direct update updates Master data only, not via update rules. Please find details @ http://help.sap.com/saphelp_nw04/helpdata/en/57/e537373aedaf43e10000009b38f839/frameset.htm

Jonathan Ji 2007-12-08 00:12 发表评论

A Standard ODS

Jonathan Ji — Wed, 21 Nov 2007 09:46:00 GMT

An ODS can be considered as a table, which means it is different from a Cube, it has only 2 dimensions.

Take an standard ODs from Business Content as an instance: 0CCA_O09 - Cost Center Actuals

1. Settings:

    BEx Reporting - select if you want to report on it;
    Unique data records - select if you do not want loada data record into the ODS object if the key combination already exists; usually not to select it;
    Set quality status to 'OK' automatically;
    Activate ODS object data automatically;
    Update data target from ODS object automatically;

2.  Key Fields:

     Controlling Area
     CO Document Number
     Line item of CO Document
     Currency Type
     Key figure Type
     Value type for reporting
     Fiscal year variant

3. Data Fields:

    The rest of Char and Key Figures (Key figures are Cumulative Values)

Jonathan Ji 2007-11-21 17:46 发表评论

Transactional ODS Vs. Standard ODS

Jonathan Ji — Tue, 30 Oct 2007 21:17:00 GMT

Tonny, a new BW pal asked me a question of the difference between the Transactional ODS and the Standard ODS. Frankly I just remember my SAP trainer mentioned it during BW3.5 Delta course, in APD (Analysis Process Designer) part; but never use transactional ODS in my projects, so I have done some research on it. Well, you always can search using key word of “transactional ODS” by Google; you might need SAP SDN and Service Market Place accesses to open some links though.

* I always prefer go to SAP Lib for information first, basically the difference can be summarised as below:

http://help.sap.com/saphelp_sem320bw/helpdata/en/ad/6b023b6069d22ee10000000a11402f/frameset.htm

The Transactional ODS contains only once table that is the Active table where as the standard ODS contains Active Data Table, New Data Table and change log.
So delta update from transactional ODS to other data target is not possible, however you can use a full update. You can not find “Update ODS data in Data target...” in the menu as for a Standard ODS.
When converting a Standard ODS to a transactional one, the update rules and transfer rules will be inactive.
Data can be read faster from a transactional ODS than a Standard ODS (no activation).
A transactional ODS can not be used for a Query directly; however you can create an InfoSet based on it, in BW 3.5. In BW 7, with the new name “DataStore object for direct update”, it can be used as an InfoProvider for BEx Query.

http://help.sap.com/saphelp_nw2004s/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

* Then you might need a transactional ODS when:

in APD

http://help.sap.com/saphelp_nw2004s/helpdata/en/49/7e960481916448b20134d471d36a6b/frameset.htm

A simple case:

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/4419

Or want to read the data written to the ODS instantly (without activation).

Scenario 1:

https://www.sdn.sap.com/irj/sdn/thread?threadID=184702

We had data coming from two sources, one is from R/3 side and the other one is the dynamic data which the user enters. The client wanted to have the result of the user entered data instantly.
So for the user entered data was maintained in the transactional ODS and R/3 data was updated in a standard ODS. We combined the two ODS objects in an Infoset and created the queries.

Scenario 2:

You have data in an InfoProvider, and you have a query that provides you the results you are looking for, but the query does logic that you cannot easily replicate in any update rules.

So, you use an APD (Analysis Process Design) to use a query as a DataSource. Then you update a transaction ODS with that DataSource (a BW query). Then move the data from the transactional ODS to a reportable object (ODS or cube) for last combination in other reporting.

* Actually you also can Set the query as an ODBO, and use RSCRM_BAPI to create Query Extract (to table), or use MDX to realize.

Scenario 3:

During planning, it is often necessary to maintain a comment (a short text up to 60 characters long) for each data record. This article explains (with sample ABAP code) how to maintain text fields like comments directly in the planning layout using then interface with Transaction ODS.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/60938938-de6f-2910-2080-fc80d38ebfec

* Available APIs when using transactional ODS objects:

http://help.sap.com/saphelp_sem320bw/helpdata/en/c7/dc833b2ab3ae0ee10000000a11402f/content.htm

* You might also be interested in the new member of DSO family in BI 7, “write-optimized DataStore Objects”, then you can find the details in SAP Lib via:

http://help.sap.com/saphelp_nw2004s/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

Jonathan Ji 2007-10-31 05:17 发表评论

Synchronize the hierarchy between BW and SEM-BCS

Jonathan Ji — Mon, 06 Aug 2007 13:45:00 GMT

To synchronize the hierarchy between BW and SEM-BCS use program UGMDSY20, so BW hierarchies become available for SEM-BCS.

Or, if you load the hierarchy through flex-upload in SEM-BCS, then hierarchy becomes available in both SEM-BCS and BW.

However, in practice SEM-BCS projects utilize BW implementation in exist, and UGMDSY20 is for that.

* Quoted from a thread in IT ToolsBox, thanks to Metin Colak.

* You also can find a How-to guide of "How To Upload Hierarchy and Master Data of FS Items in SAP SEM-BCS 4.0 by Using Flexible Upload Method" in SAP SDN, contributed by Eugene Khusainov.

Jonathan Ji 2007-08-06 21:45 发表评论