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.

If you do it the same way as 11g it's supposed to work. For sure the res (that's the one with the custom style inside, at least it's like that in mine), the msgdb I didn't test, so can't confirm 100%.

Great to hear you did it the right way So it's easy: copy your analyticsRes over to the 12c server and deploy it, cross your fingers and ... it probably works already not too badly (as it's a different version there can be things missing or being a bit different, but there are chances 95% of the job will be done already).…

You have an option. But keep in mind the "export" link there on top is based on a privilege and not dashboard based: so you have it or you don't have it.

Your sequence is not fine (you will be able to install following it). zain-OC wrote:To implement the Data Warehouse do i need to install Data warehouse builder ?? What do you mean by "implement the Data Warehouse" ? As I said a data warehouse is a concept and not a tool, wikipedia define it as "... DWs are central…

Hi, zain-OC wrote:install and configure OBIEE 11gR2 with ODI and Data warehouse The first step is probably to find out exactly what tools you need / want to install ... OBIEE 11gR2 doesn't exist, ODI is a tool with many version and so you better define which version you need. Data warehouse is a concept and not a tool, so…

Hi, You are installing on Windows, that's fine but .... please don't tell us it's your Windows 7 or Windows 10 laptop. As far as I remember the certification matrix cover Windows Server 2012 and 2012 r2 (double check in case). And if it's a laptop install I would highly suggest using a VM (virtualbox) to keep things clean.