Monday, March 19, 2018

Versions of Analysis for Office

Here’s a short overview on what versions of an Analysis for Office tool (the new BEx) are available.

AfO SPS                 Release Date (RTC)          Note

2.7                         N/A
2.6 SP 1                  07.12.2017                       2519128
2.5 SP 4                  25.05.2017                       2557401
2.4 SP 5                  29.11.2016                        2483758                          
2.3 SP 3                  26.05.2016                        2401970      
2.2 SP 4                  20.11.2015                        2215168
2.1 SP 3                  29.05.2015                       2204161                
2.0 SP 4                  30.07.2015                       2164371
1.4 SP 17                08.03.2016                        2241062
1.3 SP 09                24.06.2013                       1814288
1.2 SP 10                12.09.2012                       1698671
1.1 SP                     N/A                                   1518359

Useful information:
1518359 - SAP BusinessObjects Analysis Office & BIP Add On Release schedule
Online documentation
2482784 - Best Practices in Analysis for Office
Feedback to improve Analysis for MS Office:

Saturday, March 10, 2018

Favorites in BW’s RSA1 Modeling section

As of version 7.x BW systems contain a useful function of saving particular BW objects that is maintained via RSA1 into Favorites. This enables faster access to the objects as it doesn’t need to be lookup up the area there it belong as there are thousands of the objects. 
As an example one InfoObject that is normally accessible under InfoObject part of Modeling section of RSA1 can be also accessed via Favorites part of the same Modeling section of the RSA1.

I was curious what the table name is where the objects of the Favorites are actually stored. Whole processing of the Favorites is encapsulated in ABAP class CL_RSAWBN_SER_FAVORITES.  For example method that loads the objects is LOAD_DATA.

There are few tables within this functionality. The table where the objects are stored is SPERS_OBJ - Personalization object repository. But this one is just a form of keys to the objects. The method later retrieves the objects types, its description and so on to be able to present them in the RSA1.

Unfortunately there is no straightforward possibility to easy download/upload a list of objects that one inserted into the Favorites. This is contrary to regular SAP GUI favorites that can be downloaded/uploaded between the systems very easily (See post: Download/ Exporting of user’s favorites SAP GUI). However one easy trick is there to at least a get the type and name of objects but with hierarchical representation (like folders). 

To get the list go to t-codes SU01 or SU01D and navigate to Personalization. Find entry called RS_BI_DWB_FAVORITES - Favorites in the BI Data Warehousing Workbench and double click on it.

This will get you a table of all the objects displayed in your Favorites area. The table can be printed to local file and objects can be saved offline by this procedure.

Thursday, March 8, 2018

How to find out a PC in which APD process is used?

Here’s a quick tip on how to find a Process Chain in which an Analysis Process (APD) is used. It may become handy if there is a APD and it needs to be an PC found where the APD is used.

In table RSPCCHAIN enter the APD technical name into VARIANTE field and value ANPR into TYPE field:

Result is that the PC name is returned in field CHAIN_ID: