Dynamic Application Name in OLEDB/ODC Connection String

I have several (more than 100) Excel reports (files) that use the same data connection file. The data connection file connects to SSAS 2012 Tabular Model.

From the SQL Profile data, I would like to know the name of the Excel report file the connection is coming from. I was hoping to use the Application Name property of the connection string.

However, looks like Application Name property accepts only constants / fixed text. Is there a way to pass Application Name dynamically? I tried using &[File] - like we use in Headers and Footers in Excel. But the profile data just logs "&[File]" in the Application Name column. Any easier way to capture file name/path.

I do not want to use VBA. That would require modifying all Excel copies. I am hoping to make a change in the data connection file (within the connection string) so all Excel files would log dynamic Application Names automatically.

Thanks in advance for your help.

edit delete
are you sure?
asked Ansh G

0 answers

Post an answer but please log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions