Try to use calculations in Analysis get 'formula is invalid' error

[paddyw]

Hi,

I am trying to use the Analysis for OLAP version. I built a query directly based on cube, and select two column of key figures and click 'add' function of the 'Calculations', but it will throw the error message as 'Formula is invalid'. Then I tried other functions, it looks all the Calculation fail with the same error, does anyone has some suggestion about this? Thanks a lot.

Screenshot attached

[Former Member · Accepted solution]

What version of the database are you running?  We had the same error with any formula running on a SQL 2005 server.  We upgrade to 2008 R2 and the error went away.  I'm not sure this is applicable but I wanted to mention this as possible solution.

[Former Member]

Was there any solution to this - we are having the same problem!!

We are using Oracle Essbase 11

[gleo_SRAM]

Hi Paddy,

Does the calculation work on any other measures or just those two specifically?

With regards

Gill

[paddyw]

Hi Leo,

The issue happens to all the report.

Regards,

Paddy

[Henry_Banks]

Time to turn on Logging as advised by Phil above!

[paddyw]

Does anyone has any suggestion? Thanks.

[Former Member]

Hi Paddy,

Do you have access to the MDAS or APS logs? You may find more helpful information in the logs. As far as I can see, everything looks fine in your screenshots.

Regards,

Philip

[I_MCA]

Hello Paddy

In addition to telling us the version/SP for BI4, can you also confirm your BW version and patch level?

From a workflow perspective what you are doing appears correct plus the data appears compatible.

Instead of using the "quick calculation" option, have you tried building the calculation using the "Calculation" task panel? In that task panel choose the "Summation" function first from the list of functions. Then double click on "operand1" followed by "Add Member" and choose the first key figure. Repeat for operand2 and choose the second key figure.

Then click on the validate button. It likely may not work.... but can you submit a screenshot now of the calculation panel at this point?

Thanks

[paddyw]

Hi Ian,

We are on BO 4.0 SP5 patch4 and BW 7.31, SP6. I have also tried using 'Calcuation in the task panel, it also said the formula is invalid.

It really makes me frustrated...

Screenshot attached

[I_MCA]

Sorry Paddy

I've been meaning to get back to you. I've wanted to do my own tests but other priorities have got in the way.

Can you please try and do a calculation using key figures that do *not* contain a $ character? We escape all non-alphanumeric characters but might have missed this.

Let me know the result please.

Regards

[TammyPowlas]

Hi- would you please let us know which version/SP you are using?