Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Generating Business Views with Filters, Virtual Columns, and/or Compute

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Generating Business Views with Filters, Virtual Columns, and/or Compute
 Login/Join
 
Member
posted
I have a need to provide a security tailored view of data to my MRE report developers based on column values. As an example, using my employee file; some developers can only see employees from their region, other developers can see all employees but can not see any salary/wage information, others can see all information on all employees with the exception being salary/wage information for manager level and above, and lastly some can see everything about everyone. I know that I could create multiple masterfiles and locate them is separate app/paths, but I was hoping to use Business Views tailored against one masterfile. Is there anyway to filter the data at the Business View level or generate virtual or computed columns? Can this be done? relatively easily? thanks for any and all assistance.

This message has been edited. Last edited by: James at WI,


Release 7.7.03,
Windows platform,
Excel, PDF, HTML,Active Reports, Active/Flex,
 
Posts: 25 | Location: Michigan, USA | Registered: May 09, 2008Report This Post
Virtuoso
posted Hide Post
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, 2007Report This Post
Member
posted Hide Post
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, 2008Report This Post
Expert
posted Hide Post
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.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs: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, 2006Report This Post
Virtuoso
posted Hide Post
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, 2007Report This Post
Member
posted Hide Post
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, 2008Report This Post
Member
posted Hide Post
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, 2008Report This Post
Member
posted Hide Post
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, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Generating Business Views with Filters, Virtual Columns, and/or Compute

Copyright © 1996-2020 Information Builders