OBI 11g->12c migration - pivot table with measure using MEDIAN agg rule not working

Karol Kanicki

Hi,

we have ongonig migration from 11G to 12C (see other issue there:   )

new issue  - report works well in 11G but not at 12C - just appeared.

We have a report, 8 dims, 3 metrics + some pivoting on top of that.  Some filters too. So, what I'm showing below is signifgicantly simplified version of the report, not base one, with most dims & 2 metrics removed. Criteria tab + filters:

pivot table view + error:

as soon as I remove 'country' column from analysis, report works.

Also works (without removing 'country') if I change aggregation rule for total row of 'Med Days' to none (which obviously gives no result) or any other (avg / max / whichever ), which obviously gives incorrect figure.

I think this may be a case for Oracle Support (seems to me like BI server issue), but I'll let you have a look first : )

If there's anything else that could be useful for you & I haven't posted, please let me know so I'll share.

cheers

Gianni Ceresa

Hi,
What exact OBIEE version you come from and which exact version you are moving to? (version + bundle patch)

Karol Kanicki

11G is:

11.1.1.7.150120 (Build 150113.1200 64-bit)

12C is:

12.2.1.4.0 (Build BIPS-20190627163935 64-bit)

Oracle DB to which both OBIs above are connected (it's one & same database) is:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

will post detailed patch information tomorrow

cheers

Karol Kanicki

11G patches:

>opatch lspatches

18996188;

20022695;

19825503;

19823874;

19822893;

19822857;

19822826;

16997936;

16913445;

17220944;

16569379;

***************************************************************************

*****12C below***********************

--------------------------------------------------------------------------------[OPSR-TIME] Loading cooked inventory[OPSR-MEMORY] : Loading cooked one offs. Heap memory used 224 (MB)[OPSR-MEMORY] : Loaded cooked oneoffs. Heap memory used : 77 (MB)[OPSR-TIME] Cooked inventory loaded successfullyLocal Machine Information::

Hostname: xxxxxxxxxxxxxxxxxxxx

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (3):

bi_platform                                                          12.2.1.4.0

OPatch                                                               13.9.4.2.0

WebLogic Server for FMW                                              12.2.1.3.0

There are 3 products installed in this Oracle Home.

Interim patches (7) :

Patch  30332998     : applied on Wed Nov 20 15:58:16 UTC 2019

Unique Patch ID:  23126829

Patch description:  "One-off"

   Created on 21 Sep 2019, 01:55:08 hrs PST8PDT

   Bugs fixed:

     27911783, 29502877

   This patch overlays patches:

     29640387

   This patch needs patches:

     29640387

   as prerequisites

Patch  30067211     : applied on Tue Nov 19 14:18:27 UTC 2019

Unique Patch ID:  23147523

Patch description:  "RDA release 19.4-20191008 for OFM"

   Created on 4 Oct 2019, 02:35:38 hrs PST8PDT

   Bugs fixed:

     30067211

   This patch overlays patches:

     30108739, 29639586, 29687335, 29348000, 28800895, 28352814, 27916236

     27287100, 26811086, 26330345, 25739794, 25351390, 24696555, 23723609

     22995690, 22783073, 22218552, 21652363, 21077584, 20603508, 20128084

     19545161, 18904462, 18297302, 17966756

Patch  29640387     : applied on Fri Oct 18 10:44:03 UTC 2019

Unique Patch ID:  22969150

Patch description:  "OBI BUNDLE PATCH 12.2.1.4.190716"

   Created on 30 Jun 2019, 22:32:38 hrs PST8PDT

   Bugs fixed:

     23341955, 26388934, 26585491, 26612853, 26908722, 26957199, 27002804

     27025200, 27137133, 27400370, 27480104, 27580645, 27658023, 27686911

     27766951, 27788081, 27839392, 28006490, 28043947, 28077156, 28079934

     28098124, 28143150, 28191058, 28215107, 28345094, 28447019, 28488603

     28542985, 28614686, 28627487, 28693601, 28722734, 28740457, 28747876

     28797734, 28885772, 28885971, 28886045, 28900868, 28990630, 29451655

Patch  26355633     : applied on Thu Oct 03 14:02:51 UTC 2019

Unique Patch ID:  21447583

Patch description:  "One-off"

   Created on 1 Aug 2017, 21:40:20 hrs UTC

   Bugs fixed:

     26355633

Patch  26287183     : applied on Thu Oct 03 14:02:38 UTC 2019

Unique Patch ID:  21447582

Patch description:  "One-off"

   Created on 1 Aug 2017, 21:41:27 hrs UTC

   Bugs fixed:

     26287183

Patch  26261906     : applied on Thu Oct 03 14:02:19 UTC 2019

Unique Patch ID:  21344506

Patch description:  "One-off"

   Created on 12 Jun 2017, 23:36:08 hrs UTC

   Bugs fixed:

     25559137, 25232931, 24811916

Patch  26051289     : applied on Thu Oct 03 14:02:11 UTC 2019

Unique Patch ID:  21455037

Patch description:  "One-off"

   Created on 31 Jul 2017, 22:11:57 hrs UTC

   Bugs fixed:

     26051289

opatch-external.jar is in /app/oracle/product/Oracle_Home/OPatch/jlib/opatch-external.jar--------------------------------------------------------

**********************************

cheers