3165111 wrote: ANALYTICS works rarely , XMLPSERVER works rarelyANALYTICS said that Username and PW are not correct (but, they are correct!), What you think is the right password is maybe not right for OBIEE, depends on the authentication providers setup you did. Publisher is by default configured to use the FMW security =…

Hi, If you don't have idea on initiatives it's maybe because you don't need them as you don't have any? Depending the approach and context of your scorecard these things are defined or not. In a corporate strategic plan over 3-5 years you generally have objectives and initiatives to achieve these objectives and finally kpi…

So the problem changed and the original one isn't a problem anymore? You can see the analysis in the dashboard. What is the click on the graph supposed to do? Only this analysis has the problem or others too?

Hi, No real changes but some of the things you wrote are already there in 11g... Row headers format is still fixed, you can set condition rules based on members name, and you can also set different formats per level of a hierarchy (this isn't really conditional formatting, just normal formatting). If you mean you would…

Does the analysis exist? Is the path right? Do you have the permissions on it? (and the correct permissions on all the folders in the path) Answering these questions will fix your problem.

Long version: your reverse proxy isn't fully configured apparently. Publisher is on a different path, it's not on /analytics but /xmlpserver, you just don't see it as it is loaded into a frame of a /analytics page. So configure all the paths OBIEE and related products use in your proxy and you must be fine (so if you have…

Robert Angel wrote:... as null data is never equal to anything. True, = doesn't help you, but something like Col1 = 'FlyInTheOintment' OR IfNull(Col1, 'I am a value which can not exist at all in this column, never ever') = 'I am a value which can not exist at all in this column, never ever' Will match your nulls just fine…

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…