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,

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.

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, very cool! I've never seen FILTER FILE used before.

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.

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

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?

Yes Ginny, it would be nice if it worked.

I will check with IBI and see!!

Anyway thanks Ginny

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.