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

    Oracle Hyperion Import/ Export Issue

    1008747

      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