SAP Analysis for office: Creating a panel to hide/show keyfigures.
I have a requirement which I am not sure how to implement and was wondering if I can get any help.
I have several queries in the same workbook that has some hidden key figures (can be shown) , sometimes similar.
My requirement is to build some kind of component where the user can select which key figures to show(can choose several at a time).
In analyser this can be done through a check box group. The user gets a list where he can select and then the check box group component can be associated with several dataproviders.
Since check box group component is a bex analyser component, is there an alternative way to do this is Analysis? I know this can be done from the display panel in analysis but I am not sure the end user will have access and the requirement is to have a list of check boxes and a submit button that will trigger the action of hidding/showing those key figures.
Do anybody have an idea how to do this in analysis?