Analysis Office Launching Workbooks from BIP with variables

Since Analysis Office 2.6 you are able to launch workbooks from BIP with variables. The biggest problem is to have a BI Platform 4.2 SP5 and time to test this feature. In case of writing an updated version of Analysis Office - The Comprehensive Guide, I now have a BI Platform which fulfilled the conditions. According to SAP slides, the command looks like this:

&var[<data source alias>]<variable>=<value>

So I saved a workbook to my BI Platform and looked how it works. Here is my example where I pass the value of 0CALMONTH.

iDocID=AebeSHZuOw5OicAkEHH47Ws&var[DS_1]CALMONTH=01.2017

With this the workbook is launched with the variable value January 2017. Another example with a range of 0CALMONTH.

iDocID=AebeSHZuOw5OicAkEHH47Ws&var[DS_1]CALMONTH=01.2017 - 03.2017

With this the workbook is launched with the range of January 2017 to March 2017. And here another example with two variables.

iDocID=AebeSHZuOw5OicAkEHH47Ws&var[DS_1]CALMONTH=01.2017 - 03.2017&var[DS_1]ZCOMN=8553780486

With this the data source is restricted from January 2017 to March 2017 and the commission number 8553780486. It is a cool feature but you definitely Single-Sign-On because without SSO it doesn't make fun.

author.


I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.

Analysis Office - The Comprehensive Guide 3rd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.6 and contains 272 Pages.
49,99 €
Analysis Office - The Comprehensive Guide 2nd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.4 and contains 243 pages.
39,99 €
Analysis Office - The Comprehensive Guide
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.3 and contains 227 Pages.
9,99 €

Write a comment

Comments: 0