Oracle BI Server can access data stored in
Normalized schema databases
Star or snowflake schema databases
Flat files
Excel
XML etc.
Today I am gonna tell you how to use excel data source in OBIEE.
1. Create a new excel file.
2. Each sheet present in an excel file will represent a table.
3. Select the range (i.e. rows and columns) and give the name of the table as shown in figure.
No comments:
Post a Comment