Are all the other scripts present in the bitools/bin folder? Because it's kind of difficult to have everything there except the migration-tool.sh if nobody moved it or deleted it .... (always got it there) Did you try searching your system if maybe, by "mistake", somebody didn't move that file? (if they delete it ... well…

Hi, What did you try so far? Because ... it sounds like all you need is a filter. If you have a prompt with "all" and "negative only" then you need a filter based on that value. If you apply some logic you can combine things: prompt = negative AND your column < 0 gives you negatives if you selected negative in the prompt.

What documentation are you talking about? Post a link to what you are referencing ... More in general: does BigQuery have ODBC or JDBC drivers? Yes Do these drivers require a license? No (based on a entry in the drivers FAQ) So it just become a ODBC source like another in the end ...

Which exact version of 12c? Of course you need a license, not to make it works, but just because you aren't supposed to use anything you don't have a license for (or Oracle will not appreciate ). You probably miss the required policies to allow you to see VA (or DV, depending how you like to name it). Depending on which…

Or in the database (which is the place the Job Manager get the logs from). But in this case you will have to joins tables and apply some logic here and there to make it "readable" depending what you look for. The client is easier.

3384785 wrote:But no such file exists in the specified directory. If you configured your OBIEE first you will find the file, if you just installed OBIEE (the screenshot you posted) you simply pushed the binaries and files in place, but your OBIEE isn't configured at all. You need to execute $ORACLE_HOME/bi/bin/config.sh…

The idea is just to add some CSS rules to the custom style deployed (or to deploy one for that if not already done) and hide these elements by CSS. For example for the "new" menu something like: body > div.masterMenu.HeaderPopupWindow > div.ScrollablePanelScroller > div > div:nth-child(1),body >…

Duplicate with OBIEE 11G nQSError:93001 Close this one as the discussion is on the other one.

Hi, During the install all the requirements were fine? all the pre-install checks passed without any warning on missing libraries or things like that? If not wrong ELF is one of those requiring both 32 and 64bits versions installed on your server. So check which one you have and install the other one in case. (but this is…

Always keep in mind a little detail: your desktop isn't the BI server, you able to connect using a TNS name from your desktop doesn't mean OBIEE know what that TNS is, and doesn't mean the BI server can connect to the DB. There are ways (locations) where to tell OBIEE about your TNS.

Hi, I guess you can just ignore OWB (Oracle Warehouse Builder) and stay on ODI for all the ELT things (building a cube is a loading operation in the end). As Robert said, for cubes (real cubes) you have Essbase which is one of the references for ages now. Do not really always try to find a perfect match between a Microsoft…

Hi, Have a look at: runcat.sh -cmd archive and runcat.sh -cmd unarchive (or runcat.cmd if on Windows). You can script the archive command and specify the exact path of the catalog you want to archive (or a list of folders and reports).

user1137177 wrote:Just a quick check: can I directly go to 12C or I have to first upgrade to 10.3.6 and then to 12.1/12.2? Where does "12c" come from? 10.3.6 is just weblogic, and OBIEE 11g isn't certified on weblogic 12, so you better do not mix these pieces. If you are thinking / talking about moving to OBIEE 12c you can…

You are right but it's also the only thing I remember sounding like what you see, with columns just "empty". Also the patch has a name and replace a .so file which could also work for DDR. You can of course open a SR and follow the process there asking them if the fix cover your needs too or not. But if you have a sandbox…

Yes, that's the post I had in mind As you have the same version you maybe want to have a look into the linked bug/patch. The bugs not being public if you want to see more you will need to open a SR. The patch is available publicly in MOS, so you maybe want to give it a try ...

Hi, Did you try building a new analysis from scratch with the same query? Also maybe worth searching the forum here as I remember something similar (actually the same) some time ago. PS: it always help if you clearly identify the versions you talk about (full version number + bundle patch)

The "one shot thing" is the duplication: you aren't going to duplicate your model every week, you duplicate it once and it's done. So spending 1h to do the job isn't too much or impossible.

Database properties are ... easy to miss : too many and not the simplest to manage ... So you can maybe close the thread if you solved, by marking if required, for others having the same/similar question? Right now it's stilll This question is Not Answered.

I guess that's your thing. By default both 11g and 12c database types will set the "IDENTIFIER_QUOTE_CHAR" to empty (the default value), but I had a RPD around where in 11g it was set to double quote. The name sounds interesting and can be the one you look for. Check the value of this one in your old working RPD and then…

Hi Mark, Do you still have a copy of the RPD with the old "11g" database before you changed it? I would say you maybe changed some database features (properties of the DB object in the RPD, the "features" tab) to make the 11g work fine, and when you changed to 12c you got the default 12c database features. When you then…