Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
building dataset based on another dataset
Migrateduser
<p>Hello,</p><p> </p><p>I have a dataset. I now want to build another dataset based on the first dataset (as if the first dataset was a data source). Is this possible? Can it be done in scripting? If so, what would the script look like?</p><p> </p><p>If this is not possible, maybe I can do this in a single dataset with a more complex query. The query I currently have for the first dataset is as follows:</p><p> </p><p>{call MyStoredProcedure(?,?)} <-- where the first ? is an input parameter and the second ? is an output parameter (SYS_REFCURSOR in the stored procedure).</p><p> </p><p>What would a simple select statement look like if it drew from the results of this stored procedure call?</p><p> </p><p>Thanks for all forthcoming help.</p>
Find more posts tagged with
Comments
There are no comments yet