I am trying to create parent child hierarchy for my employee dimension. This is what I have done so far
1. Clicked on the Parent-Child settings, gave the location where the scripts are to be stored, clicked next
2. Now in the next step, it asks for table name, the data source and catalog/schema, when I click on browse to select the data soruce, it opens up a window but don't get any data source for selection and the select button is greyed out. I am unable to select any data source which obiee can use to create this table though in my rpd I have 10 different databases in my physical layer. I am unable to select any one of them
Is there any setting which I need to do to be able to select any data source?
What can be the issue here? Ideally I should be able to select the data source. Please let me know what am I missing?