Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Haha - yeah its a (painful) process. My apologies to Joel. I saw that he did some earlier work on that, and he deserves credit for it. I'll mark Joel's answer as correct then I tried creating tnsnames.ora in the directory you suggested, but in the sampleapp image, it appears the directory structure does not quite match.…
-
Thanks Steve! That makes sense, and I will make note of that for future reference. Although in my SampleApp image, I see a $TNS_ADMIN, not a $TNS_NAMES. Yep, it was the SampleApp. I must confess, I did not get a chance to try out your suggestion. Trying too hard to fix the issue and making things worse by exploring every…
-
Server (Oracle Enterprise Linux 6.7 x64 as guest on Windows 10 host) OBIEE 12.2.1.1 Oracle Database 12.1.0.2 EE Client (windows 10 host) Oracle BI Administration Tool 12.2.1.3 As far as i can tell, the tns connect issue is only with OBIEE on Linux/weblogic. I can connect everywhere else. It would be helpful to know how…
-
Update: I decided to install the 12.2.1.3.0 client. That resolved the issue. I can finally proceed with the tutorial. As for the uploadrpd issue, I was using an outdated call. Apparently, data-model-cmd.cmd is no longer available in the client distribution; datamodel.cmd, however, does work, as you can see below.…
-
I decided to try to create a new repository from scratch in order to see if that would cause the BI Admin tool to create the missing directory paths. I followed this tutorial: http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1221/rpd/rpd.html#section1 At the very least, I figured I'd learn something. It…
-
Per ANSI SQL spec, nulls are treated differently from actual values, as the NULL "value" is technically undefined. You may be seeing an implication of that. A dimensional modeling best practice that gets to the heart of this is to make every Fact reference to a Dimension be NOT NULL; Dimension Attributes should be NOT NULL…