Stored process with output a dataset

[DanieleTiles]

Hi to all,
we're working with Enterprise Guide 4.1, on a SAS EBI 9.1.3...in this version, unfortunately, it's still not possible to (at least) group by some variables when selecting an information, or to select from a prompt before...since we're talking of millions of rows, and the users want to be able to select just the object needed, we have been thinking about to make a simple stored process that prompts the user with some prompts, and then has got the dataset inside the project...possibly, in the work libname.
However, we haven't been able to do so...any idea how to do it? Has anyone approached this problem in any other way?
Thanks

Daniele

[Cynthia_sas]

Have you considered using a stored process linked to an information map in order to provide data to the information map??? When you couple this ability with the ability to put a predefined filter on an information map, this might come close to what you want to do.

cynthia

[DanieleTiles]

Hi Cynthia,
well...I've been thinking about it, but have found a bit of problems using a stored process linked to an information map in EG (in other words: it doesn't work smoothly as it does in Web Report Studio...it doesn't call the stored process before the information map in eg).

[Adrian_Mc]

Hi Daniele,

I'm not sure if I understand what you're trying to do, but I think it sounds similar to a problem we had in the past. Our solution was to develop an add-in for Enterprise Guide that let the user choose what information they want, in a hierarchical fashion. It depends on have some pre-existing tables, to make the search faster for the user. So for instance, the user might click on a button that lists all the production sites in our company, then the one(s) they choose is used as part of a filter when displaying the next type of info, which for us would be a list of the process flows running at that site. When the user selects some process flows, they get used in the next level of the filter and so on.
Finally when the user has specified everything they need to identify the type of data they want, they hit the 'Run' button and the data is retrieved. Sorry if this doesn't help.