Skip to Content
Sep 14, 2010 at 10:50 AM

Export to Excel in WAD with static, dynamic filters and variables



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.

Please help.

Thanks & Regards,