Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBI 11g->12c migration - pivot table with measure using MEDIAN agg rule not working
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
Answers
-
Hi,
What exact OBIEE version you come from and which exact version you are moving to? (version + bundle patch)0 -
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
0 -
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
0
