OBIA Upgrade Directions

207 views
Skip to first unread message

Naeem Akhtar

unread,
Mar 27, 2018, 2:29:52 PM3/27/18
to OBIEE Enterprise Methodology Group
Hello All,

We are currently using OBIA 11.1.1.8.1 PB-6 with some customization in ODI.

We are looking to upgrade to latest version of OBIA (which is 11.1.1.10.2 as of now) along OBIEE 12c and Database 12c.

As per Oracle documentation below is the upgrade patch.

OBIA 11.1.1.8.1 - PB6 --> OBIA 11.1.1.9.2 --> OBIA 11.1.1.10.1 --> OBIA 11.1.1.10.2
OBIEE 11.1.1.x to OBIEE 12.x is Outplace upgrade.
Database 11g to 12c upgrade is possible.

Above upgrade patch seems to be very hectic exercises and we may stuck in certain areas.

I was just thinking to have fresh install of OBIA 11.1.1.10.2 and follow below procedure which looks technically feasible to me.

1. Migrate BIACM configuration from OBIA 11.1.1.8.1 to OBIA through migration utility (never tested)
2. Migrate Security, RPD, Catalog using migration assistant. (OBIEE way)
3. Migrate custom components of ODI to new version.

Please provide your expert opinion on both the approaches which will be convenient and efficient to follow.

Thanks in advance.

Regards
Naeem Akhtar

Naeem Akhtar

unread,
Mar 27, 2018, 4:58:59 PM3/27/18
to obiee-enterpri...@googlegroups.com

Kris Abburu

unread,
Mar 27, 2018, 4:58:59 PM3/27/18
to obiee-enterpri...@googlegroups.com
1 )and 3 )works and I have done it.you might run into a small glitch on migrating setup data in 1 as you may not find certain content in biacm 11.1.1.10.2 , that you had in 11.1.1.8.1. 
I do not remember exactly what it is but it can be fixed .
For 3), unless you want to use the new columns from the fact tables, that got added in 11.1.1.10.2 , you should be good
For 2)you have to use the the jar/bar approach oracle recommends when migrating from 11g to 12c.


Sent from Yahoo Mail for 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
To unsubscribe from this group, send email to
obiee-enterprise-methodology+unsub...@googlegroups.com
For more options, visit this group at

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-methodology+unsub...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Parameshwaran Venkataraman

unread,
Mar 27, 2018, 4:58:59 PM3/27/18
to obiee-enterpri...@googlegroups.com
you may need to consider two things when you handle upgrades:

- What is the upgrade path for lower environments and if you do fresh install, does that mean you will have parallel lower environment builds? 
- Since you may do it differently compared to what oracle prescribes, does oracle certifies you upgrade path? and accept support?

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-enterprise-methodology@googlegroups.com

Naeem Akhtar

unread,
Mar 27, 2018, 5:22:10 PM3/27/18
to obiee-enterpri...@googlegroups.com
Hi Kris,

Thanks for your email.

Regarding point 3, New columns in the fact will have impact if that particular Fact is customized and was copied in custom folder with newly generated scenario. Correct?

Any other watch out?

Regards
Naeem

To unsubscribe from this group, send email to
obiee-enterprise-methodology+unsubs...@googlegroups.com
For more options, visit this group at

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-methodology+unsubs...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
--
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-enterprise-methodology@googlegroups.com

Kris Abburu

unread,
Mar 27, 2018, 5:37:57 PM3/27/18
to obiee-enterpri...@googlegroups.com

If I am thinking right, In the model you will have the columns from 
Customization. But in the backend db you will have the new columns but they will have nulls..

Is that what your question is?
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-methodology+u nsubs...@googlegroups.com.
For more options, visit https://groups.google.com/d/ optout.

--
--
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-enterprise-methodology@ googlegroups.com
To unsubscribe from this group, send email to
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-methodology+ unsub...@googlegroups.com.

For more options, visit https://groups.google.com/d/ optout.

--
--
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

To unsubscribe from this group, send email to

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.

Naeem Akhtar

unread,
Mar 28, 2018, 2:26:21 PM3/28/18
to obiee-enterpri...@googlegroups.com
Got you, this is not a big deal. 

Wanted to see how to cook big fish. few things here and there are okay unless no big issue arise later in the process.

Regards

On Wed, Mar 28, 2018 at 12:37 AM, 'Kris Abburu' via OBIEE Enterprise Methodology Group <obiee-enterpri...@googlegroups.com> wrote:

If I am thinking right, In the model you will have the columns from 
Customization. But in the backend db you will have the new columns but they will have nulls..

Is that what your question is?


Sent from Yahoo Mail for iPhone

On Tuesday, March 27, 2018, 4:20 PM, Naeem Akhtar <naeemak...@gmail.com> wrote:

Hi Kris,

Thanks for your email.

Regarding point 3, New columns in the fact will have impact if that particular Fact is customized and was copied in custom folder with newly generated scenario. Correct?

Any other watch out?

Regards
Naeem

To unsubscribe from this group, send email to

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-methodology+unsub...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
--
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-enterprise-methodology@googlegroups.com
To unsubscribe from this group, send email to
obiee-enterprise-methodology+unsub...@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-methodology+unsub...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages