Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Prompt in Metrics and Template

Status
Not open for further replies.

petperson

Programmer
Oct 2, 2002
106
US
I have a report with 3 metrics. Metric A has prompt A in it which allows the user to select a beginning date range. Metric A has Week Dt dimensionality with Beginning Fact. Metric B has Prompt B that allows the user to select an ending date range. Metric B has Week Dt dimensionality with Ending Fact. I need to be able to use a Report Filter that says Prompt A between Prompt B so that Metric C (and other metrics) will also be using the date range the user selected. I cannot seem to build the condition that allows me to use Prompt A with the 'between' operator and Prompt B. I'm thinking there must be some way with using an ApplySimple statement, but not sure on how to do this. Any help is appreciated.

P.P.
 
an applycomparison in the filter used in Metric C's condition as:
applyComparison("#0 between #1 and #2", attribute@id,?promptA, ?promptB)

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top