Change Datasource without create new visualizations

[Former Member]

Hello,

I have create an excel sheet this is my datasource in Lumira. But when I save the excel sheet in an other folder I can't change the file path.

When I use the button "change datasource" then my visualisation are blank.

[TammyPowlas · Accepted solution]

Susan - I just tried it and experienced the same as you using 1.15

Could you send this to support.lumira@sap.com - SAP Lumira Expert team?

[Former Member · Accepted solution]

Hello Tammy,

yes I use Lumira 1.15.

I can send the problem to Lumira Experts too.

Susan

[Former Member · Accepted solution]

Tammy - thank you for the reference.

We have updated Susan via email, and submitted an internal request.

We will be updating everyone on this post.

//bijan

[Former Member · Accepted solution]

Susan,

Try this:

http://scn.sap.com/docs/DOC-47220

Let me know how this works!

//bijan

[Former Member · Accepted solution]

Hi Bijan,

your tutorial display a connection with HANA. But I try to change an excel connection. I must change a folder path to the excel datasource.

It doesn't works.

Thanks.

[TammyPowlas · Accepted solution]

Susan is right - this option to edit a data source for a CSV file is greyed out for me as well:

[Former Member · Accepted solution]

Hi Tammy,

I know this function but this is not my problem. My problem is, when I change the data source path then all my visualizations are away (empty).

[TammyPowlas · Accepted solution]

Can you change the path/data source?  I cannot, even with the patch

I'd like to recreate your steps but I cannot since I can't change the datasource on the desktop

[Former Member · Accepted solution]

@Tammy - The screenshot you took was of the Edit Source dialogue box, found in Data-->Edit (Ctrl+Shift+E).

The change can be performed for Excel and HANA documents via the Connections Pane.

This is right after Lumira loads, before opening a document.

Here's a screenshot:

How has this method worked?

//bijan

[TammyPowlas · Accepted solution]

Thank you - that works

Previous versions we did it under Edit > DataSource

[Former Member · Accepted solution]

Yes. It was mentioned in one of Henry's posts previously.

IMHO it makes more sense the way it was, and also having it here would be handy.

//bijan

[Former Member · Accepted solution]

Hi Bijan,

thanks for your anwser. It works. But I discover a display error. The display of datasource name is not correct.You can see that in the screenshot.

[Former Member · Accepted solution]

Susan,

You've changed the data source, and the new data source is being used, but the name is still the old one? --Is that correct?

//bijan

[Former Member · Accepted solution]

Hi Bijan,

yes, it's correct. You have understood really well.

Susan

[Former Member]

Hi Susan,

I was also looking for same & got something which solved our purpose.Follow the steps but do take the backup of the LUMS file you are using.--

- Extract the lums file with your favourite zip archive tool (mine is 7zip) and change the ConnectionServerHost entity inside document.xml. When you pack it back up it should now connect to your new server.

[Henry_Banks]

That was a nice workaround suggested on this thread   by Former Member

but i believe you were talking about free hand sql dataprovider in that case?   i wonder if this applies to .xls (i would be interested..)

cheers,

H

[Former Member]

This message was moderated.

[TammyPowlas]

Vidhi - please stop posting the same question in multiple places.  Cross posting is not allowed per SCN rules.

Let's see what when he gets in to work later today on this