Skip to Content
Author's profile photo Venkata Subhash Medisetty

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

Assigned Tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Saints Zhang
      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

      Author's profile photo Venkata Subhash Babu M
      Venkata Subhash Babu M
      Blog 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

      Author's profile photo Saints Zhang
      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.

      Author's profile photo Venkata Subhash Babu M
      Venkata Subhash Babu M
      Blog 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

      Author's profile photo Saints Zhang
      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

      Author's profile photo Venkata Subhash Babu M
      Venkata Subhash Babu M
      Blog 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

      Author's profile photo Saints Zhang
      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

      Author's profile photo Saints Zhang
      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

      Author's profile photo Venkata Subhash Babu M
      Venkata Subhash Babu M
      Blog Post Author

      That's good news to hear 🙂

      you might have missed to see  the version AO Version : 1.4.10.3295 which I mentioned in post 😳

      Good that you figured it out