If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Use vs Display Values in FM Prompt Macro

Started by cdallum, 15 Mar 2010 10:26:43 AM

Previous topic - Next topic

cdallum

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.

TimNelson24

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

MMcBride

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))')#