Bentley Experts,
I was trying to join XFM features with Oracle table (not oracle spatial) using the join capaility in the Map manager with success. When I analyze the feature, I noticed that the oracle table columns or fields that I joined were missing, To further evaluate the feature using the Data browser, I noticed that all column features are present (both XFM and Oracle table columns) but Oracle columns data were empty .
My questions are:
1. I want to have both XFM features and Oracle table (my existing data) be viewed in data browser, I this achievable?
2. If yes, How? If not, is there a workaround to achieve such report?
Thanks,
Jun
Hi. It seems the join succeeded if you can see the additional columns in the DataBrowser. Normally if the columns are all empty it means that for the feature instances you are viewing in the DataBrowser we could not find a matching record in the right side of the join. Make sure you have chosen the right property on the XFM feature and the right column in the Oracle database with matching values.
Normally if the columns are all empty it means that for the feature instances you are viewing in the DataBrowser we could not find a matching record in the right side of the join
In my case this is not true, i make sure that the record matches both the left and the right side of the joined feature instances. while I also tried joining the records set or feature instances that are within the Oracle database, and it works.
Hi. Can you tell me on what version of Bentley Map you are working ? Did you actually create two joins on the same left-side class ?
Let me recap to see if I understand correctly. Assuming you have a feature class "A" with a property "ID" that you want to join with something else. You create a join from A.ID (the left side) to a "New Oracle source...", connecting to a new Oracle database. You choose a corresponding database table, and a column which you know contains values that match the A.ID values. This makes the columns of the database table appear in the DataBrowser, but they are all empty, and analyze feature doesn't show anything more, only the properties from A. Is this right ?
Do you also have an active Oracle connection in the Interoperability dialog ?
If instead you create your join to go from A.ID (left side) to another class in your current Oracle Spatial connection (from "Session Features" in the right side) in which you have an "identifier" column with values that match the A.ID values , then the join works fine ?
It may be hard to debug this in the forums. You could contact Bentley Support to get this further.
Martin
Hi Martin,
I am using SS1. (08.11.07.113)
Assuming you have a feature class "A" with a property "ID" that you want to join with something else. You create a join from A.ID (the left side) to a "New Oracle source...", connecting to a new Oracle database. You choose a corresponding database table, and a column which you know contains values that match the A.ID values. This makes the columns of the database table appear in the DataBrowser, but they are all empty, and analyze feature doesn't show anything more, only the properties from A. Is this right ?
To give you more specifics as to my schema, My schema is a combination of XFM and database property attributes. If i join the XFM and database property attributes, It will result to no data showing in the database property value.
If instead you create your join to go from A.ID (left side) to another class in your current Oracle Spatial connection (from "Session Features" in the right side) in which you have an "identifier" column with values that match the A.ID values , then the join works fine?
Hi. Sorry I haven't answered before. I don't see what could be wrong. This could be data-specific.I think at this stage you'll be better to contact Bentley technical support so they can reproduce your issue and help you resolve it.