As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
Connect to myibi
posted July 21, 2008 10:05 AM
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
-* File act_prd_daily_summary_vw.fex
-* DIMENSIONS FILE ACT_PRD_DAILY_SUMMARY_VW
Report_Hierarchy: DELIVERY_CHANNEL, ORGANIZATION_TYPE, ACCOUNT_TYPE, AGREEMENT_TYPE, COMMON_NAME, ACCOUNT_NUM, ITEM_CLASS_DERIVED;
any ideas why?
This message has been edited. Last edited by: MTO-Solutions-Engineering, August 19, 2008 09:14 AM 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)
Posts: | Location: 23 Toronto, Ontario, Canada | Registered: January 09, 2007
posted July 21, 2008 10:27 AM
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
Posts: | Location: 2723 Ann Arbor, MI | Registered: April 05, 2006
posted July 28, 2008 08:43 AM
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.
This message has been edited. Last edited by: MTO-Solutions-Engineering, July 28, 2008 09:00 AM 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)
Posts: | Location: 23 Toronto, Ontario, Canada | Registered: January 09, 2007 Read-Only Topic
Copyright © 1996-2020 Information Builders