Static Table in RPD.

If we have a requirement like we want a static table of data in OBIEE and we do not want to refer any data source, then we achieve this by creating View in RPD.
Oopen the New Physical Table window in RPD.

Give a name to the view, select "select" option from dropdown and write your query in the "defualt Initializing String" area.

Click on Column tab to add new column.           

Note - The column name in the select query and the column name which you have added in column tab must be same.

Now join this table with Fact table. 
In my case, I will create a alias table and make join.

Drag both the tables to BMM layer, and do the same join.Now drag the Static Table into presentation lay.


Restart the services and check the result in presentation services.

% Acts as All Choices in OBIEE Prompts.

If we put % symbol in Default to ->Specific value box of a prompt, it will act as All choices.
Ex : In the below prompt, I have used % in   Default to ->Specific value box.








Now create a report.




Now add both prompt and report to dashboard and check.

Note : We have used % symbol in Specific value box and we get All Choices in dashboard as default value.

So, as we do not have All choices option in Default to drop down for Edit Box control, we can use the this strategy to set All choices.



Let's check in dashboard.



That is  by default our prompt is sending all values to filter of the report.