In Financial Reporting (FR) Reports, The Pov Selections Are Defaulting To Wrong Selections With Multiple Grids (Doc ID 2143578.1)

Last updated on JUNE 07, 2016

Applies to:

Hyperion BI+ - Version 11.1.2.3.700 and later
Information in this document applies to any platform.

Symptoms

In Financial Reporting (FR) Reports sometime the report contains two grids, which each has it is own DB connection. i.e. Tow grids for covering Essbase & HFM sharing the same scenario dimension names (Actual, ActBud, Budget & WrokBud) over the two DBs. Though when running the report having Essbase & HFM POV is configured to use any of these four (i.e. WorkBud --> Essbase & ActuBud --> HFM), the report directly comes with ActBud for both Essbase and HFM

Scenario1:
ActBd --> HFM
WorkBud-> Essbase (in the report Essbase get changed to ActBud).

Scenario 2:
WorkBud --> HFM
ActBud->Essbase (in the report Essbase get changed to WorkBud)

So it looks like the Essbase scenario gets changed to what soever set for HFM.

- FRLogging.log
----------------------
2016-02-25T12:15:10.233-05:00] [FinancialReporting0] [WARNING] [] @ [oracle.EPMFR.waa] [tid: [ACTIVE].ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid:
00iYn6RfVbkFw00Fzzw0w00002iS000_rL,0:1] [APP: FINANCIALREPORTING#11.1.2.0] @ [URI: /hr/modules/com/hyperion/reporting/web/waa/web/hr/HRWaaBase.jsp] [SRC_CLASS: com.hyperion.waa.utility.olap.WAAHRMemberTree] [SRC_METHOD:
getAliasTableNames] [1106] Error: Class component property name invalid[AliasTable]
[2016-02-25T12:15:10.233-05:00] [FinancialReporting0] [WARNING] [] [oracle.EPMFR.waa] [tid: [ACTIVE].ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid:
00iYn6RfVbkFw00Fzzw0w00002iS000_rL,0:1] [APP: FINANCIALREPORTING#11.1.2.0] [URI: /hr/modules/com/hyperion/reporting/web/waa/web/hr/HRWaaBase.jsp] [SRC_CLASS: com.hyperion.waa.utility.olap.WAAHRMemberTree] [SRC_METHOD: getAliasTableNames] [1106] Error: Class component property name invalid[AliasTable]
[2016-02-25T12:15:10.234-05:00] [FinancialReporting0] [WARNING] [] [oracle.EPMFR.waa] [tid: [ACTIVE].ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 00iYn6RfVbkFw00Fzzw0w00002iS000_rL,0:1] [APP: FINANCIALREPORTING#11.1.2.0] [URI: /hr/modules/com/hyperion/reporting/web/waa/web/hr/HRWaaBase.jsp] [SRC_CLASS: com.hyperion.waa.utility.olap.WAAHRMemberTree] [SRC_METHOD: getAliasTableNames] [1106] Error: Class component  property name invalid[AliasTable]
[2016-02-25T12:01:06.152-05:00] [FinancialReporting0] [NOTIFICATION] [] [oracle.EPMFR.performance] [tid: [ACTIVE].ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 00iYn5dNbGXFw00Fzzw0w00002iS000_Ma,0:1] [APP: FINANCIALREPORTING#11.1.2.0] [URI: /hr/modules/com/hyperion/reporting/web/reportViewer/HRHtmlReport.jsp] [SRC_CLASS: com.hyperion.reporting.util.HRLogTimer] [SRC_METHOD: startJob]
[2016-02-25T12:01:06.152-05:00] [FinancialReporting0] [NOTIFICATION] [00069] [oracle.EPMFR.performance] [tid: [ACTIVE].ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 00iYn5dNbGXFw00Fzzw0w00002iS000_Ma,0:1] [APP: FINANCIALREPORTING#11.1.2.0] [URI: /hr/modules/com/hyperion/reporting/web/reportViewer/HRHtmlReport.jsp] [SRC_CLASS: com.hyperion.reporting.util.HRLogTimer] [SRC_METHOD: startJob] START: JobId: 424; User: mountzb; Name: /Brittany test reports/Testing report
[2016-02-25T12:01:06.152-05:00] [FinancialReporting0] [NOTIFICATION] [] [oracle.EPMFR.performance] [tid: [ACTIVE].ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 00iYn5dNbGXFw00Fzzw0w00002iS000_Ma,0:1] [APP: FINANCIALREPORTING#11.1.2.0] [URI: /hr/modules/com/hyperion/reporting/web/reportViewer/HRHtmlReport.jsp]
[SRC_CLASS: com.hyperion.reporting.util.HRLogTimer] [SRC_METHOD: startJob]
[2016-02-25T12:06:21.575-05:00] [FinancialReporting0] [NOTIFICATION] [] [oracle.EPMFR.performance] [tid: Thread-51] [userId: <anonymous>] [ecid: 00iYmjF40lJFw00Fzzw0w00002iS000Pnm,0:1:1:1] [APP: FINANCIALREPORTING#11.1.2.0] [URI: /workspace/logon] [SRC_CLASS: com.hyperion.reporting.util.HRLogTimer] [SRC_METHOD: endJobSummary] REPORT: [Start:022516 12:06:21.526-0500][End:022516 12:06:21.575-0500][Elapsed:0.049][Host:esihyprptp][JobId:426][User:mountzb][Na  me:/Brittany test reports/Testing report][InBook:false][UserPOV:{ dsname=EssBase server=EssbaseCluster-1 app=ESIPLAN db=Budfcst type=Essbase metadata={Period=MAR,Year=FY15,Scenario=ActBud}}{ dsname=ENERSYSPRD server=HFMPROD app=ENERSYSPRD db=ENERSYSPRD type=FinancialManagement metadata={Scenario=ActBud,Year=2015,Period=MAR}}]

The logs shows ActBud for both EssBase & ENERSYSPRD connections, while it should look as the following:
- ActBud for ENERSYSPRD
- Fc_Feb for EssBase

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms