I have a CDS View on HANA that I would like to pass parameters to. When it doesn't have the parameters, I am able to see it in Tableau. When I add parameters, I can no longer see it from Tableau. I know that it changes the type from a View to a Procedure at the database level, but we haven't been able to find a way to configure access so that my user can access the procedure. Does anyone know what needs to be configured to allow me to see the procedure? I understand that I have to access it through Custom SQL once I have the parameters, but it gives me an error that it can't find the view.
Thanks!
I have found blogs that tell how to pass variables from Tableau to SAP HANA using a 'PLACEHOLDER'. Maybe stored procedures is not the correct term. When I add variables to my views in HANA, they are no longer considered 'views' at the DB level where the security is defined.
