Excel as Source to a WebI
This is a simple & quick how to procedure which explains about how to make an Excel as a source to WebI. Thanks if you found this interesting and utile.
Note: This is a special feature available from BO Version 4.1 (SP2) onwards.
I’ve tried to post this maximum with the screenshots hope we all love more of a screenshots rather composing big paragraphs. This process is not a big deal still will hopefully help fresh guys.
Here is how we can upload an excel file and make it as a source for WebI report.
Choose Local Document, and choose the destination folder to upload an excel file.
Choose file from your computer as highlighted.
Here you can choose the file you want to upload and make your WebI Report
Click Add to upload the file.
It will be uploaded as highlighted here.
Now, it is time to create a WebI Report based on uploaded file.
Select new report.
Choose Excel as a Data Source.
Choose the destination folder on which the excel was uploaded and saved.
Here you can do settings for the excel file.
Now the WebI will show all the dimensions and measure as default.
You can choose and change a dimension into a measure as per requirement.
Here you can even select type of the object(String/Date/Number).
After doing all necessary steps you can run query to get result as intended.
You can also save this as WebI query as highlighted.
That’s it. Thanks