Dashboard BI4.1 SP1 can use BEx Variable connect to spreadsheet
As BI4.1 SP1 Dashboard already Generally Available and one of the new feature come with Dashboard is the ability to use BEx Variable and connect it to spreadsheet.
It’s a nice feature as BEx Query Prompt is not compatible for mobile yet. So the workaround we can use Combo Box component to trigger BEx Variable that link to cell in MS Excel spreadsheet.
Here is the screenshot :
But since the prompt is cascading or have dependency to other variable so only first variable can connect to spreadsheet. Fortunately SAP Notes come in to help 1830605 so go to CMC – Servers – right click Dashboard Processing Services and choose properties and add DguessDependencies=false to JAVA VM Child Arguments.
With this all of your BEx variable can be assign to spreadsheet and assign it to combo box… you’re good to go for Dashboard Mobile.