Before being able to create reports based on files hosted on Google Drive, make sure your administrator has set up an authorization server configuration for OAuth authentication in the Central Management Console so that the SAP BI Platform can access these cloud storage services.
The Data Source dialog box contains a new category Cloud Storage, with Google Drive.
You can then navigate in the Google Drive repository and select your data source file.
If you have selected an Excel or a Text file, you must enter the same file interpretation settings as for the SAP BI Platform Repository. If you have selected a Google spreadsheet file, you must also enter the settings that define what data to query.
The Query Panel which has got the same look no matter the data source you use, is displayed.
Select the objects to query or to use in filters.
When your query is complete, click Run.
Once the query has been run, you can work with the dataset retrieved from the data source on the Google Drive and format your document.
Object properties are no longer set in the Query Panel, but in a new Object Properties tab once you have run the query.
For more information, please refer to Unit: Working with Formulas and Variables - Lesson: Editing Objects Properties.
Watch this video to learn how to build queries on Google sheet file:
When you schedule a Web Intelligence document, you may select Google Drive as a destination for the generated output. In Google Drive, you can only schedule Excel or Text files. In the Select Destinations dialog box, you can browse the Google Drive and select a destination folder for which you have writing rights.