This discussion is archived
1 Reply Latest reply: Dec 28, 2012 5:49 AM by Ronny RSS

Unable to create Parent Child Relationship Table

Ronny Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points