רשומות

מציג פוסטים מתאריך מרץ, 2014

March Repost: More Dynamics in the Physical Layer of OBIEE

תמונה
In our "blast from the past" series, I am reposting today an article which I wrote 5 years ago . With version 11g not to be released for one more year, the article focuses on strategies how to add more dynamics to the physical layer of a BI repository. Please enjoy *** During a BI project there are numerous opportunities to go down the stony road and establish redundancies where you do not really want them. When I am in a provocative mood (which I am not very often, I assure you), I use to ask "Do you want a 'B' project or a 'B I ' project?". There are so many pitfalls waiting for us to stumble into and reveal our bad (or sometimes even non-existent) design. There are many triggers for this post, as there are many fine people blogging about OBI EE ( here and here to mention just two of them, keep up the good work!) and I would also like to thank the many people who contact me with questions regarding OBI EE design and architecture. Today I would li

Time to Learn the Languages of the Web (and Good Design)

תמונה
My fellow instructors at Oracle University and I teach a lot of Siebel Open UI these days. And when I say a lot, I mean like two full classes (a full class is 16 students) per week, per instructor during peak demand. Of course, Siebel developers of all couleur, be it associate, rookie, graduate or seasoned veteran, are eager to learn how to understand and customize the latest and greatest among Siebel UI technologies. In the Open UI Foundations class (and a new advanced JavaScript API class, coming soon to a learning center near you), we talk a lot about the languages which form the modern web: HTML(5) JavaScript (and a fair amount of jQuery) CSS But Oracle does not own these languages, so we have to resort to other resources to learn more about these web standards. In the following, compiled with a little help from generous students, you will find a list of web resources which serve both the newbie and the experienced Siebel coder to get to grips with HTML, JavaScript and CSS. The l

Time to Learn the Languages of the Web (and Good Design)

תמונה
My fellow instructors at Oracle University and I teach a lot of Siebel Open UI these days. And when I say a lot, I mean like two full classes (a full class is 16 students) per week, per instructor during peak demand. Of course, Siebel developers of all couleur, be it associate, rookie, graduate or seasoned veteran, are eager to learn how to understand and customize the latest and greatest among Siebel UI technologies. In the Open UI Foundations class (and a new advanced JavaScript API class, coming soon to a learning center near you), we talk a lot about the languages which form the modern web: HTML(5) JavaScript (and a fair amount of jQuery) CSS But Oracle does not own these languages, so we have to resort to other resources to learn more about these web standards. In the following, compiled with a little help from generous students, you will find a list of web resources which serve both the newbie and the experienced Siebel coder to get to grips with HTML, JavaScript and CSS. The l

Buy One, Get One Free on all of Packt�s 2000 eBooks

תמונה
My publisher, Packt Publishing is celebrating their 2000th publication with a special offer: For any eBook you purchase until 26th of March 2014, you get one eBook for free. More details and the full catalog can be found on Packt's website . have a nice day @lex

Buy One, Get One Free on all of Packt’s 2000 eBooks

תמונה
My publisher, Packt Publishing is celebrating their 2000th publication with a special offer: For any eBook you purchase until 26th of March 2014, you get one eBook for free. More details and the full catalog can be found on Packt's website . have a nice day @lex

Siebel Open UI - How to fix Form applet display issue in Chrome

תמונה
Open UI form applets have some issue, when it rendering in Google Chrome.The controls are overlapped as shown below. Solutions Fix without JS ------------- Open a CSS file your application referring paste the below css td {     border: 1px solid transparent; } clear the cache and try :-) ------------------------------------------------------------------------------------- Fix with JS (as per oracle doc) As per oracle technical document we can fix this issue with a piece of code if (typeof(SiebelAppFacade.ChromeSpaceFix) == "undefined") { Namespace('SiebelAppFacade.ChromeSpaceFix')? (function() { SiebelApp.EventManager.addListner("postload", ChromeTdSpaceFix, this)? function ChromeTdSpaceFix() { try { $("#_svf0 table.GridBack").find("tr").children("td").each(function(index) { var regex = /(height)(\s*):(\s*)([^?]*)/, el = $(this),

Siebel Open UI - How to fix Form applet display issue in Chrome

תמונה
Open UI form applets have some issue, when it rendering in Google Chrome.The controls are overlapped as shown below. Solutions Fix without JS ------------- Open a CSS file your application referring paste the below css td {     border: 1px solid transparent; } clear the cache and try :-) ------------------------------------------------------------------------------------- Fix with JS (as per oracle doc) As per oracle technical document we can fix this issue with a piece of code if (typeof(SiebelAppFacade.ChromeSpaceFix) == "undefined") { Namespace('SiebelAppFacade.ChromeSpaceFix'); (function() { SiebelApp.EventManager.addListner("postload", ChromeTdSpaceFix, this); function ChromeTdSpaceFix() { try { $("#_svf0 table.GridBack").find("tr").children("td").each(function(index) { var regex = /(height)(\s*):(\s*)([^;]*)/, el = $(this),

Oracle BI Mobile for Android

תמונה
At the risk of outing myself as an Android fanboy, I was glad that the wait for a BI Mobile App for my smart phone is over. After serving customers with a favor for pomaceous devices for quite a while , Oracle has recently published Oracle BI Mobile for Android  on Google Play. Of course, I couldn't resist and try it out myself. In the following I'd like to describe my findings. Installation and Public Demo As with all smartphone apps, installing the software is nice and easy. Once launched, you find a predefined "Public Demo" connection which allows you to inspect various example dashboards and mobile applications. Indeed, the new BI Mobile Apps can be accessed simply by opening them from the catalog. Here is a screenshot from one of the sample dashboards (Galaxy Nexus): Browse and Search Tapping the left menu icon allows you to browse recently opened items, list the favorites or use the BI catalog. In addition, there is a central search box which also supports the

New Features in Oracle Fusion/Cloud Applications Release 8

תמונה
As announced a few days ago, Oracle has published a new release of its Fusion Applications (ERP, HCM, CRM) product line, namely Release 8. For on-premise deployments, this means that the installers   as well as the new documentation set are now available on Oracle servers. For cloud customers which have signed up for the Oracle-hosted versions of Fusion Applications (aka Cloud Applications) such as Sales Cloud , Oracle is probably rolling out upgrades already. The new release brings hundreds of features, with the following (personal) list of highlights: New Skyros Theme With release 8, Oracle ships a new skin named "Skyros" (probably inspired by the blue sky and white houses on the Greek island of Skyros ). New Skyros skin in Fusion Release 8 The new skin provides a more "flat" look and feel and will also be available for the accompanying middleware products such as Identity Management or Oracle BI. Oracle has announced a skin editor for release 9 so customers can

Project and Resource Management in Siebel

תמונה
Every now and then Siebel mesmerizes with its power and flexibility. Recently while doing an implementation, we stumbled upon where to do project/resource management activities as there was no major tool in place except good-old-excel. Siebel as good it is, comes with wonderful solution in form of Project and Resource Management module. It is power packed with options for creating Projects, Individual Tasks, Project Team and workbook, Timesheet module to keep track of each task/resource and many many more features. Mother of all siebel documents (Bookshelf) suggests this module was designed in consultation with leading professional services organizations specifically to meet the needs of consulting and service organizations. It is built in such a way that it can compete and beat any current Resource management tool available in market. If you are implementing Siebel and your client doesn't have good resource management tool don't miss out to demonstrate this module of Siebel. T

Siebel Mobile Applications and jQuery Mobile ThemeRoller

תמונה
One of the new features introduced with Siebel CRM Innovation Pack 2013 is the ability to use jQuery Mobile ThemeRoller to create custom style sheets for Siebel Mobile Applications (and only for mobile applications, at the time of this writing). Ever in an experimental mood, I decided to give it a try. Actually the whole bit is documented in the Configuring Siebel Open UI guide in Siebel bookshelf, but as usual you will also find the steps I executed in this post. Swatches Before we start, let's talk about "swatches" (and I don't mean the swiss watch brand ). A swatch in terms of style sheets is a collection of CSS rules regulating the colors, fonts and icons used in certain areas of web applications. The following image is taken from the Configuring Siebel Open UI guide and explains the concept nicely. Image Source: Siebel Bookshelf, Configuring Siebel Open UI guide . Siebel Mobile Applications use six swatches (A to F) and as per the documentation they control t

Siebel Mobile Applications and jQuery Mobile ThemeRoller

תמונה
One of the new features introduced with Siebel CRM Innovation Pack 2013 is the ability to use jQuery Mobile ThemeRoller to create custom style sheets for Siebel Mobile Applications (and only for mobile applications, at the time of this writing). Ever in an experimental mood, I decided to give it a try. Actually the whole bit is documented in the Configuring Siebel Open UI guide in Siebel bookshelf, but as usual you will also find the steps I executed in this post. Swatches Before we start, let's talk about "swatches" (and I don't mean the swiss watch brand ). A swatch in terms of style sheets is a collection of CSS rules regulating the colors, fonts and icons used in certain areas of web applications. The following image is taken from the Configuring Siebel Open UI guide and explains the concept nicely. Image Source: Siebel Bookshelf, Configuring Siebel Open UI guide . Siebel Mobile Applications use six swatches (A to F) and as per the documentation they control t

Siebel OpenUI : Calender Issues

Siebel OpenUI : Calender Issues Siebel OpenUI currently not supporting SI Classes and Applets referring to that type. That is why Salutation applets are shown with a "question mark". Open UI will not render these classes of applet. Calender functionality is one of the main features of Siebel. Many Customers are using this feature to schedule their activities.In Siebel we have two kinds of Calenders. HI calender and SI type. Normally in home pages you can see SI calenders and that will not work in OpenUI. Even though OpenUI render this applets, that doesn't work properly.  Siebel Non OpenUI version needs SI applets in its home page. So we need to toggle these two applets in between OpenUI and Non OpenUI. In order to do that, we can use Personalization. In the home page view you can Include both Calenders. Now got to Administration- Personalization -> Applets. Create two new records for two applets (HI & SI) To display in HI: GetProfileAttr("IsOpenUI") <

Turtle Shell, Bones and Scripts

תמונה
On a quite regular basis I come across discussions or articles about the Chinese translation of "Oracle" (i.e. the company I work for). The Chinese Oracle logo some years ago. (Image source: sysdba blog ) A Chinese student once translated the characters ??? to me as "Turtle Shell", "Bone" and "Script". At first this is slightly odd to the Western mind but when you do a bit more research you find articles and translations which simply refer to this phrase as "Oracle" (in the sense of the ancient foreseers). In addition, the sages of the internet explain that in ancient China, records of divination and deeds were carved in tortoise shells or other animal bones as a means of storing information, hence the other translation "Oracle Bones". There you have it: This is an ancient form of database. So the Chinese Oracle logo does not only mean "Oracle" per se but also refers to Oracle's flagship product, the database.

Turtle Shell, Bones and Scripts

תמונה
On a quite regular basis I come across discussions or articles about the Chinese translation of "Oracle" (i.e. the company I work for). The Chinese Oracle logo some years ago. (Image source: sysdba blog ) A Chinese student once translated the characters 甲骨文 to me as "Turtle Shell", "Bone" and "Script". At first this is slightly odd to the Western mind but when you do a bit more research you find articles and translations which simply refer to this phrase as "Oracle" (in the sense of the ancient foreseers). In addition, the sages of the internet explain that in ancient China, records of divination and deeds were carved in tortoise shells or other animal bones as a means of storing information, hence the other translation "Oracle Bones". There you have it: This is an ancient form of database. So the Chinese Oracle logo does not only mean "Oracle" per se but also refers to Oracle's flagship product, the database.

Get Ready for Oracle Applications Cloud Release 8 (Updated)

תמונה
As Oracle expands its Cloud business through both acquisitions and new releases of its own Fusion Applications (which are the backbone of Sales, HCM and ERP cloud), a new product line is emerging, nameley Oracle Cloud Applications . This is a combined offer of: Sales (formerly Fusion CRM) Human Capital Management Financials Value Chain Execution Product Value Chain Procurement Project Portfolio Management These applications are based on Oracle Fusion Applications and are hosted in the Oracle Cloud together with other Oracle products such as Marketing Cloud or Service Cloud. Still from an Oracle video on Sales Cloud. With Release 8 of Oracle Cloud Applications (and Fusion Applications), Oracle explores new ways in informing customers about enhancements and new features in the form of a release 8  readiness page on cloud.oracle.com . In addition to checking out the content on that page, the seasoned Fusion Cloud observer may want to peruse the really awesome Oracle Product Features

Siebel Mobile Applications: Create Activities for Outbound Phone Calls

תמונה
The following is a guest post by Sandra Wamsley, Programmer Analyst at Laerdal Medical . In her article she describes how to use a custom Physical Renderer in Siebel Mobile Applications to capture the event when the user taps the phone icon to make a call as an activity record in the Siebel database. The code samples and manifest configuration described are for Siebel 8.1.1.10 / 8.2.2.3. *** When we first began developing our Mobile application, an early request came in for the application to automatically create an Activity when an outbound phone call was made through it.  This was accomplished by having a physical renderer call a business service from within Siebel, which would create the activity. We had to accomplish this on two different business components - Accounts and Contacts - using two different fields. The physical renderer had to accomplish three things: It had to see that the phone icon had been pressed in the application, get the Id of the Contact or Account that the ic

Siebel Mobile Applications: Create Activities for Outbound Phone Calls

תמונה
The following is a guest post by Sandra Wamsley, Programmer Analyst at Laerdal Medical . In her article she describes how to use a custom Physical Renderer in Siebel Mobile Applications to capture the event when the user taps the phone icon to make a call as an activity record in the Siebel database. The code samples and manifest configuration described are for Siebel 8.1.1.10 / 8.2.2.3. *** When we first began developing our Mobile application, an early request came in for the application to automatically create an Activity when an outbound phone call was made through it.  This was accomplished by having a physical renderer call a business service from within Siebel, which would create the activity. We had to accomplish this on two different business components - Accounts and Contacts - using two different fields. The physical renderer had to accomplish three things: It had to see that the phone icon had been pressed in the application, get the Id of the Contact or Account that the ic