Import new column into RPD

Charles M

Hi All,

We have just added a few custom columns (category 1 type) to our data warehouse, per a business need. We tested the ETL's a few times now, and we can see that the data is coming through properly - fact stage and target fact tables. I was looking but didn't see that the new columns are being reflected in the RPD ( I checked online & offline). I'm reading over the RPD "builder's guide to find out the process to 'import' these columns into the physical layer. I was hoping that someone could also shed some light on the process in the meantime. Also ... is this supposed to be a manual process, or is there any automatic options that will make these types of updates.

Thanks in advance for any insights.

OBIEE 11.1.1.9.x (Bi Apps 11.1.1.10.1)

Regards,

Charles

[Deleted User]

Charles M wrote:. Also ... is this supposed to be a manual process, or is there any automatic options that will make these types of updates.

"Manual" in the sense that the RPD doesn't go and check the database. If you do an "Import Metadata" though on an object that already exists in the RPD like your affected fact table, then it will show you the new columns.

Alternatively you can always go in and do it completely manually and just create the columns which have been changed.

Charles M

Thanks Christian - always helpful to get some assistance along the way/while experimenting . I was getting the sense that it was something along those lines. It sounds like either one is a pretty good option (depending on the number of columns coming over).

I did have a chance play around a little more in an offline version of the RPD. But, I may be doing something incorrectly. When I did the import ... I was able to bring over the table (including the new custom columns). However, it seems like it has add it as a new data source (on its own)?

I was hoping it would "merge" the changes with the existing table - located way down, under 'Oracle Data Warehouse'.

Regards,

Charles

[Deleted User]

Charles M wrote:I did have a chance play around a little more in an offline version of the RPD. But, I may be doing something incorrectly. When I did the import ... I was able to bring over the table (including the new custom columns). However, it seems like it has add it as a new data source (on its own)?

Ah yes. You see in your screenshot that the name of your database object is basically the connect string. So that doesn't match what you have already - hence it created a new entry.

If you want it context.sensitive, then you right-click on the connection pool and run the import:

Charles M

Ok, I see what you mean. Thanks very much ... I think I have the idea now! Appreciate the explanations.

Regards,

Charles

[Deleted User]

Happy to help