Oracle BI Apps 7.9.6.x with OBIEE 11g

[Shyam Varan Nath]

Has anyone tried Oracle BI Apps 7.9.6.1 or 7.9.6.2 with OBIEE 11g?  If so please tell how you handled the below:

1)  How did you install BI Apps software (just the BI apps say 7.9.6.2 excluding OBIEE, Informatica, DAC)  ? 

2) How did you migrate the BI Apps provided RPD and Webcat? 

3) Was it a new BI apps you installed with OBIEE 11g or migrated an existing installation?

4) How was/is your security model?

Thanks

Shyam

[Parameshwaran Venkataraman]

Let me just answer the first question.

You need a valid OracleBI and OracleBIData for BI APPs installation. a simple solution would be to take a copy of the existing 10g installation folders and fake the installation. There you will find the rpd and catalog. Just ftp them to your 11g instance.For info/DAC, just move the REP file and src files and lkp files to the required directory. Ditto for DAC. Anyway DAC and Info are independent of OBIEE.

Param

--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
obiee-enterpri...@googlegroups.com
To unsubscribe from this group, send email to
obiee-enterprise-met...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
 
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).

[Venkat]

Yes. I have done one recently. The customer is going live in a couple
of months.

1. Currently BIEE 11g support for 7.9.6.2 is only a name sake support
i.e. the install/configuration of BI Apps require a 10g BIEE instance.
So, one will have to upgrade BI EE alone separately to 11g post the BI
Apps install/config. I believe there is a release of 7.9.6.3 coming
sometime soon (how soon is a question for which i don't have an
answer) which will support installs directly on BI EE 11g. Also, this
release will make native use of many BI EE 11g features like
Hierarchical columns etc.

2. Migration is straight-forward using the BI EE 11g upgrade
assistant. Though upgrade itself is a smooth process, there will be
quite a lot of issues post install. For example, the repository will
have 200 to 400 odd warnings/errors depending on how complex the
repository is (number of modules used). The common reasons for these
are

a. BI EE 11g does not support leading and trailing nulls in object
names
b. BI EE 11g throws up new warnings like if an LTS has 2 tables inner
joined but columns are mapped only to one table, then it is a warning
in 11g (not in 10g).

Quite a lot of time needs to be spent to basically resolve them. In
addition, there are some BI EE 11g bugs which one will have to be
aware of

a. BI EE 11g has an aggregation navigation bug where in the queries
hitting the aggregate tables in BI EE 10g will no more hit the
aggregate tables in BI EE 11g. The reason for this is, theoretically a
LTS assigned either at the Total Level or a NULL level mean one and
the same in 10g. So they can be mix and matched (in 10g). But in 11g,
we cannot mix and match these. In some of the aggregate LTS, BI Apps
does mix and match the level assignments and these will not work
properly in 11g. So, we need to manually modify them.

b. If you are on 64 bit linux and are using LDAP authentication in
10g, after upgrade the security will no more work. There is a patch
for this now and it has to be applied for security to work.

c. Another big change in 11g is the requirement of needing database
tables for authentication (or even creating a session in 11g). So, co-
locating the BI EE RCU schemas in the BI Apps schemas can considerably
slow down the BI EE user experience. This is all the more valid when
ETL loads run. So, its better to isolate the RCU schema database and
the BI Apps database. If not possible, atleast the database needs to
be resized to take into account the extra overhead that BI EE 11g puts
on the system.

d. In general, BI EE 11g sizing needs to be redone i.e. we cannot use
the same specs of BI EE 10g as addition of 2 JVMs in 11g can
completely undersize BI EE.

e. There will be more load to the database in 11g. The reason is many
reports of BI Apps use pivot tables with columns in pages/excluded
sections. In BI EE 10g, generally these are all done at the
Presentation Layer memory (post the sql query). But in BI EE 11g,
pivot tables have been altered to basically push down everything
possible (including pages/excluded sections) into the database layer.
So, every change in the page prompt will result in a new BI EE query.

f. Weblogic startup and shutdown can be slow if we hookup LDAP with
weblogic. Care has to be taken to ensure that the right search
classes, bind dns are used within weblogic.

3. We migrated an existing instance. Basically Project Analytics 10g
was migrated to 11g.

4. We used the LDAP security (10g style after applying the patch).

Thanks,
Venkat

[Robert Tooker]

This is really useful information for BI Apps and a more general obiee upgrade. We're looking at moving to 11g later in the year - it's good to know some of the issues we will face ahead of time. The LTS issue in particular will need some rework of the repository in our instance.

Has anyone else gone through the upgrade process and faced similar or new issues? Is there anything that's currently unsolvable?

Robert

[Stewart Bryson]

Venkat: I'm glad you work for us. :-)

Stewart

[Kevin McGinley]

Now that's just rubbing it in, Stewart. ;)

We are doing some 11g/7.9.6.2 implementations as well and one sticking
point is definitely security. Authenticating against one source
(LDAP) and authorizing using another (EBS role tables) just isn't
possible in WLS in 11.1.1.3, at least not using the standard WLS
functionality.

Kevin

On Mar 23, 8:01 am, Stewart Bryson <stewartbry...@gmail.com> wrote:
> Venkat: I'm glad you work for us. :-)
>
> Stewart
>

[Venkat]

Thats true. It has been fixed in 11.1.1.5. We can now directly update
the ROLES variable which wasn't possible in 11.1.1.3. So essentially
we can authenticate in WLS and authorize through EBS tables. What i am
not sure of though is whether it is supported as the support matrix
says that we cannot use both WLS and BI EE authentication (but we can
assume as long as we don't use the "Required for Authentication" check
box for getting the ROLES we will still be supported).

-Venkat

[Amith Yenigalla]

Hi Venkat,

In 11.1.1.3.0 we couldn't use roles session variable to initialize row-wise from an external table.  So from my understanding of your reply, you are saying in 11.1.1.5.0 roles session variable can be referenced in init blocks to populate the data from an external table? ( EBS in this scenario )

Thanks,
-Amith.

[Venkat]

Yes Amith. Thats correct. We can update the ROLES variable directly
through an init-block in 11.1.1.5. Atleast this worked on a couple of
tests i did.

-Venkat

[Jit Dutta]

Just to confirm, is the newly released OBIA 7.9.6.3 native on OBIEE 11g platform, no platform upgrade is required?

Thanks!

Sent from my iPhone

[Kevin McGinley]

7.9.6.3 only works with 11g and the installer produces an 11g
compatible RPD and catalog. A few catalog objects have been updated
to take advantage of 11g features, primarily sliders.

Venkat - thanks for the info. Although I am skeptical, as the
inability to use both the old way and the new way at the same time
still poses some potential problems. What we really need is the
ability to both authenticate and authorize against different providers
in WLS. But I will be testing all of this out soon on a client site.

Kevin

[Doug Ross]

So for all those RPD warnings/errors - has anyone come up with an
approach to deal with them?

The 7.9.6.3 OOTB RPD for Financials and HR has 167 warnings
identified. And now there doesn't appear
to be the capability to turn off individual checks for certain
conditions within the consistency checker.

Here's some sample warnings;



WARNINGS:


BUSINESS MODEL Core:
[39059] Logical dimension table Dim - Date has a source
Dim_W_DAY_D_Common at level Day Detail that joins to a higher level
fact source Fact - HR - Event Information
(Workforce).Fact_W_WRKFC_EVT_MONTH_F_Event_Quarter_Ago


BUSINESS MODEL Core:
[39008] Logical dimension table Dim - Date has a source
Dim_W_ENT_WEEK_D that does not join to any fact source.


BUSINESS MODEL Core:
[39008] Logical dimension table Dim - Date has a source
Dim_W_QTR_D_Earned_Premium that does not join to any fact source.


BUSINESS MODEL Core:
[39057] There are physical tables mapped in Logical Table Source
""Core"."Dim - GL Revenue Details"."Fact_W_GL_REVN_F_GLJournalID""
that are not used in any column mappings or expressions.



This is an improvement? Less functionality along with a delivered
product loaded with warning messages?

[Adrian Ward]

Doug

These issues show there is something not quite right about the modelling in your rpd.

Message 1,2 and 3 relate to problems in the dimensional modelling. If you are using content levels then check that these are all resolving properly. If they do not resolve when you check them in the Admin tool then they will probably fail during run time. If you are not using content levels then it looks like now is the time to start!

The final message is quite common, and also annoying. In previous versions you were able to have an LTS that was not being used, but this version gives you a warning about them.

As a last resort, You could try turning off the Warnings!

Adrian

[Doug Ross]

Adrian,

Maybe I wasn't clear - the warnings I listed above are from the
delivered 7.9.6.3 RPD for the Oracle
HR and Financials module of the BI Applications. I haven't touched
the RPD yet. I am somewhat
surprised that Oracle would deliver an RPD with 167 warnings. So
turning off warnings doesn't
help much because then I would not see any warnings that may occur
from any customizations
I do.

At a minimum, Oracle should explain how to resolve all these warnings
in the delivered RPD.
At best, they should have resolved the RPD warnings before shipping
the product.

[Kris Abburu]

Hi Doug,

11.1.1.5 comes with OBIA 7.9.6.3 and it does not require any upgrade.

However, it goes with Informatica 9.0 (and not to mention it requires weblogic to be running (including the node manager (strange..)) when you install it).

You can upgrade OBIEE from 11.1.1.3. to 11.1.1.5. I followed steps from Mark and it was a breeze.

 

Thanks,

Kris

 

---

From: Doug Ross <doug...@yahoo.com>
To: OBIEE Enterprise Methodology Group <obiee-enterpri...@googlegroups.com>
Sent: Fri, June 10, 2011 7:58:07 AM
Subject: [OBIEE EMG] Re: Oracle BI Apps 7.9.6.x with OBIEE 11g

--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
obiee-enterpri...@googlegroups.com
To unsubscribe from this group, send email to

obiee-enterprise-methodology+unsub...@googlegroups.com

[Kevin McGinley]

Kris,

Doug is referring to the warnings that still show up on a clean install of 7.9.6.3/11.1.1.5 - not an upgrade.  Despite those two versions being certified, warnings still appear in the RPD.  I agree that this is a little odd, as the whole point of waiting for 7.9.6.3/11.1.1.5 was not to have any consistency issues in the RPD, so I was surprised to see them as well.  However, they appear to be inconsequential, and Oracle has said there is a way to "hide" the warnings through the use of a special file in the repository folder.  I don't know the exact steps to take off-hand, but can probably dig them up.

Kevin

[Doug Ross]

Kris,

I am running 11.1.1.5.

My issue is with the RPD that comes with the 11.1.1.5 / 7.9.6.3 BI
applications.

As it is delivered OUT OF THE BOX, there are 167 warnings in the RPD.
This is the original,
uncustomized 7.9.6.3 RPD. All I did was open the RPD up after
installing 7.9.6.3 (with 11.1.1.5)
and ran a consistency check.

Are you saying that you have installed 7.9.6.3 and run a clean
consistency check on an uncustomized
RPD?

-dr

On Jun 10, 12:37 pm, Kris Abburu <abburuk...@yahoo.com> wrote:
> Hi Doug,
> 11.1.1.5 comes with OBIA 7.9.6.3 and it does not require any upgrade.
> However, it goes with Informatica 9.0 (and not to mention it requires weblogic
> to be running (including the node manager (strange..)) when you install it).
> You can upgrade OBIEE from 11.1.1.3. to 11.1.1.5. I followed steps from Mark and
> it was a breeze.
>
> Thanks,
> Kris
>
>  
>
> ________________________________

> From: Doug Ross <dougr...@yahoo.com>

> To: OBIEE Enterprise Methodology Group
> <obiee-enterpri...@googlegroups.com>
> Sent: Fri, June 10, 2011 7:58:07 AM
> Subject: [OBIEE EMG] Re: Oracle BI Apps 7.9.6.x with OBIEE 11g
>
> Adrian,
>
> Maybe I wasn't clear - the warnings I listed above are from the
> delivered 7.9.6.3 RPD for the Oracle
> HR and Financials module of the BI Applications.  I haven't touched
> the RPD yet.  I am somewhat
> surprised that Oracle would deliver an RPD with 167 warnings.    So
> turning off warnings doesn't
> help much because then I would not see any warnings that may occur
> from any customizations
> I do.
>
> At a minimum, Oracle should explain how to resolve all these warnings
> in the delivered RPD.
> At best, they should have resolved the RPD warnings before shipping
> the product.
>
> --
> You received this message because you are subscribed to the Google
> Groups "OBIEE Enterprise Methodology Group" group.
> To post to this group, send email to
> obiee-enterpri...@googlegroups.com
> To unsubscribe from this group, send email to

> obiee-enterprise-met...@googlegroups.com
> For more options, visit this group athttp://groups.google.com/group/obiee-enterprise-methodology?hl=en

[Kris]

Doug&Kevin
My bad.I did not pay attention to the
Version 7.9.6.3 from Doug's email.I did not run the consistency check after install.
It looks like Oracle expects us to clean up the warnings.

Kris

Sent from my iPhone

[Sergi]

I was trying to deploy App catalog and rpd to OBI .5 version and when
bouncing BI System components Presentation and BI Server don't go up.

Does anyone know if this is a matter of resources? Or it is probably a
problem of files corruption?

Checking Oracle app guide says that 8gb of ram are required!

ideas?

[Dila]

Sergi, if the db is on the same box at least 8gb of ram is required,
if the db is not on the same box, then you would need at least 6gb.

As far as the BIApps warnings for the out-of-the-box rpd, I was in a
class by Oracle where they told me, they might have a patch created to
suppress those warnings at some point....

Thanks.

Dila

[Jeff McQuigg]

So for those of you that have tried upgrading the OBI portion to
11.1.1.5 from an older BI Apps (pre 7.9.6.3), how did it go? Can it
be treated like any other upgrade? Have the Authorization/Security
issues been resolved? Are any of the items Venkat posted up to
resolved?

Thanks,
Jeff M.

[Kevin McGinley]

It depends on your authorization/security model, and what other security-related things you may be doing with Oracle and 3rd party vendor products.  A vague response, I know, but sadly there are things that work fine and there are gotchas.  You cannot say in a blanket fashion that all BI Apps security that worked in 10g works in 11g, but that's true of the 10g/11g platform in general.  We are still in case-by-case basis mode.

[Naeem Akhtar]

Hi,

I have OBIA 7963 with OBIEE 11.1.1.6

Can I update OBIEE to 11.1.1.7.1?

BR

Naeem Akhtar

[Vijay]

You can..

Sent from my iPhone

--

--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
obiee-enterpri...@googlegroups.com
To unsubscribe from this group, send email to
obiee-enterprise-met...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
 
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).
 

---

You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.

To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-met...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Shyam Varan Nath]

you are better off using 7.9.6.4. Changes in 7963 and 7964 are minimal.

[Aål•k]

you should be able to:

--

--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
obiee-enterpri...@googlegroups.com
To unsubscribe from this group, send email to
obiee-enterprise-met...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
 
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).
 

---

You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.

[joni lie]

Hi all,

Anyone have implement BIapps for financial and HR module?Does anyone have security/responsibility matrix template for BIapps?

Thanks

Joni