Focal Point
[SOLVED] Adding a -SET Statement in InfoAssist+

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

August 27, 2018, 09:47 AM
Doug
[SOLVED] Adding a -SET Statement in InfoAssist+
OK now, where do I add a -SET Statement in InfoAssist+? Not a prompt or a filter, just, something like: -SET &ThisYear = &DATEYY ;

This message has been edited. Last edited by: Doug,




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
August 27, 2018, 11:36 AM
FP Mod Chuck
Doug

You have to use a global variable in the server profile (edasprof.prf)


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
August 27, 2018, 12:03 PM
Tomsweb
By a global variable you mean a &&variable rather than a &variable ?

I have created single &variable in a report object. I mean coding
-SET &VARIABLE = 'WHATEVER'; in the preprocessing other component and the &VARIABLE in the Report component.

Please clarify.

Thank you


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
August 27, 2018, 12:44 PM
CoolGuy
Tom,

There is no current way to do -SETs in IA+ (as of 8202M). I think due to it creating a security concern. Like Chuck was saying, the only way to facilitate custom variable expressions in this way to IA+ users is to create global variables in a fex somewhere and point to them within your edasprof.prf file on the Reporting Server. We've got a huge set of them for dates that we've made available to our IA+ users. It works really well. Global == &&, local == &.


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
August 27, 2018, 01:10 PM
Tomsweb
Thanks for the helpful information. I have known since 1988 about the distinction between &local and &&global.


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
August 27, 2018, 01:33 PM
CoolGuy
Tom,

No sweat. Sounded like you were asking, so I clarified for ya is all. Apologies.


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
August 27, 2018, 01:36 PM
Doug
Thanks Guys,

I'll do a work-around... I'll set the variables that I need in my initialization and/or branching fex.
August 28, 2018, 10:01 AM
Frans
Or use a Reporting Object if you only want reports or diagrams, do your -SET there in the preprocessing part and create a report or diagram on the reporting object. This way you can also use local variables.

This won't work for visualizations.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
August 28, 2018, 04:47 PM
Doug
Thanks All Smiler