Skip to Content

Hi All,

As many of you did not succeeded with Scheduling the workbook with prompt, Here I have created sample video(no audio), might helpful

AO Version : 1.4.10.3295

AO BIP ADD on : 1.4.10.3290

BIP Platform : 4.1 SP5

Sample scheduling of Analysis Office Document with Prompts – YouTube

I would recommend to see the blog for detailed level information

http://scn.sap.com/docs/DOC-60492

Best Regards,

Subhash

To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

  1. Saints Zhang

    Hello Subhash,

    The schedule of analysis workbook can be ran successfully from my side too.

    But the data of analysis workbook is not filtered according to the variable value I input in the prompts.

    Whatever the variable value is input, the system always sends the result of what I saved originally.

    This is the issue.

    Thanks for checking this issue from your side.

    Saints

    (0) 
    1. Venkata Subhash Medisetty Post author

      Hi Saints,

      in my case it filtered with the given value

      in that case inputs might be wrong

      variable name should give Technical name of the variable

      Member should give in KEY values

      Subhash

      (0) 
      1. Saints Zhang

        But I already input the technical name of the variables.

        I saved the analysis workbook with the following condition:

        AO_SCHEDULE.png

        I scheduled the analysis workbook with the prompts below:

        AO_PROMPT.png

        The schedule is showed successful, but the data is still ZFR3 instead of 7728.

        I think the prompt is never taken into account when the schedule is ran.

        (0) 
        1. Venkata Subhash Medisetty Post author

          Hi Saints,

          Under data source  :  you have given directly Query name, instead  give – DS_1

          Under variable : from above two screenshots you have given characteristic names, you should give variable technical names i.e. 0P_CALYE and 0s_COCD for second variable(from your selection in red)

          you may try now

          Subhash

          (0) 
          1. Saints Zhang

            Hello Subhash,

            If I put DS_1 as datasource, 0P_CALYE=2014, 0S_COCD=ZFR3

            The schedule failed. see the message below.

            BiPrecalculation called with first parameter: E:\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\logging\Analysis_Precalculation_bw_qry_mpr_ps004_0001_schedule_57487.log

            – Information: @@@@@ Precalculation Start. (SharedAddIn 2007 Build 1.4.10.3290 Main method) @@@@@ | 2015-01-29T14:07:20 | com.sap.ip.bi.pioneer.precalculation.PcMain.ProcessLogPath() ()

            – Error: Application Exception (ID 103042)

            Nested Exception. See inner exception for details below.

               at com.sap.ip.bi.pioneer.common.exceptions.CoNestedException.ThrowNestedException(Exception iInnerException, Object iExTag)

               at com.sap.ip.bi.pioneer.core.exceptions.CrExceptionHelper.ThrowRestartException(Exception iEx)

               at com.sap.ip.bi.pioneer.precalculation.views.EaViewManagerSession.OnProcessingFinished(Object iSender, CoProcessingFinishedEventArgs iEventArgs)

               at com.sap.ip.bi.pioneer.core.commands.CrCommandProcessor.OnProcessingFinished(CoCommandBase iCommand)

               at com.sap.ip.bi.pioneer.common.commands.CoCommandProcessor.CommandPostprocessing(CoCommandBase iCommand)

               at com.sap.ip.bi.pioneer.common.commands.CoCommandProcessor.InitialCommandExecute(CoCommandBase iCommand)

               at com.sap.ip.bi.pioneer.common.commands.CoCommandProcessor.DoExecuteCommandInternal(CoCommandParameters iParameters)

               at com.sap.ip.bi.pioneer.common.commands.CoCommandProcessor.DoExecuteCommand(CoCommandBase iCommand, CoCommandParameters iParameters)

               at com.sap.ip.bi.pioneer.core.commands.CrCommandProcessor.DoExecuteCommand(CoCommandBase iCommand, CoCommandParameters iParameters)

               at com.sap.ip.bi.pioneer.precalculation.PcProcessor.Process()

            >> General .NET Exception:

            Object reference not set to an instance of an object.

               at com.sap.ip.bi.pioneer.openxml.OxWorksheet.CreateCell(Row iRow, String iCellReference)

               at com.sap.ip.bi.pioneer.openxml.OxWorksheet.SetCells(UInt32 iRowIndex, UInt32 iColumnIndex, Object[,] iValues, String[,] iCellFormats, Object[,] iStyleNames, Object[,] iHAlignments, Object[,] iVAlignments, Boolean iCreateNewCells)

               at com.sap.ip.bi.pioneer.precalculation.xl.PcRange.SetValue2(Object iObject)

               at com.sap.ip.bi.pioneer.precalculation.views.grid.EaRenderStructure.RenderOpenXml()

               at com.sap.ip.bi.pioneer.precalculation.models.EaItemGrid.Render()

               at com.sap.ip.bi.pioneer.precalculation.models.EaItemGrid.Redisplay(IEaRedisplayHelper iRedisplayHelper)

               at com.sap.ip.bi.pioneer.precalculation.models.EaModelWbApplication.Redisplay(Object iSender, CoProcessingFinishedEventArgs iEventArgs)

               at com.sap.ip.bi.pioneer.precalculation.views.EaViewManagerSession.OnProcessingFinished(Object iSender, CoProcessingFinishedEventArgs iEventArgs)

              | 2015-01-29T14:07:33 | com.sap.ip.bi.pioneer.precalculation.PcProcessor.Process() ()

            – Error: Object reference not set to an instance of an object. | 2015-01-29T14:07:33 | com.sap.ip.bi.pioneer.precalculation.PcProcessor.Process() ()

            If I input directly the query technical name, and 0P_CALYE=2014, 0S_COCD=ZFR3

            The issue is same as previous post: the data is not filtered by prompts

            Saints

            (0) 
            1. Venkata Subhash Medisetty Post author

              oops unfortunately I am not expert in analyzing logs 🙁

              my last suggestion check DS_1 correct or not (I assume remaining variables & values sections are correct)

              How to check : go to original workbook ->Components tab see, does your query is DS_1 or not Capture.PNG

              if you still face error, I will suggest to open an incident

              (0) 
              1. Saints Zhang

                Hello Subhash,

                I can see DS_1 for my analysis workbook.

                But when I input DS_1 as the data source in the scheduling, it’s failed.

                And when I input technical query name,it succeeded, but the result is not refreshed according to the values I input for the variables.

                I will create an incident, thank you anyway.

                Saints

                (0) 
                1. Saints Zhang

                  Hello Subhash,

                  I find the reason why my schedule failed.

                  Because I updated  the old analysis workbook(not in SP10), and scheduled it again.

                  Now I try to create a new analysis workbook in AO SP10.1 and scheudle it in BI4 with prompts, it works as expected.

                  Thanks.

                  Saints

                  (0) 

Leave a Reply