Tool Z_DOCU_CREATE_FROM_FILE

I recently came across few SAP BW notes on SMP like:

1683554        SAPI tasks for System Copy Automation   

1703068        System copy with archive

1632574        BW tasks for System Copy Automation

and I found ABAP tool called Z_DOCU_CREATE_FROM_FILE mentioned in these SAP Notes. The tool is used for automating ABAP’s messages creation while deploying Notes. Usage is of the tool very easy. As first you need to create ABAP report Z_DOCU_CREATE_FROM_FILE as itself. The source of the report is attached in those above mentioned Notes. Input parameter is transport request into which those ABAP messages will be stored into. Another input parameter is XML file attached in the Notes. The XML file has actually all the definitions of ABAP messages. 

Based on the XML file the will automatically create ABAP messages that are needed for particular notes.

Notice that to deploy messages further you need only to transport request where you stored he messages. The report Z_DOCU_CREATE_FROM_FILE doesn’t need to be transported to further systems in your landscape.

Notice that this tool is not similar to the open source SAP LINK which is full blown tool for sharing of ABAP codes. The Z_DOCU_CREATE_FROM_FILE tool at least in current stage (April 2013) supports just ABAP messages. See my blog post about SAP LINK.

Of course it is not similar to transaction SNOTE which deploys code correction contained in official SAP Notes.

Technical IOs for w-o DSO

There are many technical infoobjects in SAP BW. Basically they are not supposed to be used by BW developers while modeling the infoproviders. Instead they are needed to make BW functioning from technical perspective. 

Let’s take example of 0DATAPAKID IO. The IO is part of technical key in Write Optimized (w-o) DSO. Among this IO there are two more which combinations created technical key of w-o DSO:

Request GUID field (0REQUEST)

Data Record Number field (0RECORD)

The 0DATAPAKID or so called Data Package field is used to carry data package ID for particular record of data which is stored in the DSO. The package ID is calculated within the load to the DSO.

If you have very fresh BW system installation you may encounter following errors while loading the data:

Error in BW: error getting datapakid cob_pro

Message no. RS_EXCEPTION105

Error while extracting from source C9_MGATP (type DataStore)

Message no. RSBK242

Issue is caused by not active IO related to technical IOs in your system. In this case it was related to 0DATAPAKID. All that needs to be done is to activate the IO from business content.

Importance of BW objects – BI Admin Cockpit (TA RSTCIMP)

Define Importance is activity within installing BI Admin Cockpit. The Cockpit 

sometimes also known as BW Admin Cockpit (SMP component BW-BCT-TCT)

is BW’s functionality for monitoring of BW’s performance. The Cockpit enables 

you to see utilization of your BW systems in terms of data loading and query

runs.  It is based on the technical BI content for runtime and status data 

for BW objects and activities. It was previously in BW 3.x known as 

BW Statistics. 

You can setup the cockpit as per step-by-step guide in SAP Note: 934848 

collective note: (FAQ) BI Administration Cockpit. IMG path to set it up is as 

follows:

SPRO -> SAP NetWeaver -> Business Intelligence -> Settings for BI Content 

-> Business Intelligence -> BI Administration Cockpit.

Within the setup there is optional IMG activity (Define Importance, TA 

RSTCIMP), you can assign importance of BW objects. Importance is then 

useful while you analyze statistics data (for example for filtering or sorting).

You can set up the importance for following objects:

·         Queries

·         MulitProviders

·         InfoSets

·         InfoCubes

·         DataStore objects

·         Process chains

Importance is basically number from range 0-100. By default all the BW

objects are having importance value set to 50. You need to uncheck 

default value checker Inh (Inherit values from related objects) to enable 

yourself to enter different value. Data of importance is stored in table 

RSTCIMPDIR.  

Starting BPC 10 Web Client

I had brief look at BPC 10 NetWeaver version. BPC which stands for SAP BusinessObjects Planning and Consolidation is part of SAP EPM applications. BPC 10 requires an SAP BW 7.3 system as backend. You need to install BPC component CPMBPC into your ABAP stack to enable this functionality. BPC is written using Adobe Flex (an open source framework for building rich Internet applications that get delivered via the Flash Player or to desktops via Adobe AIR.) web front-end. MS Excel interface still remains for inputting and reporting data out of the system.

In order to connect to BPC you need to enable following services on ABAP stack in order to access BPC in TA SICF:

/default_host/sap/EPM_BPC/web - web client itself

/default_host/sap/poa - Base REST service (for Adobe Flex platform)

/default_host/sap/public/bc

/default_host/sap/bw/xml/soap/xmla/

Below see possibilities how to access BPC:

To launch the Planning and Consolidation Web Client or logon page of BPC 10:

Open a web browser and enter URL 

http://server.domain:port/sap/bpc/web/

where is the server name/IP address and port number of the Planning and Consolidation application server.

To launch BPC web reports via a URL link:

For NW version:

https://server.domain:port/sap/bpc/web?re=1#liveReport={report guid};cm={environment name}

For MS version:

https://server.domain:port/sap/bpc/web/#liveReport={report guid};cm={environment name}

How to recognize either your BW has BPC installed? Check following software component in BW backend e.g.:
CPMBPC    800    0007    SAPK-80007INCPMBPC    CPM Business Planning and Consolidation

See further useful info on BPC 10:

FAQ

BPC in nutshell
Learn more about Flex at flex.org