Oracle Communities

Oracle Analytics and AI

Child Item

Changing 'All Column Values' in dashboard prompt

Hi All,

In OBIEE 12c, how to modify the dashboard prompt All label value? I do not want to change value in XML file , because it will impact all dashboard prompt value.

Is it there better method to implement this problem?

For example:

In dashboard prompt-->edit -->options--->tick 'Include "All Column Values" choice in the list', so I can view '(All Column Values)' value in prompt. Customers want to changed this value,such as 'all values'. Is it possible? Thanks.

This query is already been raised and answered previously in oracle community with the reference

http://www.varanasisaichand.com/2010/01/editing-all-choices-in-dashboard.html

However, i am not able to find the content in the mentioned link.

Could someone please help me to retrive the contents of this? Otherwise please let me know the sql query which i can use as union all to acheive this.

Best Regards,

Ritesh

Find more posts tagged with

Comments

Robert Angel

If I understand what you are asking for then; -

Change your column prompt to sql and add the following on the end; -

union

Select distinct 'WhatEverYouWantForAllValuesHere' from dual - you may have to change dual if it is not in your DB - pick any SMALL table

Then in your filter, change it to SQL and; -

Dimension.Field in( case when '@{YourPromptPresentationVariableHere}' = 'WhatEverYouWantForAllValuesHere' then Dimension.Field else '@YourPromptPresentationVariableHere' end )

Again change Dimension.Field to suit your individual scenario.

3614436

Hi Robert,

Thanks a lot ! !

Though its not complete but helped me to achieve the functionality.

I am providing below the complete steps to achieve this. I can not attach the document due to information sensitivity.

Steps to Change the Custom Dashboard default prompt value [“All Column Values to “All”]

Step 1: Create a Column dashboard Prompt “Columnname_Prompt”.

Operator : is equal to /is in
User Input : Choice List
Choice List Values : SQL Result
Select the checkbox for “Enable user to select multiple Values” & “Enable user to type Values”
Auto Fill : None
Default Selection: Specific Value --> Choose “All” to display"All' on the prompt as default.
Set a Variable : Presentation Variable
Variable Name : pv_name
SQL Statement under SQL Result ( # c)

SELECT DISTINCT “TableName"."Columnname"

FROM "Tablename"

FETCH FIRST 65001 ROWS ONLY

UNION

SELECT CASE WHEN 1=0

THEN "TableName"."Columnname"

ELSE 'All'

END

FROM "SubjectAreaName"

j)Save the changes.

Step 2: Create a Report called “Reprotname”

Create a “Advance SQL Filter” and write the SQL statement as below

"Tablename"."Columnname" in

(case when 'All' = '@{pv_name}'

then "Tablename"."Columnname"

else '@{pv_name}' end)

Make Columnname filed as Prompted.
Save the Report.

Step 3: Create one dashboard. Place both prompt and reprot and test it.

Hope this will help to others as well.

Best Regards,

Ritesh

Robert Angel

Thanks Ritesh, glad you got there and respect for the fuller documentation for the benefit of others.

Can you close your question also please and mark as appropriate.

3614436

Hi Robert,

Please guide me how to close this thread. Not able to find the option to close it.

Best Reagrds,

Ritesh

Martin van Donselaar

You can close the thread by marking one of the answers as correct. I think that should be your own answer in this case. However, you should first mark Roberts answer as helpful because he pointed you in the right direction

3614436

This is very helpful.

Robert Angel

Hi Ritesh,

Your answer made me smile...

The idea is that you press the 'Assume Answered' button to just close the call without awarding points if you think no one has helped you or you are not feeling generous.

At the other extreme you can click on 'Answered' and it will close the call and award points - if you are marking another's answer as correct, or not award points if you are marking your own answer as correct.

Between these two extremes there is also clicking on helpful for questions that have helped but not answered your question, and then click on 'Assume Answered' so the question does not remain open.