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…

Look at the queries generated to populate the lists and you get your answer. There are multiple possible reasons, so look directly at what does the job and you get the answer.

Hi, You aren't giving much content to get a real answer ... Simple things like exact product and version you use, browsers (name and version) you tested etc. As it goes away on refresh, it sounds like a rendering issue, so something which is browser related. And a screenshot would also be helpful. And when you have the…

Somebody maybe saved system-wide properties for either that column or that data type?

Bouman, Arie wrote:....however when I try to change for instance last line, as suggested by a few blogs, it gives none or wrong result Everything comes from a query, so how does the query look like? No result or some other result is maybe not wrong in th end ... Look at what query is executed and that will probably give…

Hi Adrian, Nothing else cross by my mind at this time. It would require to be tested (and abused) till something work, but I already have long list of things to do/try first ... Did you try opening a SR to ask Oracle if they maybe have a hidden param or way to pass that password?

4122460 wrote:When customer click on action link... Where is the link they click exactly? If it's on the values, the one which is clicked is sent as context...