For OBIEE 12c MySQL isn't a valid target database for the RCU schemas. If you look in the certification matrix you see MySQL 5.6 and 5.7 are supported as sources to be used in the RPD to build models and analysis on top. The doc referenced above by @Gbenga Ajakaye is about ODI (which can support MySQL for RCU as the…

Akshay Bhan wrote:What am i supposed to do? I would download virtualbox and use a VM instead of your own laptop/desktop PC. Then maybe download SampleApp so it's all setup and working with tons of examples. If would really want to try a clean install find a trial version of Windows Server (based on certification matrix) or…

Christian already pointed out the possible issue ... First: what exact version of OBIEE? (please don't say 12.2.1.0.0 ! ) Second: what style do you want to customize? Alta? (the new white one) Did you performed the steps about extracting analytics.ear to get the Alta files and put these files instead of the default…

2943841 wrote:the internal security at our organization installed antivirus on all the Linux serves including DB servers Tell them they can make it safer by unplugging the network cable and turn off the server More seriously: does your OBIEE server really needs to be exposed to public (internet) access? OBIEE itself…

Hi, with no guarantee of the answer I saw once a reference to 128-bit AES in a doc about OPSS and credential store.

Hi, More "elegant" ? Well ... as what you look for isn't anything standard, common or logic (because stacking columns would make >90% of the reports unreadable) you don't get anything out of box looking like that. The only option is manual HTML with a narrative view to make the job. They only way to get it "dynamic" (aka…

Just a quick not: you don't change the logo just on the logic and home page but it's a global change (except if you start mixing styles and having a second one for your dashboards with a different logo again, but it get complicated for nothing). And even if the solution can look like a lot of work for just a logo it's good…

Hi, Did you try searching the forum? Because it's apparently a trend to delete the admin app role or admin user in OBIEE lately Also keep in mind you have a BAR provided with OBIEE which contains the basic security setup, so you can load that one and you get back the default security and then you can reapply your own…

you can save the plan.xml inside analyticsRes directly, it's just a "weblogic" file like web-inf etc. Well, can't you plan an upgrade 12.2.1.2.0 ? Because your version is really the worst in terms of bugs, the really first public release of 12c .... Try to look at this: https://support.oracle.com/rs?type=doc&id=2131220.1…

What is your exact OBIEE version? 12.2.1.0.0 is bugged ... Did you configure the Presentation Service correctly? (with /res at the end of both the <URL> nodes?) Check https://gianniceresa.com/2017/02/obiee-12c-custom-style-using-shared-folder/ for all the details (wrote that one this weekend combining pieces of others and…

Hi, Dimensional modelling has it's own rules To make your calculation and to get that as a measure (I guess you will want an AVG aggregation on it) you must get the required tables in a LTS for the logical fact table. In the same way, based on your screenshot, your logical fact table is supposed to have only aggregated…

That's why the Admintool has something called "Merge..." in the "File" menu. Have a look at this: https://speakerdeck.com/rmoff/source-control-code-deployment-and-concurrent-development-for-obiee-12c If you adopt a correct deployment method you are not going to lose anything (but of course you can't expect OBIEE to work in…

By the way: your 4 LTS are a snowflake in the physical layer? If that's the case consider a single LTS with your various physical tables mapped inside.

Hi, You are mixing things a bit. OBIEE doesn't use logical indexes for joins, it will go back to the joins you defined in the physical layer for the joins between objects. That's also why when you define a join in the business layer it doesn't ask you about columns or conditions but you can only define the kind of join…

Actually you are right It's just the dumbest thing ever to run the RCU to generate the scripts for the DBA and being asked for a DBA connection. If you have the DBA connection why would you like to generate the code instead of running it? Smell like a smart developer forgot a piece of logic here ... Actually it must be a…

The blog just heavily use javascript to change the structure of the page once it has been rendered (actually it miss a piece to call the function only when the DOM is ready or you can get errors). It is a normal dashboard, actually it can works on any page of OBIEE where you can add the piece of code. I would suggest to…

Captain_Cook wrote:1) The underlying queries will change so this will have impact to performance?2) Rewriting DDR queries (syntax changes from Oracle)?3) Performance of BI/Presentation Server exchanges with PostgreSQL in comparison to Oracle 1) The queries generated based on the RPD will change just because the DB is a…

So can you maybe close the thread? Other users with similar question will know they can find something interesting on here. For now it's still This question is Not Answered.

at least we agree

Hi, REPLACE("Your table"."Your column", ',', ' ') You must edit the column formula and use the REPLACE function to replace , and add a space instead.