phishman00
MIS
I come from the Cognos world and am just beginning in BO. Although I have seen responses that almost answer my question, I must be missing something. In Cognos, I am able to easily store a user's input into an object that I can reference throughout the query in the where clause simply by inserting the name of the object.
In my BO universe I have a plethora of objects that I only want to retrieve data for if the corresponding date field on the row is between two user inputs (start date and end date).
How do I store a user input into an object that can be used in the where criteria for other objects? I want to prompt the user to enter this start date and end date only once. After they enter the data, I want sales transactions that occured between that range AND the number of closed jobs that occured between that range. How can I achieve this without entering @prompt a gazillion times? Will the @variable function achieve this? I haven't been able to successfully parse an @variable function yet, so I am obviously not using it correctly, however the documentation is skimpy as it relates to the @ functions.
I have tried to exclude any database fields and simply using @prompt('Enter A Start Date','D',,,,) in the select box but I can't reference the object for other objects and it doesn't want to parse.
Any help is greatly appreciated.
In my BO universe I have a plethora of objects that I only want to retrieve data for if the corresponding date field on the row is between two user inputs (start date and end date).
How do I store a user input into an object that can be used in the where criteria for other objects? I want to prompt the user to enter this start date and end date only once. After they enter the data, I want sales transactions that occured between that range AND the number of closed jobs that occured between that range. How can I achieve this without entering @prompt a gazillion times? Will the @variable function achieve this? I haven't been able to successfully parse an @variable function yet, so I am obviously not using it correctly, however the documentation is skimpy as it relates to the @ functions.
I have tried to exclude any database fields and simply using @prompt('Enter A Start Date','D',,,,) in the select box but I can't reference the object for other objects and it doesn't want to parse.
Any help is greatly appreciated.