I am trying to run a report using webfocus 7.6.7 against essbase 7.1.3. I either get an error or no html output with zero records...is there something "special" that I need to do? I think I'm trying a very basic report.

thanks

This message has been edited. Last edited by: Kerry,

Could you post your FOCUS code here and the message you see in your no html output screen?

Reporting against ANY multi-dimensional source,
ESSBASE, MS OLAP or SAP BW has special rules.
First question has to be what is the error?
Second question is have you looked up the error.

The code is

TABLE FILE TNTEST6
PRINT NETBILLING
BY SCENARIO
BY CHANNELS
BY PRODUCT
BY CUSTOMER
BY TIM2
WHERE TIM2 EQ 'Oct';
WHERE SCENARIO EQ 'CY';
WHERE CHANNELS EQ 'CRS';
WHERE RECORDLIMIT EQ 100
HEADING
""
FOOTING
""
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
END

the error is....

No HTML Output!

--------------------------------------------------------------------------------


0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0


I've read in the documentation on setting up a report but haven't found anything to help.

thanks

No HTML Output is not an ERROR, it's simply telling you that there is no report to display.

quote:

0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0

Remove the filters and see what it does.

sorry...you are correct...that is not an error...i guess the "error" to me was getting no output. I removed the filters and the report runs and runs...all i get is "waiting for response...". I easily run a report against this in the essbase excel addin.

thanks

cfish

You need READLIMIT EQ 100 to restrict retrieval from the essbase server. Currently wf is waiting for essbase to return a huge result set and then returning the first 100 records from that.

Stick with wf and you will get to see how it works - there is nothing inherently wrong with it.