Oracle Analytics and AI

3483987

Hi,

I wonder if anyone can help please.

We used to have three separate dashboards when using 11g, but have merged them into one dashboard in 12c and used the subpages feature to organise the dashboards. So we have three main dashboard pages, and each main tab has a number of subpages.

This has raised an issue in that the dashboard prompts we had before, whose scope were set to dashboard, now apply to all three main dashboard pages, when we wanted the scope to apply to the main dashboard page and each of the subpages.

Does anyone know if there is a way to set the scope of the prompts to the dashboard page and its subpages, rather than to the entire dashboard or just the one subpage?

Thanks in advance

Chris Arnold

The way I have gotten around this is by changing the formula for the prompt.

I'll try to explain.

If I have 3 dashboard pages that have prompts for  'Customer Number' and I want each of those prompts to act independently in scope, then I do the following:

(1) Page1 prompt:

     (a) I go into the formula for Customer Number in the prompt and set it to be:

               CASE WHEN 1=0 THEN NULL ELSE "Customer"."Customer Number" END

     (b) Set the prompt to populate a presentation variable called vCustNum1

     (c) Set the filter for all the reports on this dashboard to be:

           "Customer"."Customer Number" is equal to / is in  @{vCustNum1}{XXXXXXX}

(2) Page2 prompt:

     (a) I go into the formula for Customer Number in the prompt and set it to be:

               CASE WHEN 2=0 THEN NULL ELSE "Customer"."Customer Number" END

     (b) Set the prompt to populate a presentation variable called vCustNum2

     (c) Set the filter for all the reports on this dashboard to be:

           "Customer"."Customer Number" is equal to / is in  @{vCustNum2}{XXXXXXX}

(3) Page3 prompt:

     (a) I go into the formula for Customer Number in the prompt and set it to be:

               CASE WHEN 3=0 THEN NULL ELSE "Customer"."Customer Number" END

     (b) Set the prompt to populate a presentation variable called vCustNum3

     (c) Set the filter for all the reports on this dashboard to be:

           "Customer"."Customer Number" is equal to / is in  @{vCustNum3}{XXXXXXX}

I hope this helps.