Skip to Content
Author's profile photo Tammy Powlas

SAP BusinessObjects Design Studio 1.6 CSV Feature

I downloaded the update to SAP Design Studio this morning.  See the SAP Help here: http://help.sap.com/boad

Now it has “Add CSV as a Data Source” feature:

/wp-content/uploads/2015/11/1fig_839808.jpg

But trying it against any CSV file will not work.  See below:

/wp-content/uploads/2015/11/2fig_839809.jpg

The data will not load from the CSV as I used a CSV file without a metadata repository file.

So I locate a CSV file with the metadata repository and see below:

/wp-content/uploads/2015/11/3aggregatesonly_839825.jpg

The aggregates are returned.  I have to go to Edit > Initial View to add the characteristics/dimensions

/wp-content/uploads/2015/11/4fig_839826.jpg

The CSV feature is helpful for initial design and prototyping

Here is how the metadata repository file looks:

/wp-content/uploads/2015/11/5figmetadata_839827.jpg

Assigned Tags

      12 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Carlos Weffer
      Carlos Weffer

      Thanks for sharing Tammy.

      I am also reading on Karol Kaliz's blog that, once connected to any data source, the CSV version of it can be generated using the "Initial View Editor". The CSV exported file later can be used in local mode for data access.

      Cheers,

      Carlos

      Author's profile photo Moritz Kelm
      Moritz Kelm

      Thanks for publishing this. Could you, by any chance, upload an example set of the three required files for import in DS local mode without prior Data Source connection?

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi Moritz - I checked and unfortunately SCN doesn't allow me to upload those file types.  It might be better for you to try what Carlos suggested, and then you see the file types.

      Author's profile photo Moritz Kelm
      Moritz Kelm

      Hi Tammy, I'll do this. Thanks!

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Moritz - also see Karol's explanation here on a thread response: Re: SAP Design Studio 1.6 local mode CSV datasource not working

      Author's profile photo Karan Sehjpal
      Karan Sehjpal

      HI tammy

      as you have described i tried creating the same way one data file and the another metadata repository csv file but i am end up getting this error message everytime i am using csv as a data source where as if i am using csv file which i have downloaded from design studio is working fine fine as a csv data source . Kindly suggest what is the way out.   test.JPG

      Author's profile photo Mustafa Bensan
      Mustafa Bensan

      Hi Karan,

      How did you create the CSV files?  Did you export them from the data source initial view as shown below?:

      ExportCSV.png

      Regards,

      Mustafa.

      Author's profile photo Mustafa Bensan
      Mustafa Bensan

      Hi Karan,

      If you want to generate the correctly formatted CSV files from an Excel spreadsheet instead of exporting from a real data source as per my previous comment, you can use the following utility: CSV Datasource Generator Excel Macro Template v2.0

      Regards,

      Mustafa.

      Author's profile photo Karan Sehjpal
      Karan Sehjpal

      Hi Mustafa

      I am trying using this now i have fetched this document .........

      this is actually when we are using the design studio studio in offline mode.

      I am using my data set in this but it is not working i am trying to use this.

      thanks ... for taking the headche for me .

      Author's profile photo Chandra Sekhar K
      Chandra Sekhar K

      Hi Tammy,

      We are recently upgrade from SAP BO  Design Studio 1.5 to SAP BO Design Studio  1.6 SP 03.

      Not showing these above option Add CSV data source.

      Please share valuable inputs.

      Thanks,
      Chandra Sekhar

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Chandra - in the future, please ask this as a question at answers.sap.com

      Please check your installation, it is appearing for me  - 1.6 SP3

      Author's profile photo Chandra Sekhar K
      Chandra Sekhar K

      Thanks for your response Tammy