Sending a report to BCA which uses Excel data source

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”

Any quick help is greatly appreciated.


Ashokkumar (BOB member since 2004-05-20)

Sorry Guys, It is a user error. I got the report and spread sheet from her and scheduled it. It works like charm.

Thanks.


Ashokkumar (BOB member since 2004-05-20)

Just a thought

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.


JaiGupta (BOB member since 2002-09-12)

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.


Paul Williams :uk: (BOB member since 2002-07-10)

Hi,

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.

thanks,
Benoit


benoitd (BOB member since 2004-06-30)

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.


Dave Rathbun :us: (BOB member since 2002-06-06)

ok thanks, I see them now… but they are greyed out. I cannot deselect them???
Even when it’s a .txt file.


benoitd (BOB member since 2004-06-30)

That’s because you didn’t create the document. I believe that only the original creator (owner) of the document can change those settings.


Dave Rathbun :us: (BOB member since 2002-06-06)

Do a “Save as…”, check “Save for All Users”. Then you should be able to unckeck the box.


Andreas :de: (BOB member since 2002-06-20)

wouuu thanks, it worked. I had to save it for all users.

thanks a lot


benoitd (BOB member since 2004-06-30)