business views w/ quick query -- not poss?

June 19, 2009, 03:34 PM

Is it true that BV's can't be used with QuickQuery b/c of the need for the focus setting
SET FOCTRANSFORM = ON
which means BV can only be used in REporting Objects?
Thoughts?

July 13, 2009, 02:00 PM

Dimitris Poulos

Hi Sussana, BV's can be used w/ all reporting tools and there is a requirement for the SET FOCTRANSFORM command to be ON.
This can be set in the procedure or in the server global profile or at a user profile.
For tools and user types that don't have access to the language or the SET tool, this command needs to be set at a server profile.
Starting w/ 77, the server will have this set to ON by default.

July 13, 2009, 02:12 PM

susannah

didn't we have the conversation already, somewhere else? i've got a deja vu feeling...
...
i'm not comforatable turning foctransform on in my edasprof b/c i don't understand what its doing and what impact it will have on the rest of my site and rest of my colleagues' work...
...
i'm happy w/ so many alternatives... cluster joions with tm4550 and/or reporting objects

July 13, 2009, 03:06 PM

Dimitris Poulos

Hi, yes you are correct. We covered this in the "Quick Query is so cool..." discussion as well.
Adding this command to a profile will not impact any of your applications even if you are not using BV's.
FOCTRANSFORM is used to translate fields and segment names from a BV to the corresponding original Master File during the processing of the request.

July 17, 2009, 09:33 AM

Brian Suter

FOCTRANSFORM works by parsing the command lines (after DM) and looking at the MFD references. If the MFDs are normal MFDs, processing continues as before. If it is a business view, it will transform tne BV references to standard MFD references, and then processing continues.

Many sites have FOCTRANSORM on in their edasprof.

July 17, 2009, 10:36 AM

j.gross

The New Features section on Business Views states:

quote:
The field and segment names in a Business View can be the same as the names in the original Master File, or you can assign new field names in the Business View. When you run a request against a Business View in which any name does not match the corresponding name in the original Master File, the request goes through a transformation process to substitute the real name. To enable this name translation process, you must issue the SET FOCTRANSFORM=ON command before issuing a TABLE, DEFINE, or JOIN command when any name in the Business View is different from the real field name.

Am I right that you can join TO a business view? (If so, the substitution process becomes more interesting...sounds less like a LET-token substitution source-code pre-scan, more like a partnership with Define and Table.)