Ok..Thank you Christian We will check if we can modify the DB tables

Hello Christian, Please guide if the display format is feasible. This is a client requirement and they are looking for an answer if it is doable in the OBIEE tool.

Hello Chritstian, Three logical facts are created in RPD. All facts are having different data like Employee Fact, Employee Absence Balance and Employee Payroll Fact. So all are actuall having different measures. So we have not clubbed them into a single logical fact table.

Hello Christian, Thank you for the quick response. I completely understand that OBIEE is taking the optimum path, but is it possible to make it choose the Implicit fact table column wherever possible in scenarios where non conformed dimensions are present along with other fact table columns as well. Example : Dim1, Fact1,…

Hello Chiristian, Thank you for the reply. All the main properties are given in english base and the specific ones are given as per language and country in localdefinitions.xml file. So that is why i changed it in english base section Please let me know, if we have to make changes in any other section to make it reflect.…

Hello Christian, Thank you for the reply. I modified the below attribute in bold in localdefinitions.xml file to change calendar display format. The however did not apply to the format in calendar display <localeDefinition name="en"> <!-- english base --> <property name="localeDisplayMessage">kmsgLanguageName_en</property>…

Hello Jerry, Thank you for the reply. The locale selected is English. The display of date is specific to the dashboard calendar prompt. When we select the date from the calendar, the format displayed is '06-02-2020' and I would like to change it to 02-Jun-2020. I tried modifying the localdefinitions.xml file but it does…

Hello Experts, Please suggest any solution for the scenario explained above.

Hello Jerry, Thank you for your reply. Selection steps allows us to see fitered view of the data. Which is good. The requirement we have is to apply certain filters on this dimension to apply data level security. I would like to make it work like as below. When person A with 4 reportees logs in, he should see only his data…