[SOLVED] Generating Business Views with Filters, Virtual Columns, and/or Compute

Maybe FILTERs will work:

Using Filters, see page 3.

Assigning Screening Conditions to a File

WebFOCUS 7.7.05

Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007

Ignored post by Dan Satchell posted

Member

posted

Thanks for pointing me to Filters. In researching them it does not appear to give me what I need, or I may not fully understand how to use them. If I can restate my issue; at the masterfile level I want to change the value of the salary field based on these rules; when the user accessing the file is A then the salary is 0, when the user is B and the location field ='MX' and the orglevel field is greater than 5 then the salary is 0, when the user is C and the orglevel field is greater than 5 then the salary is 0, when the user is is D and the orglevel field is greater than 7 then the salary is 0, when the user is E then the salary is the salary.
I was hoping that there was some syntax in the Business View definition that would allow me to do this type of conditional checking.

Release 7.7.03,
Windows platform,
Excel, PDF, HTML,Active Reports, Active/Flex,

Posts: 25 | Location: Michigan, USA | Registered: May 09, 2008

Ignored post by James at WI posted

Waz

Expert

posted

This sounds like you need to use the DBA option in the Master files. This can restrict acces to columns and data.

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Ignored post by Waz posted

Alan B

Virtuoso

posted

Business views might work. Try:

FILENAME=CAR_BV, VIEW_OF=car, $
  SEGMENT=FOLDER, $
    FIELDNAME=COUNTRY, ALIAS=COUNTRY, $
    DEFINE CAR/A16 = IF COMP.CAR EQ 'DATSUN' THEN 'NISSAN' ELSE COMP.CAR;
    FIELDNAME=MODEL, ALIAS=MODEL, $

so redefining the field CAR overrides the real field, and also stops the real value of CAR coming through.

Has to be hand coded though.

Also be aware that if you did:

FILENAME=CAR_BV, VIEW_OF=car, $
  SEGMENT=FOLDER, $
    FIELDNAME=COUNTRY, ALIAS=COUNTRY, $
    DEFINE CAR2/A16 = IF COMP.CAR EQ 'DATSUN' THEN 'NISSAN' ELSE COMP.CAR;
    FIELDNAME=MODEL, ALIAS=MODEL, $

then someone could code

TABLE FILE CAR
PRINT COUNTRY CAR CAR2 MODEL
END

which would sort of kill any security; though the field CAR would not be available in the tools, it is accepted if it was coded via an editor.

Alan.
WF 7.705/8.007

Posts: 1451 | Location: Portugal | Registered: February 07, 2007

Ignored post by Alan B posted

Member

posted

I will work on setting up the business views. Is it possible to have business views in different app/path folders that the original masterfile?

Thanks

Release 7.7.03,
Windows platform,
Excel, PDF, HTML,Active Reports, Active/Flex,

Posts: 25 | Location: Michigan, USA | Registered: May 09, 2008

Ignored post by James at WI posted

Member

posted

I believe that the business view approach will give me what I am looking for. I am having an issue with syntax for the DEFINE virtual column. While the reporting tools (Dev Studio and InfoAssist) recognize the virtual field I get an error when attempting to use it in a report. the error is
0 ERROR AT OR NEAR LINE 6 IN PROCEDURE newfex FOCEXEC *
(FOC003) THE FIELDNAME IS NOT RECOGNIZED:
EMPLOYEE_BASIC_SPECIAL.FOLDER1.ANNUALSALARY
BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT

The syntax in the business view is
FILENAME=EMPLOYEE_BASIC_SPECIAL, VIEW_OF=hr/employee_basic, $
SEGMENT=FOLDER1, $
FIELDNAME=EMPLOYEEID, ALIAS=EMPLOYEEID, $
FIELDNAME=STATUS, ALIAS=STATUS, $
FIELDNAME=COMPANY, ALIAS=COMPANY, $
DEFINE ANNUALSALARY/P21.4=IF PAYGROUPCODE EQ 'EXEC' THEN 0 ELSE ANNUALSALARY; $
FIELDNAME=PAYGROUPCODE, ALIAS=PAYGROUPCODE, $
FIELDNAME=EMPLOYEENAME, ALIAS=EMPLOYEENAME, $

Release 7.7.03,
Windows platform,
Excel, PDF, HTML,Active Reports, Active/Flex,

Posts: 25 | Location: Michigan, USA | Registered: May 09, 2008

Ignored post by James at WI posted

Member

posted

Using Business Views got me to where I needed to be. Thanks Alan. We will be using InfoAssist for our report development. The final resolution involed defining virtual fields in my masterfile, creating business views, grouping my developers by domain/group in MRE, creating reporting objects and limiting the developers/users to the available reporting objects.

Release 7.7.03,
Windows platform,
Excel, PDF, HTML,Active Reports, Active/Flex,

Posts: 25 | Location: Michigan, USA | Registered: May 09, 2008

Ignored post by James at WI posted