Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] How to Limit the rows in Master file?
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] How to Limit the rows in Master file?
 Login/Join
 
<Viswa>
posted
Hai

I have CAR ,master file.
I have a fex file like : ONE.FEX
TABLE FILE CAR
PRINT *
ON TABLE SET ONLINE-FMT HTML
END


If i execuet one.fex file, it will return all the rows.
My requirement is, If i execute the fex file, i need to see the rows, for which country = FRANCE.

I don't want to limit in the fex file.
I want to put that limit in the master file.
Please let me know, how can i acheive the same.
Thanks
Viswakanth

This message has been edited. Last edited by: FP Mod Chuck,
 
Reply With QuoteReport This Post
Platinum Member
posted Hide Post
The implementation of Data Source Security in your master file could help...,
FILENAME=CAR,SUFFIX=FOC
...
END
DBA=MIKEL,$
USER=VISWA1, ACCESS=R, RESTRICT=VALUE, NAME=ORIGIN,
VALUE=COUNTRY EQ 'FRANCE', $
USER=VISWA2, ACCESS=R, RESTRICT=VALUE, NAME=ORIGIN,
VALUE=COUNTRY EQ 'ENGLAND', $
USER=VISWA3, ACCESS=R, RESTRICT=VALUE, NAME=ORIGIN,
VALUE=COUNTRY NE 'FRANCE', $

Anyway, using this method, you need add SET PASS=VISWA1 in your fex or profile (not in the report). Otherwise, you will get a security error.


SET PASS=VISWA1
TABLE FILE CAR
PRINT *
END
Regards,
Mikel

This message has been edited. Last edited by: <Mabel>,
 
Posts: 173 | Location: Madrid, Spain | Registered: May 09, 2003Reply With QuoteReport This Post
<Viswa>
posted
Hai Mikel
How to add it in the profile?
Please let me know
Viswa
 
Reply With QuoteReport This Post
<Viswa>
posted
Hai

Let's say i have my report in MRE.
And i have a group called grep1. And all the users who are under that group (grp1), when they try to Query that CAR master file, they should be able to see only COUNTRY=FRANCE data.

How can we do this?
This is very urgent.Can someone throw some light on this.

Thanks
Viswakanth
 
Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Using DBA security (see previous example) and creating a domain profile with generic SET PASS may be a good solution.

Regards,
Mikel

This message has been edited. Last edited by: <Mabel>,
 
Posts: 173 | Location: Madrid, Spain | Registered: May 09, 2003Reply With QuoteReport This Post
Expert
posted Hide Post
The 'MFD PROFILE' should do the trick. It's new to WebFOCUS 8x, maybe sooner.

I know this is an old thread. But, it came up in a search for something else that was significant. So, I added my Two Cents here for searching.


   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Most recent: 8204 Gen 48 in Test and Production.
   Currently Available. Please contact me.
 
Posts: 2976 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
I will also add to this ancient thread - if you use the DBA security as shown in the answers here, you might consider SET PERMPASS in the profile instead of just SET PASS. That way a user cannot override it.
Also you will probably want to disable SQL PASSTHRU since that will bypass your DBA security rules.


Webfocus 8
Windows, Linux
 
Posts: 246 | Location: Palm Coast, FL | Registered: February 05, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] How to Limit the rows in Master file?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.