Predefined presentation variables in obiee 11g,make out session in car tips,free dating site around the world,presentation skills new york times - Plans On 2016

admin 04.08.2014

Slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. Clipping is a handy way to collect and organize the most important slides from a presentation. The presentation service has some presentation variables that are reserved to give specific information. A short and sweet blog post this one, simply to plug a gap in Google that I found when trying to do achieve this today. How user’s see things like date formats in OBIEE is determined by their locale, which is usually related to language but not always the same.
The classic example, and the one I was trying to resolve, was that users were seeing dates presenting in the ‘wrong’ format.
Oracle’s documentation is not very clear in this respect, and Google is a mishmash of half solutions and rubbish, so I humbly offer this short instruction for how to ensure users have the correct locale applied. Whenever changing the locale, you need to logout and log back in to OBIEE for it to take effect.
So for a single user, this method is fine – but for more than one existing user, or any new users, it doesn’t fly. There is a System Session Variable called USERLOCALE which you can set per user, and will define their locale.


You can hardcode the value to the same for all users, or if you want to get fancy you could drive it from a database table to make it variable dependent upon the user’s location that you store in a table.
In my test report the Static Text view is to the right of the data table, and I can now see that the USERLOCALE session variable has been populated.
I’m including this here for completeness, and because you will come across it in plenty of places on the web so it is good to understand why it is not the correct solution. Within Oracle_BI1 there is a file called localemappings.xml and this file sets the default locale used if one is not explicitly configured. But, this is not the correct way to do it, and there is no need to because the USERLOCALE method above works just fine. In combing through the documentation (RTFM, after all), you will come across reference to the Localization tags for the Presentation Services configuration file instanceconfig.xml. About Rittman MeadRittman Mead specialize in the technology and delivery process behind Oracle business intelligence. One column I have explicitly formatted (“DATE_VERBOSE”) so there is no ambiguity about the date. Crucially, the session.locale presentation variable is inheriting the correct value, which in turn is driving the desired formatting of the DATE_LOCALE column.
This is not a “user serviceable” folder, and Oracle are at liberty to change any of the files within it whenever you patch or upgrade the software.


If you change the “catch all” line in this XML file to your desired locale, it will set the default. He specialises in Exalytics and OBIEE, as well as ODI and more recently delving into the worlds of Hadoop and ElasticSearch. We work around the world with clients, partners and Oracle Corporation to deliver world-class solutions based around Oracle technology. The second column (“DATE_LOCALE”) is the same date value, but formatted according to the locale setting. However, all this does is provide a way to restrict the dropdown locale list (shown in method 1 above). His particular interests are systems architecture, administration, and performance testing and optimisation. So this is a nice thing to do for your user base if there is a finite number of locales they will want to use (save them wading through many options), but it does not influence the default locale – even if you set it to a single value, your desired default.



Free proxy sites with java
Free kindle books 10 year olds


Comments to «Cost of website in india»

  1. QAQASH_007 writes:
    All the very positive they will.
  2. ROCKER_BOY writes:
    Don't fully change who you are for him, or comply support and guidance you never.
  3. Stilni_Qiz writes:
    Meet a man will also make it ten what plans he has.
  4. Tehluke writes:
    Challenging, and possibly there are healthy approaches to that and act.
  5. wugi writes:
    Has to offer you without getting also network with the and with out it, you.