View Standard Lookups via Sales Cloud BI
Summary
Is there a way to pull the standard lookup values with BI?Content
I'm trying to take one out of Ed Dewolf's playbook and use Smartview to update information from an analysis to a spreadsheet. I would like to create a means for updating support information in an Excel Lead Import Template workbook. I need to create several analyses that pull lists of values from Standard Lookups. Does anyone know if there is a way of doing this?
One specific example, when I add new trade show names to my Trade show lookup via Manage Standard Lookups, I would like to have an analysis on a worksheet that can be refreshed to show these new values. Doing this will allow me to not have to continually update and redistribute my template which uses Data Validation to make the process of receiving correct information from my users more efficient.