Skip to Content
avatar image
Former Member

Design Studio on .CSV file - Automatic update

May 18, 2017 at 03:54 PM | 85 Views

Hi Experts,

I am trying to work on Design Studio with csv as my data source. I was able to connect to the file and extract data into the dashboard. However my question is how do we update the Flat file with new data in the future.

For test purpose i tried adding a couple of new rows to the source file in the repository folder but i ran into errors when tried to edit the initial view. I think I am missing something here.

Could you please help me out on this. Is it possible to automate the process such that when in future if we add new data it automatically gets picked into the dashboard?

Thanks in advance.

Regards,

Raja

SAP BusinessObjects Design Studio
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Mustafa Bensan
    May 18, 2017 at 11:35 PM

    Hi Raja,

    The current standard CSV data source is intended for demo and prototyping purposes only. There is no automatic update mechanism. Ideally you should make sure you have all the data you need from the beginning and then don't edit the file after that as it may become inconsistent with the metadata, which is probably what you are experiencing.

    The CSV file is normally generated by exporting a live data source from the Initial View editor. Instead of manually editing your CSV file to update it, you could simply export a new CSV file each time you need a data update and then completely replace the old file with the new one.

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded