How to display the OLAP Control Panel on a iframe


Technique

Product: WebFOCUS Designer
Release: 8206
Primary OS: Windows
Solution Date:

Problem

How to display the OLAP Control Panel on a iframe.

Solution

Here are the steps to display the OLAP Control Panel on an iframe.



    
	
  1. Add -OLAP ON to the top of your focexec code (car_olap.fex):
    2. 




For example:



-OLAP ON

ENGINE INT CACHE SET ON

SET PAGE-NUM=NOLEAD

SET SQUEEZE=ON

-DEFAULTH &WF_HTMLENCODE=ON;

SET HTMLENCODE=&WF_HTMLENCODE



SET HTMLCSS=ON

-DEFAULTH &WF_EMPTYREPORT=ON;

SET EMPTYREPORT=&WF_EMPTYREPORT



-DEFAULTH &WF_ARVERSION=1;

SET ARVERSION=&WF_ARVERSION



-DEFAULTH &WF_SUMMARY='Summary';

-DEFAULTH &WF_TITLE='WebFOCUS Report';

TABLE FILE ibisamp/car

SUM CAR.BODY.DEALER_COST

CAR.BODY.RETAIL_COST

BY CAR.ORIGIN.COUNTRY

BY CAR.COMP.CAR

BY CAR.CARREC.MODEL

ON TABLE PCHOLD FORMAT HTML

ON TABLE NOTOTAL

ON TABLE SET CACHELINES 100

ON TABLE SET OLAPPANE CONTROL

ON TABLE SET STYLE *

INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,{2}lt;br /> TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, ORIENTATION=LANDSCAPE, {2}lt;br /> ENDSTYLE

END



-RUN



    
	
  1. Save your focexec in your folder.
    2. 
	
  2. Select your folder, select Other and then Text Editor in Action bar.
    3. 
	
  3. Select the Web tab and click HTML(htm).
    4. 
	
  4. Add the following code:
    5. 




<!DOCTYPE html>

<html>

<body>

<h2>HTML Iframes</h2>

<p>You can use the height and width attributes to specify the size of the iframe:</p>

<iframe src="http://localhost:8080/ibi_apps/run/ibfs//WFC/Repository/Public/car_olap.fex" height="1000" width="100%"></iframe>

</body>

</html>



    
	
  1. Click the Run button.
    2. 
	
  2. Scroll down the scrollbar to the end and click the OLAP button to display the OLAP Control Panel.
    3.