Hi all, in this post we create a RPD (repository ) from scratch, prerequisites for this tutorial is the previous post (Creating an OBIEE repository(initial setup). we usually take a copy of the RPD that come by default and setup our environment, there are differences on how we manage the RPD and deploy when working on windows or Linux environment, in other words when your server is either windows or Linux OS you will need to take a different approach, so just to simplify, we use windows for this demo .
Ok, so when we are going through the oracle by examples there will be a step where you will face a failure when trying to connect to the database, in this demo we go through the steps to create a new RPD and also solve that connection problem when configuring the connection pool, you can follow the below steps:
Go to “Admin” tool, “file” and “new repository”
Select “Binary method” and enter the name of the repository:Leave the “location” as default, leave “import metadata” as “yes” and assign the “repository password” and click next:
Now you will need to connect to the database using the schema you created “BISAMPLE”
In this step you need to set up the “Connection type”, “data source name” (database name),“schema name” and “ password ”:
At this step there is a problem when you specify the ” data source ” as “ORCL” due to the binaries of OBIEE that does the OCI call not reaching the listener in the TNS names, fortunately Oracle has solved that in the 12C version :
By the way, to solve the connection issue you need to explicitly pass the TNS names.
To do that navigate to this directory: C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN .
Open the TNS names file and copy that portion:
You need to pass the TNS like this :
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)))
If you passed the TNS correctly you should be able to proceed without errors and see the following screen:
Import the metadata:
Progressing, when this is finished the connection pool will be created and you can rename it to a more meaningful name:
Click “Finish” and rename the newly created connection pool:
That is it, you now have created the physical layer (connection pool), test your connection to the data source:
Right click in one of the data stores and click “view data” :
You will need to perform some extra steps now till to the presentation layer and deploy the new RPD in the WebLogic server.
- Business Model and Mapping Layer :
Basically the BMM is the logical layer, it is where you apply transformation/logic/ aggregation functions and time series function, the BMM basically maps the logical layer to the physical layer, and the main purpose of the business model is to capture how users think about their business using their own vocabulary. The business model simplifies the physical schema and maps the users’ business vocabulary to physical sources …
I recommend you to follow the oracle by examples for the whole tutorial through the presentation layer :