I was curious to test where I could use that join between the dates (which is indeed more inefficient, I understand, but just from a point of view of experimenting with the possibilities), and I found that I cannot create that type of join between the dimension table and the fact table in the Physical layer of the…

Thank you, everyone, for your responses. I think I understand now. Thank you especially to Robert Angel who did his best to get the answer through my thick skull. Correct Answer awarded to Martin. The join he described was the missing link in my understanding of how to proceed. Once I saw that, I understood.

Robert and Martin, thank you for the replies. I think I understand what you are saying, at least conceptually. Robert, the ETL doesn't bother me - I can make that happen, no sweat. But can you take me just a little further down the path of "your hierarchy will have Primary Keys that are date bounded"? Are you referring to…

Addendum: The problem seems to be the worst when I trying to change someone to a BIServiceAdministrator. I can switch back and forth between BIConsumer and BIContentAuthor, or I can go down to either of those from BIServiceAdministrator. But going back up to BIServiceAdministrator is a non-starter. When we do that, the…

That SR was originally created in 2015. Oracle has known about the problem for years. 

Absolutely right, Asim. That method had always been quite reliable. Thanks for the addition to the discussion. 

Yeah, we considered the sections, but they want to to see sort of a trellis-type of approach - rows and columns. The information you referenced at this blog looks interesting. Oracle Business Intelligence OBIEE 101: OBIEE Horizontal Pivot Sections Part 2 In this specific example, as currently defined, that could work, but…

Well, OK, Sherry, you asked for it! Long-winded explanation ensues. First, forget about months. I was just trying to use a simple example. The actual attribute column at issue is Day. My client needs to see a series of graphs on a dashboard, one line-bar graph of daily results for each day selected in the dashboard prompt.…

Yup, Gianni, I see numbers in the Score column, as shown in the screenshot. Are you saying that, on your system, you don't see numbers in the Score column? If so, I don't think I've done anything special to make it happen on mine. I'm on version 12.2.1.2.0 (Build BIPS-20160923092103 64-bit). Also, I've assigned scores…

Good thought, Sherry, That one had not occurred to me.

Venkat, thank you for hanging in there on this thread. * I deleted the ODBC System drivers associated with Oracle BI Server. * I uninstalled the Admin tool. * I reinstalled the Admin tool. No problems, all steps ran successfully, and it brought up the ODBC Data Source tool. * I created an ODBC System DSN with the same…

Well, yeah, if all of the issues were as easy as saying 'Hey, Christian, what am I doing wrong' and you coming back with the answer... Sure, I'm up for that!! A half-step back, away from the problem, and the situation looks clearer, ya know? We get so stuck in the weeds that are right in front of us that sometimes we can't…

Christian, you pegged the answer. From my technical support staff: "The two machines are running in the AWS (Amazon Web Services) cloud, so if the 11g box can reach the smtp server, then 12c should also. We checked their security groups. O11 is using a custom firewall rule set called LC and O12 is using one called OBI397.…

Thank you for the ideas, Syed. To your first question, the answer is no. It is a fresh installation of 12c from scratch on a machine that has never seen OBIEE. 2nd question: Yes, the <DSN> tag shows AnalyticsWeb 3rd question: I'm about to try that now.

Thank you for the ideas, Venkat. I compared my settings with the information in the blog - they match. I also tried the suggestion in Doc ID 2162700.1. In that Doc, it mentions an error related to two non-existent system variables, so I defined those variables. Unfortunately, that didn't fix things. Question: What happens…

Venkat, I found the file odbcad32.exe in both of the locations that you noted. When I double-clicked the 32-bit version, it tells me that the Oracle BI Server is using a 64-bit driver. So I'm pretty sure it is 64-bit. Screenshots below.

Thank you, Venkat. Class begins in 15 minutes, so I will give these ideas a try later this evening (including switching the NQSConfig.ini back to its original configuration!) and report back to you.

I am launching AdminTool.cmd with a right-click then 'Run as Administrator'. 

Sherry, I was able to test this after hours last night, and it works perfectly. Thank you again.

Gianni, as always, great explanation, sir. Sherry was first to the party for the 'Correct Answer', but I'm tagging yours as helpful, but only because there isn't a button labelled 'Very Helpful'.