Hi All
I have few reports which will come from BCA on weekely basis and I shouldn’t show “refresh” button to users when they open the report in WebI. But all other reports should show that button.
I can’t check the report “Refreshable” option in full-client as it has to go through the BCA and has to refresh.
I’ve tried creating new group with NO Refreshable option and added the existing user to that group and assigned him to new document domain. Still I could able to refresh the report from my new domain…
I heard at one of our client’s place that BO is planning to include this in their 6.5 release. Does anyone have any knowledge of their roadmap in terms of including this feature? I understand this would requite MAJOR architectural changes in their repository, but was wondering if anyone is aware of any such plans that they might have.
Each report is “owned” by a user REFRESH. There is a setting on each data provider that determines whether a report is refreshable or not… only the owner of that report (the original creator) can change that setting. In these reports that setting is off, preventing anyone from refreshing the document.
Within the document is some VBA code. When the document is sent to BCA (by the REFRESH user) the code is selected as part of the process. That code will reset the refreshable flag to “yes”, refresh the report, reset the refresh flag back to “no” and publish the report.
We had a similar requirement. But the issue was there will be a group of ‘Reader’ users and a group of ‘Writer’ users. The ‘Reader’ of one universe could be a ‘Writer’ of the other universe. we ended up having two copies of the universe - one for readers and one for writers. One of our colleagues wrote some excellent VBA code to automate creating the copy of the universe and to also create a ‘read-only’ version of the document by switching the universe.
These VBA routines were called via a VB App… a small change in the process but served the purpose and the users seemed to like it.
I wouldn’t mind, but the client that paid for the development might. I’m afraid that I can’t distribute the actual code. But the workflow is very simple, the outline I provided above should be enough for someone with a basic knowledge of the BusinessObjects SDK (VBA flavor) to write the code.
BTW, this only works for full client reports… it would not be available for Webi reports at all. It would work for full client reports viewed through webi… that’s how the original client is using the code.
If I get the chance (which is not likely for the next several weeks) I will try to redo the code and submit it for posting in BOB’s Downloads. But if you need it soon, it would be better to get started now.
Dave,
I’ve strted working on it and my code works perfect but only the thing is ‘Refresh Button’ is still exists on WebIntelligence, though it won’t refresh the report. Can we hide this button totally? In full-client Refresh Button got disabled perfectly. I am just concerned about ‘RefreshButton’ on WebI… Please advise.
If anyone has written the code to specify strict refreshes by Broadcast Agent, I would like to view this if possible. Also, We have decided to create reports for our client using the WEBI so as VBA functionality is not included in the WEBI, it seems sensible to create reports in full client and view them on the WEBI. Is this possible?
(BOB member since 2002-06-25)
I’m afraid that I can’t distribute the actual code. But the workflow is very simple, the outline I provided above should be enough for someone with a basic knowledge of the BusinessObjects SDK (VBA flavor) to write the code.
(BOB member since 2002-06-06)
I can understand. I am not too good at VBA but I will try… Thanks!