Query Info and BEx Variable selection in SAC Excel Add-In workbook

[tanisha_gupta20]

Hi All,

I am using SAC excel add-in and trying to connect to SAP BEx queries directly using tunnel live connection in SAC. If I look at the SAP functions available, I don't see anything to display following information in the workbook

Also, how does one display prompt (BEx query variable selection) values in SAC to display what user has selected to refresh the tables in the workbook.

Thanks

Regards

Tanisha

[tanisha_gupta20]

Found the answer:

⁠SAP.GETVARIABLES() to display BW variables selection and SAP.GETDIMENSIONFILTER() for table filters and ability to change the table filter values. 

There is no function to display query information and last login details though