Skip to Content

Sample video scheduling AO Document with prompts

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

9 Comments
You must be Logged on to comment or reply to a post.
  • 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

    • 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

      • 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.

        • 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

          • 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

          • 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

          • 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

          • 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