5 Replies Latest reply: Jun 24, 2013 3:45 AM by Neeraj Lahoti-Oracle RSS

    Unable to open Financial Report using HFM as a database

    886499

      Hello team,

       

      We are  using 11.1.2.2 .

      We have Hyperion Essbase,HFM and Financial Reports. Our Financial reports are in 11.1.2.1.

      So we have exported all the reports from 11.1.2.1 to 11.1.2.2. We are able to open the Reports which are pointing to Essbase.

      When try to open the reports i am getting the error message as "ADM Error processing results from query: An unknown error has occurred in the HsvData object".

       

      Thanks,

      Raju

        • 1. Re: Unable to open Financial Report using HFM as a database
          KNA-Oracle

          What is the datasource that you are reporting against for reports that error with the ADM message?Is it HFM,essbase or planning?

          • 2. Re: Unable to open Financial Report using HFM as a database
            Vivek Chetiaparath

            Does this happen only to export/imported reports or even new reports you create from 11.1.2.2 FR studio?

             

            Thx

            • 3. Re: Unable to open Financial Report using HFM as a database
              Harishkumar Y-Oracle

              Hi Raju,

               

              Do you find any error messages in FR Logs as listed below :

               

              2013-03-05T09:23:57.941+01:00] [FinancialReporting0] [ERROR] [00019] [oracle.EPMFR.core] [tid: [ACTIVE].ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 0000Jotd_wK4epW5xzx0iW1HDO1P00005S,0] [SRC_CLASS: com.hyperion.reporting.designs.Design] [APP: FINANCIALREPORTING#11.1.2.0] [SRC_METHOD: fromXmlInternal] Cannot not find binary file: \\\Text1

               

              om.hyperion.reporting.util.HyperionReportException: ; nested exception is:

                javax.jcr.RepositoryException: Attribute @5c@5c@5cText21 does not exist.

                at com.hyperion.reporting.reportstore.ReportStoreObjectImpl.getAttribute(Unknown Source)

               

              Does any  FR report using " Offset -1" for columns or rows? Does the issue happens when in the columns, add Period Offset -1 is used ?

               

              Try this and let us know the details :

               

              Create a new FR and insert a grid. In the rows, add a single Custom 5 member ( HFM Source).  In the columns, add Period Offset -1.  Run the report on the first period (Jan) so that the offset crosses into a prior year. Check same error shows up.

               

              regards,

              Harish.

              • 4. Re: Unable to open Financial Report using HFM as a database
                KNA-Oracle

                You could be running into a potential issue at an ADM level,let us know specifics of when the error is seen

                • 5. Re: Unable to open Financial Report using HFM as a database
                  Neeraj Lahoti-Oracle

                  Try below and see what happens :

                   

                  1. login to workspace. Go to Explore screen.

                    2. In file menu select Export, and then select this FR report ( the one with the issue). Save it in local system

                    3. after its been exported, In File menu, select Import -> Financial reports , and then select the saved report.

                    4. when importing give it a new name. then run this imported report and then test the issue.

                   

                  ------------------------

                   

                  Also try with latest fr patch 11.1.2.2.304