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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
Hi, I have created a huge cluster synonym.Since there are more than 10000 columns i have created a Business view so that the InfoAssist user can only see a limited number of columns.But when a developer tries to create a report with that cluster he is also restricted to see columns that is only available in the business view.How can i change this setting so that when the master file is used to create a report in AppStudio it should list all the columns in the cluster.Please help me out.
Thank you Sivakumar Gopi. WF 8105M Windows 10This message has been edited. Last edited by: FP Mod Chuck,
Let's say this was possible (which I doubt it would be). The Developer creates a report using columns that are hidden from the users and publishes the report. When the users run that report, how will WebFOCUS show those columns to them?
If you're trying to hide columns from one group of users and show them to others, you may need to use DBA to restrict users from seeing these columns even though they're there.
WebFOCUS 8206, Unix, Windows
Posts: 1853 | Location: New York City | Registered: December 30, 2015
Easiest solution would probably be to do a save as with your current cluster and flatten out the business view to make sure all the fields are viewable for your App Studio developers. You'll now have two separate clusters or active synonyms with slightly different names, and depending on which adapter you set it up in, your security with each role can be limited to which adapter or cluster they see.
Version: 8.2.03M, OS/Platform: Windows 7 & 10, Output: Excel, pdf, html
Posts: 63 | Location: Liberty Lake, WA - USA | Registered: June 23, 2016