Filter objects that have been added to template by object prompt

[IFK]

Hi,

I have the following problem.

We populate a template with a set of metrics, choosen by the user via a object prompt.

Then we would like to prompt the user to filter on the selected metrics.

Any idea?

Thanks a lot!

-Ingo

 

[reisw]

We have been wanting to do something very similar for a long time but as far as I know there is no way to do that. Anyone else no of a way?

 

[spod]

I'm assuming you want to prompt the user for metric value greater than their input? As a metric can't reference itself with a prompted filter in its conditionality you'll need to do something like....

Duplicate the metrics you want the user to select from into a separate folder. So you would for example have sum(sales) metric in two places (both named the same).

For the duplicated metric(s) you want to prompt the user on, create filters based off the orginal metric(s).

eg:

Sum(sales) (from duplicated folder) with Condition of F1.

F1 is prompt on sum(sales) metric (from original folder).

 

[IFK]

Hello spod

thank you for the answer, but I think that is not the solution to my problem.

The problem is basically that I don't know what metrics I need a value prompt for, since I don't know which metrics the user will put on the template.

Therefore whenever the user puts a metric on the template, by means of an object prompt, I need also a value prompt for this metric.

I hope that this explaines my problem better.

Thanks

 

[spod]

Ah then you'll probably need to see if there is a new ESP version of the product then

 

[nlim]

the problem is that MSTR cannot resolve multiple selections dynamically, especially if a user might choose not to filter on the metrics. You have this option, and others I may not have thought about yet.

1) fix the number of metrics on the report. Say 2.
2) create a metric prompt called p1, and a filter that depends on it called f1. Make sure you set that p1 can only have one selection. Repeat for the second metric p2 and f2.
3) place p1 and p2 on template, f1 and f2 on the filter.

only problem is that the user might choose the same metric for both prompts....sigh. MSTR should really put some vb scripting on their reports...