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     [CLOSED] Mandatory filter in master file

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Mandatory filter in master file
 Login/Join
 
AMARNATH_EL
Silver Member
posted
Hi,

I have a requirement where i need to force the user to filter by a particular column when ever he is using the master file.

Example:

billing_date,
merchant,
quantity,
volume

If the user is using the above master file, i want the user to filter always by billing_date.

I dont want to create a reporting object and give to the user.

I want to give a master file to the user and make sure he uses it properly.

Any suggestions on this is really appreciated.

Thanks,
Amarnath

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


WebFOCUS 7.6.7
Unix
Excel/Html
 
Posts: 46 | Registered: January 27, 2009Report This Post
GinnyJakes
Expert
posted Hide Post
http://documentation.informati...ng/sel13.htm#1010837

I don't know if this will work for you because I'm not sure that it will take an amper variable. But take a look at it and see if it can help you out.

You could put it in a global profile.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
GinnyJakes
Expert
posted Hide Post
Amarnath,

I'm stunned but this actually worked! It prompted me for a country.
FILTER FILE CAR
NAME=CAR1
WHERE COUNTRY EQ '&COUNTRY'
END
SET FILTER= CAR1 IN CAR ON
TABLE FILE CAR
SUM SALES
BY COUNTRY
END
You could put the whole first part of this in edasprof.prf.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Dan Satchell
Virtuoso
posted Hide Post
Ginny, very cool! I've never seen FILTER FILE used before. Good One


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
GinnyJakes
Expert
posted Hide Post
Dan, I always read the Summaries of New Features when they come out and even though I don't use the all of the facilities, I guess my memory is good enough even at my advanced age to remember at least a topic if not the details. I highly recommend that as a Best Practice for anyone who does WF a lot.

Just remember, even if you don't need it now, you might need it later. Big Grin


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
AMARNATH_EL
Silver Member
posted Hide Post
Hi Ginny,

Thanks for your help on this.

I coded as below and included in the edasprof.prf. But it is throwing an error.

FILTER FILE BILLING_BV01
NAME=CLGFILTER
WHERE CLG_NUM EQ '&CLG'
END
SET FILTER= CLGFILTER IN BILLING_BV01 ON
TABLE FILE BILLING_BV01
END

Can you please check if it is right?

Thanks,
Amarnath


WebFOCUS 7.6.7
Unix
Excel/Html
 
Posts: 46 | Registered: January 27, 2009Report This Post
GinnyJakes
Expert
posted Hide Post
Don't put the TABLE request in the profile, only the filter and the set filter.

To be clear, I have never used this facility. I just created a quick test to see if an amper variable would work. I didn't try putting it in a profile.

If you make changes and it still doesn't work then I'd recommend that you open a case with IBI. I may, in fact, be steering you down the wrong path. But, it would be great if it worked, wouldn't it?


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
AMARNATH_EL
Silver Member
posted Hide Post
Yes Ginny, it would be nice if it worked.

I will check with IBI and see!!

Anyway thanks Ginny


WebFOCUS 7.6.7
Unix
Excel/Html
 
Posts: 46 | Registered: January 27, 2009Report This Post
Alan B
Virtuoso
posted Hide Post
FILTER will work, but not in EDASPROF if you want &variable prompting. Using in _site_profile with an &variable will cause Parameter Prompting to invoke.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report 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     [CLOSED] Mandatory filter in master file

Copyright © 1996-2020 Information Builders