When creating a prompt in Report Studio, I can set the use and display values separately, allowing me to display a description to the user but pass a code to the query. I'd like to do something similar in prompt macros in FM, providing a similar experience for users running Query Studio reports. Is this possible? If so, what is the syntax? I understand the basic syntax to be:
#prompt(ParameterName,Datatype,DefaultValue,PreText,Source,PostText)#
I set the source to a query subject item, but this appears to also be the value passed to the query.
Not 100% sure why you would want to use the Prompt Macro for the task you are describing
Have you thought of setting the Prompt Info Property in FW. It has a Use and Display setting that will let you do what you're looking for. Then take that attribute and put it a filter and your users can consume the prompt. The users will get displayed the DESC in QS, and you can filter on your id in the database.
The only time I would see using the prompt macro would be if you were creating a free form sql report in RS. In that case you would still use the standard display and use functionality on the PROMPT page.
Tim Nelson
Lead Architect
Office Depot
I have never used a Prompt Macro in Framework Manager so I am interested in seeing if you find an answer to this.
I use Prompt Macro's pretty heavy in 8.4 to replace my old 8.2 Javascript to pre-load date prompts against cube based data sources.
The below Prompt allows me to set the "Default Value" of a Date Prompt to the most recent Date.
#prompt('finishMonth','memberUniqueName','closingPeriod([Packagename].[Accounting Date].[Accounting Date].[Month], item(tail([packagename].[Accounting Date].[Accounting Date].[Year], 1), 0))')#