Hi all,
Just thought I'd post some things I learned about OLAP that I'm quite certain is undocumented... although, I haven't run a search on Focal Point to see if it is already posted. Oh well, double post is okay, yes?

1.) If you get this error:
(FOC036) NO DATA FOUND FOR THE FOCUS FILE NAMED:
It is quite possible that you have " (double-quotes) in the data. Solution: STRIP that character out.

2.) If you get this error:

 An HTTP 500 error has been returned when attempting to communicate with the WebFOCUS web components. 

That error shows up when you already have the OLAP report up then you filter/pivot/etc the report.

When you get this error, check your COMPUTE statements or your DEFINES. It may be caused by:

A. A variable name that webfocus doesn't like. I had this happen when I named my variable CLEAR or PERCENT

B. No spaces between the variable and the minus sign when subtracting. e.g.

SUM
COMPUTE CLEARANCE/D12.2=BUDGETC-ACTUALC; AS 'Clearance'

It has to say

SUM
COMPUTE CLEARANCE/D12.2=BUDGETC - ACTUALC; AS 'Clearance'

It seems like none of the other math operators have this problem.

Well, hope this helps somebody out there.

Hi Anatess,

Many thanks for sharing the tips with all!!

Cheers,

Kerry