I’ve recently joined an organisation that has previously carried out their MI reporting using SSRS by executing stored procedures which used parameters in SQL Server Management Studio and we are keen to explore whether Looker can be configured in a similar fashion to allow reporting to be “dynamic”.
My understanding is that a limitation of Looker is that it must be configured to look at models which are essentially static (or updated at specified intervals) and therefore the same applies to views too.
Is there a way to configure a “live” connection to a SQL Server Management Studio database?
Or must reporting be configured to take all data across in a looker view and then use downstream filtering etc in the visualisation stage to refine as required?
To give you an idea of where I’m going with this I’m trying to consider a future scenario whereby we can configure 15 minute refreshes to visualisations for end users to have running on their machine or wallboards throughout the working day…
Any help/advice would be greatly appreciated