14 Replies Latest reply: Feb 21, 2014 3:56 AM by Sh!va RSS

Oracle Hyperion Import/ Export Issue

1008747 Newbie
Currently Being Moderated

Dear All,

 

I am new in Oracle Hyperion and i am trying to create a new application

 

I am performing following Steps (please correct me if I am wrong at any place)


1) Take backup of complete Application of PROD through LCM
2) Create New Application On Test Instance
3)Import back up file through LCM. This is point where I am stuck since last week (I tried from different way, I mean I import complete application, then I tried partial import got again error on 'Account' Dimension and Custom Dimensions).

Error on Account Dimension:

/Global Artifacts/Common
Dimensions/Standard Dimensions
Account
Import failed for the following reason -
Rejecting Member Retirement Options.
Rejecting Member Impairment Option.
Rejecting Member Reason ended.Rejecting
Member Reason delayed.Rejecting Member
Asset Status.Rejecting Member Physical
Location.Rejecting Member Priority.
Rejecting Member Purchase Reason Code.
Rejecting Member UOM.Rejecting Member
Amortization Method.Rejecting Member
Funding Incidence.Rejecting Member Cash
Flow Incidence.Rejecting Member
Depreciation Convention.Rejecting
Member Depreciation Method.Rejecting
Member Does branch has signage.
Rejecting Member Transformer.Rejecting
Member Is generator located Inside/
Outside the branch.Rejecting Member
Generator Type (Petrol/ Diesel).
Rejecting Member Capacity of Generator
KVA.Rejecting Member Does Branch has
Generator?.Rejecting Member Owned/
Rented (Photo copiers).Rejecting Member
Rent Agreement Renewal Term.Rejecting
Member Rented/ Owned.Rejecting Member
Renovated/ Non Renovated.Rejecting
Member Rural/ Urban.Rejecting Member Is
on T24.Rejecting Member Branch Type..
Rejecting Member Branch/ Controlling
Office.Rejecting Member Authorized FX
Dealing.Rejecting Member Province.
Rejecting Member Designated Branch.
Rejecting Member Trade Branch.Rejecting
Member Clearing Branch.Rejecting Member
Lending Branch.Rejecting Member Banked/
Unbanked.Rejecting Member Cash Feeding
Branch.Rejecting Member High Volume.
Rejecting Member Branch Type.Rejecting
Member Janitorial Services Contract
Number.Rejecting Member Company Name.
Rejecting Member ATM Service Providers.
 

This Error I am facing on Account Dimension.

On Custom Dimension I am facing below mentioned error :

Cannot perform migration for Resource -
/Plan Type/Plan1/Calculation Manager
Rules/CRBG/CIBG Interest Income-CRBG.

Cannot perform migration. Unable to
find artifact resource in the source
application.

Cannot perform migration for Resource -
/Plan Type/Plan1/Calculation Manager
Rules/CRBG/CIBG Interest Income-CRBG TD.

Cannot perform migration for Resource -
/Plan Type/Plan1/Calculation Manager
Rules/CRBG/CIBG Interest Income-CRBG TD.

and Same Errors of 6 pages

 

I am using Hyperion Version 11.1.2.0 on Windows 2003 server 
, I even try 'outline.cmd' utility but got some error there too which is "Loaded Version of Essbase RTC: 0xb1200
[Fri Feb 14 16:27:05 GMT+05:00 2014]Unable to obtain dimension information and/o
r perform a data load: com.hyperion.planning.sql.HspMember cannot be cast to com
.hyperion.planning.sql.HspPMMember
Successfully logged into "Hyplive" application, Release 11.120, Adapter Interfac
e Version 5, Workforce supported and not enabled, CapEx supported and  enabled,
CSS Version 3
[Fri Feb 14 16:27:05 GMT+05:00 2014]Input file member load ordering option (/O s
witch) will not be performed: this option is not available for the "Dao" dimensi
on.
[Fri Feb 14 16:27:05 GMT+05:00 2014]Successfully opened export file " 

\Dao.csv"
.
[Fri Feb 14 16:27:05 GMT+05:00 2014]Unable to obtain dimension information and/o
r perform a data load: com.hyperion.planning.sql.HspMember cannot be cast to com
.hyperion.planning.sql.HspPMMember
[Fri Feb 14 16:27:05 GMT+05:00 2014]Examine the Essbase log files for status if
Essbase data was loaded.
[Fri Feb 14 16:27:05 GMT+05:00 2014]Planning Outline data store load process fin
ished with exceptions:  no output records were written due to errors; examine th
e log and exception files for more information. 0 export records were written.
[Fri Feb 14 16:27:05 GMT+05:00 2014]Unable to obtain dimension information and/o
r perform a data load: com.hyperion.planning.sql.HspMember cannot be cast to com
.hyperion.planning.sql.HspPMMember
[Fri Feb 14 16:27:05 GMT+05:00 2014]Planning Outline data store load process fin
ished with exceptions:  no output records were written due to errors; examine th
e log and exception files for more information. 0 export records were written.”

Kindly help me, I am in big trouble.


Regards,

Nauman Hameed Mirza

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points