|
Khalid, Some Windows based tools such as Showcase Strategy, Cognos, and even Seagate Info (AKA Crystal Reports) offer features you are looking for. With these tools, a programmer or power-user with security access can define Data Dictionaries (terms vary between products but the concept is the same) that provide access to the right tables and fields, performing the joins between the tables. The dictionaries are secured by user. The tools are WYSIWYG, GUI, drag and drop, OLE, and lots of other Windowzy buzz words, so you look really trendy and cool deploying them. Most of them allow for the output to be directed straight to Excel, Word, HTML, and many other file formats. I recommend that you choose one which links to a query engine that runs on the 400 rather than using ODBC. The 400 chokes on ODBC requests off large tables. Success with these tools depends on having only people who know what they are doing setup the dictionaries, document the scope of what the data in the dictionary can provide, then setup access so that users can access only the dictionaries to which they are authorized. Don't just turn everyone loose on writing reports from scratch. Do as much work in the dictionary as possible. Try to do the tricky logic for them. In an ideal world users would then need only deal with report layout, filters, grouping, sorting, publishing, and distribution. Here are some links: http://www.seagatesoftware.com/homepage/ http://www.cognos.com/impromptu/index.html http://www.showcasecorp.com/strategy/strategy.html Regarging account inquiries, according to the 6.1 net change doc, a feature new to 6.1 "allows security to be set for Events Processing and the INQUIRY APPLICATIONS. It prevents you from posting to an account for which you do not have access and/or prevents you from VIEWING BALANCES of those accounts" (emphasis added). The idea is that you revoke a user's ability to view account balances, then selectively grant view access to the ones you want the user to see. With this feature, one account query that shows your actual and budget book balances for your expense accounts could generate different results for different budget managers without having to fiddle with report parameters. This is a form of inquiry security built right into BPCS and can really cut down on the number of reports you need to write. For all you multitudes of folks running 6.1... Good luck with whatever you choose. Geo. +--- | This is the BPCS Users Mailing List! | To submit a new message, send your mail to BPCS-L@midrange.com. | To subscribe to this list send email to BPCS-L-SUB@midrange.com. | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com. | Questions should be directed to the list owner: dasmussen@aol.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.