Skip to Content

Hello colleagues,

I’d like to continue the topic of my colleague @maksim.alyapyshev on «How to create Fiori Tile opening Analysis for Office for Analytical query» focusing on how to create a jump from WorkFlow to workbook in Analysis with passing the variables.

It’s a simple task, but if you never worked with old SAP BI-IP STS, it will take some time to find a right solution.

Step by step guide:

  1. Create a copy from standard class CL_RSAO_LAUNCHER_HTTP_HANDLER and add a couple lines of code:
    data:
    l_t_variables type raso_t_launch_var,
    l_s_variables like line of  l_t_variables.
    
    …
     when others.
           clear l_s_variables.
            l_s_variables-value = l_s_form-value. "Value
            l_s_variables-name = l_s_form-name. " Technical variable
            l_s_variables-data_source = l_s_form-name. " Alias
            append l_s_variables to l_t_variables.
     endcase.
    
  2. Go to tr. Sicf and create a copy of standard BSP app analysis:
  3. Now we need to create URL (this step was described in detail by @maksim.alyapyshev). In our case link looks like: http://<server>:<port>/sap/bw/zalalysis?SAP-CLIENT=<client>OBJECT_ID=<WB_technical_name>&OBJECT_TYPE=WBID&APPLICATION=EXCEL&<technical_name_of_variable>=[ver]&<technical_name_of_variable>=[year]&LANGUAGE=RU
  4. We have CDS view (head of document), where user can choose several parameters, such as   Version of budget planning, year, company code etc. with a link to open workbook in Analysis.
  5. We created a custom characteristic for a storage link:
  6. Replace blanks to value of parameters in CDS-view:
…
  @ObjectModel.readOnly:true
      cast ( replace( replace(  replace( replace( _anaapp.url,  '[id]', corrid ), '[ver]', docversion ) , '[year]', gjahr ) , '[bukrs]', bukrs )
       as zebpc_url  )          as detailsurl
…

 

I would like to thank my colleague Alexey Goncharov, without whom this article would not have been possible.

Thank you for attention!

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply