Hi, Clearly depend on your current security setup but with row-level security you must be able to manage that. As region and department are different dimensions (I guess as you say "different tables") you must define rules taking both into consideration.

What Christian said. Scorecarding, KPI and KPI Watchlist are all part of the same thing, originally called OSSM (Oracle Scorecard and Strategy Management).

In addition Enterprise vs Single Server can be a bit confusing as in 11g there was the simple install and enterprise install where simple install was mainly for testing and OBIEE was deployed on the Weblogic admin server skipping the managed server (= less resources needed) while the enterprise install was the class setup…

Hi, I would say the most used is ORACLE_HOME/bi/bin/config.sh . Most people use this one. Even for a OBIEE cluster you use this one on the main server and then pack the config and move to the next server (where you didn't run config.sh) and unpack it and use that to add it to the cluster. I guess the one in…

I'm sorry but I would find strange the tool generate 2 queries for a dimensional only query. What you ask the tool (all the dimensions) doesn't make sense from a logic point of view as you have a multi start model. The tool works at the star level for dimensional only queries, that's why you can define one and only one…

chillychin wrote:Quite tempting to slap the person on the back of the head......but I kept it professional In that case a slap on the back of the head would be extremely professional, a lot worse could be done

Hammam Samir wrote:Still not accepting the Ignore and restarts the checking of the requirement of the specified Database Ok, let's make it simpler: http://www.oracle.com/technetwork/middleware/fusion-middleware/documentation/fmw-122120-certmatrix-3254735.xlsx The certification matrix isn't an imaginary thing: MySQL isn't…

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.