Network Problems

[former_member599120]

Hi Expert,

It's a classical issue, most of we've happened about the network, I was searched and sent this issues in this forum ago.

My question is simply that when I open the BPC Excel through the BPC web, after that the MS.Excel will appears and open the 2 worksheet. But unfornutely, the "Action Pane" window appear is too long ( > 2 minute). If I expand the report, the report will refresh data is too long again (+5minute), I was check the amount of data is not to much.

I am confuse why it's happen ?, I was read the article about how to tuning BPC and try to implement that suggest.

Best Regards,

[Former Member]

Hi, There is one functionality in BPC called 'Optimization' to tone up and enhance the system performance. Whenever new application sets and application are created, it is a best practice to run a full Optimization. In addition, we need to run this optimization, to enhance the system performance. This cleans up data storage which improves the responsiveness of the system. You please attend to this feature of BPC. Trust this helps much! Cheers,

[former_member599120]

Hi Ashok Singh,

I always do optimize for application through SAP BPC Administration. I have the ABAP Script, I founded that from SAP Support. Could you know how to using ABAP Script in SAP BPC ?

The script such as:

DATA:
        lr_calc_list        TYPE REF TO DATA,
        lt_attrname_list    TYPE UJA_T_ATTR_NAME,
        l_dim_name          TYPE uj_dim_name,
        lo_dim_data         TYPE REF TO IF_UJA_DIM_DATA,
        ls_attr             TYPE UJA_S_ATTR,
        lt_attr             TYPE UJA_T_ATTR,
        lf_stored_calc      TYPE UJ_FLG,
 
Delete Block  
        lo_ex_read_mbr_data TYPE REF TO CX_UJA_ADMIN_ERROR.

 
Insert Block  
        lt_hier_list        TYPE UJA_T_HIER_NAME,                     "daw070808
        lo_ex_read_mbr_data TYPE REF TO CX_UJA_ADMIN_ERROR.

Delta 002Context Block  
     CALL METHOD lo_dim_data->READ_MBR_DATA
       EXPORTING
*        I_KEY_DATE     =
         IF_TECH_NAME   = ABAP_FALSE
         IT_ATTR_LIST   = lt_attrname_list
*        IT_HIER_LIST   =

Delete Block  
*        IT_SEL         =


Insert Block  
         IT_HIER_LIST   = lt_hier_list                                "daw070808
*        IT_SEL         =

Print