I have a report created using 2 data sources of which one is excel and the other is an universe. If I have to schedule it. where should I place the spread sheet while sending to the BCA. I am connecting through Citrix. I am in 5.1.2. Please advise with the steps.
If I place the excel sheet in a network share…I get an error saying that…“the excel sheet may be opened by a different user or you do not have permission to view the data”
If you are not going to refresh the Excel Data then you can uncheck the refresh option of the Excel Data provider. In that case you do not need to put the excel sheet on the netwrok drive before sending the report to the BCA.
As an aside, if you want to use spreadsheets, text files and the like as a data source, make sure that you refer to their location with the full \server\folder notation, rather than using mapped drive letters. These can cause problems where the BCA machine either maps the drive elsewhere, or just doesn’t have it mapped at all.
how do you disable the refresh of a data provider?
I’ve looked at the Data MAnager window, and here, the Automatic Refresh is never checked, but the reports are refreshing on the BCA server.
Is there a trick to force it NOT to refresh.
There are two checkboxes: Refreshable and Editable. If you remove the check in the Refreshable checkbox, then that data provider is never refreshed. By BCA or otherwise.
Those two checkboxes are on the data manager screen, which is accessed via View + Data from the menu or the toolbar button that looks like a cube.