Business Query

Hey all -
I am a bit new to Analysis. I am familiar with the idea of using an Excel plug-in to pull data from a BEx query and display it in Excel. Here is my question, lets say I want to create a structure for a report and then deploy it so other users can log in and refresh, similar to how I would for Webi or Crystal, I define the metadata or structure and then have prompts that someone comes in, fills in and refreshes to either print, drill down, etc.

Can I do similar with Analysis? It seems like I would save the Excel sheet with the data in it and then ask someone to refresh but we do not want that…Any help is appreciated!!!

anhy123 (BOB member since 2020-05-12)