For some reason my question did not post correctly. All of my variables have question marks in front of them. Can anyone tell me why?

Thank you both for the information. If we go the route of using web services to pull the information, do you have any idea what type of license that would require? Would a license just be required for the web service, or for everyone accessing the web page?

At this time, the details are somewhat vague. The question was asked because one of the departments wants to provide a world map with statistics for specific locations, on our website. That's about all I know right now. The initial question is whether something like that can be done in OBIEE, or if some other type of…

Thank you for the explanation and suggestions.

Update: Just in case anyone has this question in the future. I did some experimentation and the CEO record needs to have a null value in its parent key field in the original data table before the scripts are run to build and populate the parent-child relationship table.

Thank you for the great information.

This is exactly the information I needed to help solve my issues. Although it does not provide an answer to my original question about comparing settings, and it does not provide a concrete explanation of why this is happening, it does offer suggestions on how to deal with the issue. This allowed me to get the look-ups…

Physical DB only exists in one place. (Confirmed) Same RPD is being uploaded to both servers. (Confirmed). Webcat is correct (Confirmed) Thank you for the suggestions.

Very helpful. Thank you for the reply

I'm not sure how to do option #2, but it looks like an interesting idea so I am going to pursue it. Thank you for the suggestion.

Yes. The only difference is that one is offline and one is online. And they are on different servers.

When I try to use the "Import from Repository" option, I get the following error: [nQSSError: 12033] A client tried to connect to a server that is not of the right type. Any idea as to what that is about? The same Admin tool was used for both RPD's. The Admin tool is on a Windows server and the online RPD that I want to…

In our RPD, we have one large physical data base, then many different business and presentation layers. This includes the HR data. It has been decided that the HR department should have their own RPD, and will maintain it accordingly. The HR information consists of over a hundred tables (many with complex joins and where…

Thank you for the information.

Version is 11.1.1.7 running on Linux server.

That solution works beautifully. Thank you very much for your help.

I have tried this (Not my actual field names) in the expression builder for the physical join, but it wont take it: CASE WHEN DB1.dbo.FileB.Type = 'XXX' and DB1.dbo.FileA.Status = 'Active' THEN DB1.dbo.FileB.ID = DB1.dbo.FileA.ID and DB1.dbo.FileB.Start-Date >= DB1.dbo.FileA.Start-Date and DB1.dbo.FileB.End-Date <=…

If you go into your analysis and "Exclude" the first 3 fields (left clik on each field and select "Exclude this field"), you will only get the final total for the fourth field. I think that should give you what you need.

Usage tracking was originally on SQL Server. At some point, a management decision (above my pay grade) was made to move it to the "Out of the box" configuration using an Oracle database. We already use Oracle data bases, so licensing/cost was not an issue. Performance on the Oracle database is worse, so I have been tasked…