cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with EPM Add-in

Former Member
0 Kudos

Hello All,

We are using SAP BPC MS 10 and we are getting problem with Excel retrieve.

For dynamic reports, it is not possible de retrieve data, even if we can see these data in the database.

When we refresh the report, it shows a blank page.

It worked good before, and didn't change any configuration.

Someone have an idea about this strange behavior?

Thank you in advance for your help.

Kind Regards,

Wafa

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello All,


As we opened an SAP case, we have now the response.


It seems to be a bug related to some MS component used in BPC.

There is some hidden character for 3 fact tables. The correction will be integrated in the SP14.

The workaround is to run the following SQL query (the problem occurs withe some entities):


UPDATE [dbo].[TblFactCONSOLIDATION]  SET ACCOUNT = RTRIM(ACCOUNT)

where ENTITY =N'XXXX'


The problem is now resolved, we are waiting for the SP14 to have a definitive solution.


Thanks for all!


Kind Regards,

Wafa






Answers (2)

Answers (2)

former_member208963
Participant
0 Kudos

As easy as seems, do you try to restart BPC server?, sometimes sendgovernor and other servcices acts weird.. and need a refresh...

Former Member
0 Kudos

Hi Mariano,

We restarted BPC services and then the BPC Server and the problem still occurs.

Kind Regards,

Wafa

Former Member
0 Kudos

Hello Wafa.

This Problem may Occur in different situations.

1. Refresh Report: Check If your report is properly getting refreshed or not. This may happen when report gets logged off with or without your knowledge. Check if your report is properly connected.

2. Connections. This situation occurs when the report has been opened/modified in different connections. some times if the report is opened and modified using lan connection, and some times the report is being modified with wireless connection. The report/template stores these connections and need to be checked in situations of data invisibility

                         This situation also occurs if one try to open with different models and environments. check the connection of report which was used earlier and connection used now. you can see this connection in the "Data Connection" in EPM Pane.

                         we can correct these connections in

  Report Actions -> Manage Connections -> select the required connection (if you have mulitiple connections) -> Report connections -> Select the required connection.

3.Epm Copy Range: Check if your report/Template if  any epm copy range formula being used. If used there might be some formula being acting upon specific cell which would hide the original data from data base from showing up. this can can be for some cells where the data is not shown and in other areas the data is shown as it is.

4. Check the context of the report/template if the data is being saved in correct context in data base or not. Check if you are viewing the report/template in correct context which matches with data base.

Although The above situations have been solved in Netweaver version. Please Check if these are the similar cases with Microsoft version also. I have not worked on Microsoft version before.

Regards

Praveen

Former Member
0 Kudos

Hi Praveen,

I will check those points and get back to you with the result.

Thank you very much for your help.

Kind Regards,

Wafa