Here are the steps to install OBIEE (Oracle Business Intelligence Enterprise Edition) 11g though I purposely installed Oracle Business intelligence so I can use BI publisher 11g, which is simply 1 of many products that comes packaged within OBIEE.
MDS-01376: Unable to get database connection from data source "mds-owsm" configured with JNDI name "jdbc/mds/owsm".
weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: ORA-28001: the password has expired
So I installed the new version of bi publisher 11g and was presented with the typical welcome screen. The this is, I didn't know the
credentials for admin access. The old 10g was Administrator/Administrator though the access control has now been locked down within
the new version of bi publisher.
Like most developers would typically do, I created a more comprehensive Oracle SQL code outside the realms of the bi Publisher with
the intention on importing this directly into BI publisher thus creating a pre-defined data model for my custom report.
The new 11g Bi Publisher has changed substantially as Oracle has provided a more lightweight approach,
which all in all has it's benefits, though from a developers perspective has changed to the approach completely.
I came across this issue in previous installments however I was boggling for a couple of days without a solution. I did however manage to get this resolved
on the 3rd day though never recorded what I changed in order to get this working. Now I'm in the same position, I am adamant to find the solution once more, and here it is.
(Though I ended with a different result this time)
When creating the a SQL query within SQL developer and executing it successfully, When I transferred it over to bi publisher to create a
data model for the report, I was getting the ORA-00907: missing right parenthesis error
I am bringing back two columns, Username and Inactive. I want to convert my SQL query returning 2 columns by a comma delimited
into a line-delimiter. The intention here is to loop through each column, for each row, and display this in a line-delimited format
This was a nightmare to understand, though incredibly easy to create. The oracle documentation is somewhat convoluted to the point where
I extracted various information from multiple websites to help me with building eText intuitively.
You will notice within the BI publisher design, there are OOTB page elements available such as 'page break',
'Total Pages', 'Page Number' though there's possibility to expand out to further functionality, which is
annoying because the simplest function you wish to use, such as 'current date' or 'timestamp', which are not available.
I have been trying for hours now to create a dataset within BiP 11g by importing in an XML file. There seems to be a lot of information around XML files for the 10g version of BiP, though no acknowledgement that importing XML files as data sets is available for the 11g version.
Long story short, I have my doubts that this 11g version is even possible.
You will notice that the BI Publisher interface does have OOTB page elements functionality
(such as Page Break, Page Number, and Total Pages), which are all common functionalities. One functionality
you will notice that isn't available is adding date into BI Publisher.