Oracle Analytics Cloud and Server

Prompts, Top Parents by X and Top Parents by Metric

Question
1
Views
0
Comments

I have a requirement to create 2 prompts,


Top Parents by X

Allows users to select the number of Top (10, 25, 50, 75, 100, 200, 250) Parent Customers as they are ranked by metrics as identified in separate filter.

AND

Top Parents by Metric

Allows users to select the metric used to identify Top Parents by that specific metric (Fact1, Fact2, and Fact3). This filter works in conjunction with the “Top Parents by X” filter.


Filter requirements include implementing two filters that will assist the business in sorting the Top Parent Customers by the specified metrics in the report. These filters are the “Top Parents by (to be filled in via selection)” and “Top Parents Metric”.


Besides these 2 prompts I have other prompts also.  I have tried Top N and it seems not to work with multiple facts.