Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have came across a requirement which is described below:
User want to pass the parameters in to a store procedure and then run the store procedure to get the data (on the basis of parameters we passed in to SP). This functionality should be available to all the users accessing the application through theer web browsers??
Thanks in Advance.
Regards
Lalit Chaudhary
I would query why you have this requirement.
QlikView stores all data in its own data store, upon opening an application the Server loads the QVW into RAM. It does not then query the original data source. The performance when reading from RAM far surpases querying from the data source.
If you need to do something along these lines you would most likely have to create an extension object.
Alternatively, if you can query a single table I would direct you to Direct Discovery functionality.
Clint
To be able to do similar, you have to look for EDX or macro solution I believe. See: