1 Reply Latest reply: Dec 28, 2012 7:49 AM by Ronny RSS

    Unable to create Parent Child Relationship Table

    Ronny
      Hi All,

      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?

      Thanks,
      Ronny