cancel
Showing results for 
Search instead for 
Did you mean: 

Excel Functions Do Not Work When Data Source is BW

OBEKMEZCI
Explorer
0 Kudos

Hello,

My platform is, BOBJ BI 4.0. Data source is SAP BW. BW is connected to XCelsius with BEx. My problem is, excel functions do not work when data source is BW. For example, Excel cell A1=quantity1 B1= quantity2 C1= excel function "=A1+B1" When data source is Excel, for example A1=5, B1=9 C1 automatically equals to 14. (There is no problem when data source is Excel) But, in BW, for example when BW set values to A1=5, B1=9, the system does not calculate C1. C1 always equals to initial value, the system does not care any excel calculation when data source is BW. Any guess for my problem? Thank you for your effort.

Accepted Solutions (0)

Answers (2)

Answers (2)

hai_murali_here
Advisor
Advisor
0 Kudos

Hi,

As you are using very simple formula,it will work no matter which source you are consuming.As mentioned,try to place a simple component(Eg:spreadsheet),just to check whether you are getting the right calculated value or not.

As you are using BW as source,the Preview option will not show the runtime data,so you need to publish in Portal to check whether the calculation happened or not.

As far as I know only few fromulas are supported in Xcelsius,but these kind of simple formulas are very much supported.

Rgds,

Murali

Former Member
0 Kudos

Hi, the first thing to do is add a spreadsheet component to your model so that you have visibility of the cell values.

From what you're saying, my first guess is that the data isn't updating. Otherwise, the data is updating but the spreadsheet is not calculating (something I haven't seen before).

So, with the spreadsheet component on the canvas and the dashboard re-published to the portal, are you able to confirm that the numbers in A1 and B1 are in fact updating and that cell C1 is failing to carry out its calculation?