Focal Point
SOLVED: OLAP Control Panel Button error

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2931083292

July 21, 2008, 10:05 AM
MTO-Solutions-Engineering
SOLVED: OLAP Control Panel Button error
if I click the OLAP button that appears at the bottom left of my report, I get an error.



here is the code that is in the report, at the top

-OLAP ON
-* File act_prd_daily_summary_vw.fex
OLAP DIMENSIONS
-* DIMENSIONS FILE ACT_PRD_DAILY_SUMMARY_VW
Report_Hierarchy: DELIVERY_CHANNEL, ORGANIZATION_TYPE, ACCOUNT_TYPE, AGREEMENT_TYPE, COMMON_NAME, ACCOUNT_NUM, ITEM_CLASS_DERIVED;
END


any ideas why?

thanks

Richard

This message has been edited. Last edited by: MTO-Solutions-Engineering,


MTO
WebFOCUS Dev Studio 5.3.2 (trying to upgrade to 7.x !)
Unix with Win XP front ends
output usually PDF (and some HTML and XLS at times)
July 21, 2008, 10:27 AM
GinnyJakes
I have had that message appear when there were a lot of items to be displayed in a dropdown box. You can click yes, but verify that you are getting all of the entries.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
July 28, 2008, 08:43 AM
MTO-Solutions-Engineering
SOLUTION FOUND !!!

I found a similar report on our system that worked, and compared that one to mine. I then tweaked mine based on minor differences I found at the code level and finally got mine to work!

The answer? Mine had fully qualified fieldnames (tablename.fieldname) and the other report did not (fieldname only). Switched mine to fieldnames only and presto, OLAP button started working.

Richard

This message has been edited. Last edited by: MTO-Solutions-Engineering,


MTO
WebFOCUS Dev Studio 5.3.2 (trying to upgrade to 7.x !)
Unix with Win XP front ends
output usually PDF (and some HTML and XLS at times)