Excel Dataprovider in Webi - how to change source path?

[Former Member]

Hi Experts!

Can you advise how to change the source path of an excel data provider? We currently have the excel file sitting in a folder in Bi Launchpad, and from there we created a webi report with it. BUT we then changed the name of the folder, and now we find the excel data provider doesn't work because the source path hasn't changed to include the new folder name - it's still looking for the old one! I see you can set the source path when you create an excel data provider, but I can't see how to change it now.

Thanks,

Andrew

[former_member198519]

Try the steps mentioned in this note:

2203011 - How to change the path of an Excel data source located on a mapped network drive to UNC pa...

[Former Member]

Hello Andrew,

Go to Query panel of your report and just click on the highlighted button of attached screen shot to navigate through the new path.

Regards

Niraj

[Former Member]

Hi Niraj! This is very helpful. But when I do as you say I see there is no button like this. All the other fields are there. When I drag the slider to the right to show what is at the end of the Source Path field, the field just expands, showing no button. Don't know if this is a Java issue or a Rights issue. I'm logged in as admin. And we're using 4.1 SP4 patch 12. Thanks

[former_member198519]

Just making sure you are going the same navigation like below:

1. Go to Web Intelligence Rich client
2. Go to Data Access -> Data provider -> Edit
3. Open the "Query Panel", and in the "Query Properties" tab, use the Source Path menu to select a different source file.

Can you give us a screenshot of what you see?

[Former Member]

Hello! This is what I see. When I expand the left pane to see the button at the end of "Source Path", the field just keeps expanding as well - no button. Thanks

[amitrathi239]

click on the edit setting and check

[Former Member]

Could you please try that with Rich Client?

Regards

Niraj

[Former Member]

The Edit Settings has no button either - just displays the source path field, which is uneditable.

Thanks

[Former Member]

We don't give our users access to Rich Client so it would be best to find the solution for Webi.

Thanks

[former_member198519]

Would you try creating a sample report on top of the same excel sheet and see if the new report allows you change the source or not?

Also have a look at this blog

[Former Member]

Hi - I created the sample report and the button is still unavailable.

I also checked the blog but it doesn't really cover that issue.

Anything else you can recommend?

[former_member198519]

Just to confirm, you are logged in as Administrator user, Correct?

Secondly, can you check the folder and application access with the below right:

CMC-> Access Level -> Included Rights -> Application -> Web Intelligence -> Desktop Interface - enable local data providers

[Former Member]

Hi, yes, I'm logging in as admin, but issue affects all users.

Checked all relevant access levels and they do have that right GRANTED.

It's a tough one! Anything else I should check?

[amitrathi239]

Right click on the excel file->Organise->replace excel->choose the file and try in BI Lanuch Pad.

[Former Member]

Hello Andrew,

Could you please check it from Rich Client in an offline mode so that you have no connection to server. This will confirm that if this is a product bug or access issue.

Regards

Niraj

[amitrathi239]

I have tested from  BI LanuchPad you need to follow replace excel file path only..

Right click on the excel file->Organise->replace excel->choose the file and try in BI Lanuch Pad.

[Former Member]

I have exactly the same problem, I have the button to change the Excel in Rich client, but non on webi. We have version 4.1 SP 6

Thanks