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 ...

There is a lot that cache management strategy must pay attention to. The first thing is to identify why do you want to turn cache on: what is the reason behind using cache? Is cache the real solution or you hope it will just hide the real problem? Before to turn cache on you must ask yourself how long must the cache be…

So you are saying it's a per-user cache issue? You have another thread where cache was already a problem (with agents maybe, can't remember). Sounds like somebody did a really dirty job on your system. They turned on cache everywhere randomly to desperately try to hide poor performance (which is generally the result of…

user477756 wrote:OBIEE 11.1.x. You aren't helping yourself: there must be close to 40-50 versions of 11.1.something ...

I didn't test this because I don't have an OAC instance up with multiple roles/users ... In a way renaming is deleting: you rename an analysis which is used by a dashboard and you break the dashboard as the linked object doesn't exist anymore. Same behaviour as deleting the object completely. "Edit" is to change the…