If you are trying to import it into the catalog it isn't supposed to work: a DVA file isn't a catalog object, it's a DV archive. A DVA is supposed to be imported from DV directly. More in general OAD does a lot more than OBIEE 12c on the DV side, therefore not sure you can really expect to import things as easily. If you…

The certification matrix for OBIEE 12.2.1.4 says that Oracle Database 19.3+ is supported for RCU and also as source for data. They aren't going to update the certification matrix for every single database bundle patch released. 19.6/7 fit the 19.3+ rule, therefore it is supported.

In other words, the question is: what do you want your OHS to do? What is the expected behaviour? The httpd.conf must follow the answers to those questions and only that.

My memories of Apache HTTPD (OHS is just that in the end) rewrite rules are almost 20 years old but .... 944333 wrote:in httpd.conf we have added follwing parmeter:RewriteRule ^/$ /analytics/ [R,L] -- analytics is workingRewriteRule ^/$ /va/ [R,L] -- va is not working How is that supposed to work? You have the first rule…

944333 wrote:visual analyzer landing page is not loading after adding /va in httpd.conf file and mod_wl_ohs.conf file Hi, could you please spend few more minutes writing all the things you forgot in the previous message? I'm sure your tool as a version, you mention an httpd.conf file which means you don't have "just" an…

The error is explicit: it could find your connection pool properly, but it can't find a datasource matching the name you put inside that connection pool. You have to review your connection pool settings as, right now, the DDR can find it but can't do much more from there. You aren't posting a single hint on what version…

What about if you ask in an OTBI forum? OTBI maybe use OBIEE as base, but has it's own things. OBIEE in any screen where you can write a formula has a button 'f(...)' : do you have it? Click on it and go through the various entries till you find what you are after. If you don't have that button ask this thread to be moved…

Officially there isn't a way, no tools or other supported tricks. Unofficially it depends on how good you are with some code and confident in doing things .... Filters are "just" a piece of XML into analysis, so you can script things to do the job. But because you would be manipulating the XML outside OBIEE, you are in…

You can't.... The attribute 'display' is at the view level, not on the bar or the line. So it's either "always" for the whole view, or not.

Sounds like you are working with @3878813 (em console shows coreapplication down when everything is fine ) ... I have the really bad impression you are asking the wrong questions and not fully understood what means upgrading OBIEE in OBIA. OBIA comes with an OBIEE out of the box (one of the many tools OBIA comes with),…

Great, so you can maybe close the thread and mark as required? It will help others with the same/similar question.

Have a look at https://support.oracle.com/epmos/faces/DocContentDisplay?id=2068474.1 12.2.1.4 has an additional place where you have to copy the tnsnames.ora.

Joel and Christian already said everything. You can also check on MOS for the certification and you will get the exact answer you look for.

3913018 wrote:...how we can create measures from dim tables... The star-model has very simple rules: a dimension is a dimensions because it contains attributes qualifying measures. A measure is an aggregated information. So if you need a measure from a dim table, it means you dim table must be modelled as a fact table and…

A day finish at midnight, it doesn't continue the day after (that's what "tomorrow" is for). Your filter must be on date AND time, not just time. Only on time a filter between 5pm and 8:59am makes no sense. At the best you could express it as between 5pm and midnight OR midnight and 8:59am, but this isn't what you said as…

I'm not really sure what you expect as answer ... What about adding a filter to your analysis on your datetime column? Sounds like we are in a circular conversation! Keep in mind one thing: OBIEE is an empty product. Nobody here see your screen. You talk about "Lead Creation", this is a column only you see, it isn't part…

I'm not really sure what you expect as answer ... What about adding a filter to your analysis on your datetime column? By the way: double, triple (and more) posting is against the rules of the community. OBIEE Report OBIEE Report - Filter Based On TIME

Would be helpful if you could post the exact version of OBIEE you are using (OBIA doesn't tell what OBIEE you are having in front of you as often people update/upgrade). And what are you trying to achieve? You said what you did and that it doesn't work, but you didn't say what was the original target of these changes (XY…

Simpler and shorter: RIGHT("Worker"."Primary National Identifier Number", 4) When you click on the "f(...)" button in the formula editor you can easily see available functions (in categories, with a short description of the function and parameters).

Try again, it works just fine ...