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.
COMPUTE CLEARANCE/D12.2=BUDGETC-ACTUALC; AS 'Clearance'
It has to say
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.
WF 8.1.05 Windows