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,

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.

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,