[CLOSED] OLAP- Display selected dimension & values in the report
I have used tabbed style for displaying the dimension. When I select some values for the some the fields in the dimensions, I would like to print the dimension and the selected value in the report so that when we export or print we will have the slection criteria saved along with the report.This message has been edited. Last edited by: Kerry,
Version 764 on iSeries, V5r4, Client running on Tomcat 5.xx
April 24, 2008, 03:08 AM
GamP
To do that, you would have to be able to catch the variables your report is running with. These variables would normally be &-variables, since they are selected on the html-page and then submitted to webfocus as &vars. OLAP however works differntly. OLAP is an applet that controls what will be sent out to the server. The selections made in the olap screen will be translated by the olap applet to 'real' where-statements, and the shipped off to the server. There are no &vars in an olap request. So there is no way I know of to do what you would want to do.
But maybe someone else does have a better idea....
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
May 31, 2008, 06:34 AM
stuey
Got the same situation - ie trying to place the selected values from the OLAP Dimension(s) into the Heading of the report so that the user knows what they have selected when/if they need to print. Anybody got any new ideas ? - I can see via 'view source' that OLAP places an explicit IF condition to the re-run code, surely these must be held in variables somewhere?
Found it - thanks to previous post from Duncan in New York. Select OLAP panel, then selection criteria then you have a check box to see selection criteria in heading or footing. Anybody know if this can be set on by default ?
maybe it would help if I looked at the source before posting ! - OLAP generated a line... OLAP GUI = DYNAMIC_HEADING ON. I inserted this into the fex before TABLE and it worked a treat.
Even with OLAP GUI = DYNAMIC_HEADING ON, it is not displaying the dimension field values selected. Wre are using tabbed olap heading in the fex with "ON TABLE SET OLAPPANE TABBED"
August 10, 2009, 05:42 PM
DivisionByZero
Thanks for the info on this post... it pointed me in the right direction. I found that you can set a default value for an OLAP dimension and turn the heading on:
1. Run the report with the filter values you want to use as defaults. Use the OLAP panel to turn on the headings.
2. View the page source.
3. Copy the generated IF statement(s) and put it/them in the same location as the generated code. Mine looked like this: IF BenElStatusDescription EQ 'Eligible'
4. Copy the section that has your generated header, inlcuding the comments. Paste them into the same location in your procedure. Mine looked like this: /*_FROM_OCP DYNAMIC_HEADING_BEGIN END_OCP_*/ "IF BenElStatusDescription EQ 'Eligible'" /*_FROM_OCP DYNAMIC_HEADING_END END_OCP_*/
5. Turn on the dynamic heading. Mine went right underneath the -OLAP ON command: -OLAP ON OLAP GUI=DYNAMIC_HEADING ON
I ran the report and it pulled up the default filter I wanted and generated the heading. Selecting other values for the BenElStatusDescription filter replaced the default IF statement and report heading.
Hope this helps others out there looking for the same functionality.
Local Development Environment: WF 7.6.10 on Vista Ultimate 64-bit Edition Client Environments: WF 7.1.3, 7.6.4, and 7.6.10 on various Windows Server platforms using servlet implementation over SSL Oracle and MSSQL DBs Output formats: HTML, PDF, Excel 2000, XML