Categories
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
Comments
-
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.
0 -
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
0 -
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.
0 -
Hi Robert,
Please guide me how to close this thread. Not able to find the option to close it.
Best Reagrds,
Ritesh
0 -
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
0 -
This is very helpful.
0 -
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.
0