I am new to BI Web and I searched SDN for this requirement of displaying static, dynamic filters and variables along with Analysis web item in Excel sheet for Export to excel in BI 7.0.
I am having an InfoField web item with my Data Provider and List of Text elements to display as default. I put this web item with the export command of the Export to excel button in a button group.
When I am exporting the data, variables are coming in the excel sheet but not static/dynamic filters.
I tried configuring InfoField web item with specifying static/dynamic filters for the characteristic to be displayed along with variables. Still the result is the same as I am getting variables but not static/dynamic filters in excel sheet.
In export to PDF, it's as per standard settings with no web items explicitly added to export command and it is showing static/dynamic filter as well as variables. I also have a Filter Pane web item which displays there filters and variables.
I don't what's going wrong or what additionally is needed to be done to get static and dynamic filters along with variables in excel sheet.
Thanks & Regards,