Just for the part about having a not adapted network configuration on a laptop vs a server or a vm: in your log at some point you have something like t3://DESKTOP-1Q20P03:9500: [RJVM:000575]Destination 169.254.137.174, 9500 When you have a 169. address its when windows assign itself an ip address because no connection.…

Windows 10 is not a certified OS for OBIEE. It isn't expected to work on that OS. It's not you changing IP but your router doing it by itself (the joys of dhcp). Install Virtualbox and an Oracle Linux 7 vm: it's a supported os for obiee, will take about 10-15 minutes and another advantage is that you can take snapshots or…

What OS is that? I bet on a Windows 7, 8, 10 or something along that line ... If it's the case have a look at https://dimensionality.ch/2017/05/06/installing-oracle-bi-on-windows-7-8-10/ More in general you are using a name which is the name of your PC apparently, but in a "home network" IP addresses can change, so if your…

No problem, it's just probably the N°1 rule in here (because of MOS being a service you pay for), and they are quite strict about it. So better to avoid having mods looking at you

@puntano01 : it's nice to post back how you solved, but you better delete from your post the copy/paste you did of the solution itself. Just leave the link to the MOS document. It's forbidden to paste the content of a MOS document in the public forum (because it's what people paid for paying support). Also mark your own…

You have a "deal date" column in your fact table? That's what I meant by weird model. If you made the right joins in the model you don't need to keep a "deal date" column as this one is supposed to be equal to the day column of your date dimension. So get rid of it and you avoid the mistake. And you see once you take the…

Hi, I'm kind of curious to know what your model looks like as I hardly imagine how it is possible in a correct model to have a date like "10/10/2017" on the same row as "2017" AND "2018"! So I would say your "year ago" is fine and it's your model wrong (or weird) and your "Deal date" is not part of your time dimension, so…

That's why, even before to know which version, I wrote to delete the temp files of the browser. Gianni Ceresa wrote:Empty your browser cache and delete all the temp files. Without going into details of how IE works, if you do not uncheck the checkbox it just doesn't delete anything related to your favorites sites (and…

Empty your browser cache and delete all the temp files. And if you want more ... post more (versions of OBIEE, versions of IE, if IE was updated recently etc.)

user5922791 wrote:We have OBIEE 12.2.1.2 on Windows 10. You are using a not certified and supported OS (a client OS for a server tool), so you can't expect things to work as documented.

An ORA-xxxxx error is not an OBIEE error but an Oracle database error. So if you at least want some hints you will need to be a bit more explicit and post some infos on the relative DB and at least look what kind of physical query OBIEE generated and compare it with the one generated on the other environments to identify…

Do you have the main one located at <your ORACLE_HOME>/bi/modules/oracle.bi.migration/scripts/migration-tool.sh? As I posted above the file you look for doesn't contain a lot, so as long as you have the main script just create the missing migration-tool.sh yourself with the content I posted above and give it a try ...

I don't have an AIX around, but I find it super weird that when you install OBIEE 11.1.1.7 you get the client of 11.1.1.9 inside, mainly because 11.1.1.9 didn't existed when the installer of 11.1.1.7 was created .... As 11.1.1.7 is old only 11.1.1.9 is available on the site online. Don't you maybe have multiple catalog…

Never ever mix versions! 11.1.1.9 is looking for the v10 of the WSDL while your OBIEE server only has 6, 7 or maybe 8 available. Catalog Manager is installed with the Admintool, the installer is available as link in the OBIEE homepage itself (the installer is stored locally in your OBIEE install, you can also find it there…

Well ... I assume it's worth to triple check the URL (the http:// in front, the saw.dll at the end, nothing before, nothing after and everything else in between). If OBIEE is installed and working there is no reason for catalog manager to not work as it's mainly does webservices calls to the server (in online mode). The…

Do you have some SSO in place or something like that?

What URL did you enter in the connection screen? What's the URL you use in your browser to connect to OBIEE from the host on which you have the issue with Catalog Manager?

When you are pissed to lose joins all the time you get creative

You can import offline as you can do it online. It all depends on your host where the Admintool is running as it's the one connection to the DB and doing the job (and not the server). Did you try the import? What happened? If the question is more "can you update the existing table", in case you start having weird things or…

3547198 wrote:Thanks for the reply. In my case, all the columns are coming from one dimension table. May be I have to separate them into different logical fact and dim tables and then create the level based measure. Remove the "maybe". The logical model is supposed to be a real model, a start schema. If all the columns…