BPC (ver 7.5 ) MS Excels option missing Add-Ins error “Object variable or With block variable not set “

 
Above error  "Object variable or With block variable not set"

Solution:

1. Open MS Excel sheet and check for Planning and Consolidation tab on the top ribbon. It would not be available.
2. Open excel sheet optionsclick on Add-ins select disabled Add-ins click Go.
3. Select Planning and Consolidation add-in and enable it.
4. Check if the planning and consolidation is active in the active Add-in list.

5. Close excel sheet and open it again. Now we can see the planning and consolidation tab in top ribbon.

Run time error in SAP BPC MS (ver 7.5)

1. Run time error in SAP BPC MS (ver 7.5) (Microsoft )”An error Occurred while communicating with the web server “
   1. Possible reasons
      1. Divide by zero
      2. Incorrect  syntax
      3. Run time dump in SAP system which is connected to the SAP BPC MS.

Sol: Go to ST22 check for dump in SAP system connected to BPC MS

Go inside the dump go to - ABAP control block

Search for on right block symbol
You will get index, the name of the method, parameters, source code and line of error

How to Debug BPC Data packages BPC 7.5

1. Go the data package code
2. Create  break points
3. Go to the transaction UJKT
4. Enter app set ID ,Application ID and user ID  as shown below

5.Enter the scripts  and validate according to the package selected

As shown below:

6 Now execute .

7 Now this will go to the data package for Debugging

How to stop performance statistics tables UJ0_STAT_HDR & UJ0_STAT_DTL entries for BPC 7.5 MS

When the statistics parameter is ON in BPC ADMIN client.
The UJ0_STAT_HDR (Header) & UJ0_STAT_DTL(Details)  tables grows very large and may affect performance .

We have two options to control the size of these tables :

1. Delete the table entries using program: UJ0_STATISTICS_DELETE using APP SET ID.
2. We  can stop the performance  statics  generation Go to the BPC ADMIN and OFF the  BPC parameter BPC_STATISTIC.We can do this for APPSET or Specific Applications.
   1. Steps to switch OFF the parameter for one APPLICATION.

• Open BPC ADMIN Client
• Go the web client .Double click the “Interface for the web”. This will be opened in a web browser (preferably IE).

         

• Choose Application
• Go to the Administration shown below 

• Go to the set application parameter shown below

• Turn OFF the BPC_STATISTIC parameter

Dynamically change the selection screen of a report based on the radio buttons.

Dynamically change the selection screen of a report based on the radio buttons.

Here we have requirement to enable a selection screen (second selection screen) based on radio button RAD2 in first selection screen .Also restricting input to single values using  FM SELECT_OPTIONS_RESTRICT.

Run MS Office and other utilities program using ABAP program

The purpose of this report is to run MS office and other utility *.EXE file using ABAP program or report.

We will see how to find the *.EXE program in WINDOWS XP.

*.CSV file format mismatch due to control panel setting for MS EXCEL

A few days back, I was struggling to solve a display mismatch problem in *.CSV file.

We had a tab delimited *.CSV file for upload.

While opening *.CSV file at my end its was showing correct format.

But when the same file was opened by one of my client (From Germany) it was displaying in different format. Its was very strange for me :-(