Entries from Siebel Essentials tagged with 'Oracle BI EE'
BI Publisher Demoshelf
Just wanted to share a link to a most useful resource with you: Click here to access the BI Publisher Demoshelf...
Automating rpd metadata export with admintool.exe
This is an update to a previous post on data lineage in Oracle BI EE. As Erik Eckhardt describes in his blog, there is a not so widely known - and unsupported(!) - command line feature in the Oracle BI Administration Tool. It can be used to automate activities such as creating rpd files, importing physical layers, updating connection pools, exporting subsets from projects (which is used during installation of Oracle BI Applications btw) and more. As described in my post on Oracle BI data lineage, we have to export a csv file in order to get data we can use. Here is a way to use the admintool.exe /command syntax to automate this. 1. Create an input file with the following content. Save the file on your drive (example: D:\input.txt) Open samplesales.rpd Administrator Administrator Hide DescribeRepository D:\samplesales.csv UTF-8 MessageBox "Repository description exported successfully" Close Exit This file contains commands to Open the samplesales.rpd using Administrator as username and Administrator as password. The Hide command hides the Administration Tool window. The happy command is DescribeRepository which triggers an export of the rpd metadata to the D:\samplesales.csv file in UTF-8 codepage. This is similar to using the Administration Tool utility manually. The MessageBox command is just given as an example. Then we Close the file and Exit from Administration Tool. 2. Open a command prompt and type (or write the following into a shell script): D:\OracleBI\server\Bin\admintool /command d:\input.txt and execute the script. The admintool.exe will now open the input file and execute the commands, thus producing a metadata export file in an automated manner. In Erik's post you can find more commands. You can also run the Metadata Dictionary export using the GenerateMetadataDictionary command. The syntax for the input file is: GenerateMetadataDictionary Please note that using the /command switch is not documented and obviously not supported by Oracle Support, so please use it carefully and at your own discretion....
Interactive Pivot-style Analysis in Dashboards
Lemon Curry? Being a Siebel guy, BI Publisher was a new product to learn when I ramped up upon Oracle BI EE 10g, the successor of Siebel Analytics. I really love the integration between the "classic" BI EE and BI Publisher. As some of you might recall, Siebel had it's own version of pixel-perfect reporting with Siebel Analytics 7.8.4. In that version, Actuate was integrated with Siebel Analytics and some parameters in instanceconfig.xml are quiet reminders of those times, which of course are over now. Recently, I was preparing a demo for the BI Publisher integration. It is a quick task and I use to do this demo on the fly - just to impress the customer, how easy it is, even I can do it ;-) But I wanted to to something more than just to create a new dashboard page, drag in the BI Publisher Report object and link to the sample report provided with the sample application (be it paint or Sample Sales). So I decided to show how stunningly easy it is to bring an interactive pivot report into a BI Dashboard. BI Publisher incorporates a shy but powerful interactive Analyzer which you can invoke when you are in the BI Publisher Enterprise portal and viewing a report. Just click the Analyze button and you are in the midst of a drag'n'drop pivot-style tool. Cool, I'd say. What's even cooler is that you can save your Analyzer report as a new template, so it adds to your reports layout options. You can then use that template and direct the output to all formats supported (like HTML, PDF, PPT, etc...). These templates are .xpa (Xml Publisher Analyzer) files which can be downloaded, customized (they're plain xml) and uploaded again. Now let's do the trick and click the Link to this report link in the upper right corner. This feature allows you to create a direct URL to that report, maintaining the current layout options. You can do this for any option you choose, so if you're currently viewing a PDF output, you'll get a URL which allows you to download the PDF report (voice from off: "Alright, they got it now.") Next we can use the Embedded Content object in the dashboard editor and paste the URL there and save the dashboard layout. The result: A dashboard page which allows an end user to interact with the data using simple drag and drop pivot patterns. Cool, I'd say again....
BI Office Integration
I am often engaged in discussions how the "Excel users" or "Office users" should participate in an Oracle BI EE project. This user group is often characterized as "not needing Oracle BI", "wanting to stick to their beloved spreadsheets" and "not willing to switch to more advanced BI technologies". Sometimes an argument for continuing to use Excel is the mere fact that Excel supports more chart types than Oracle BI (which is true, for example for the Pie of Pie chart - see image below -, one that was on a list of required chart formats once). Many people have been exposed to slick demos of BI for Office which is of course a very sophisticated and useful solution. But some project teams don't want to install additional software on the client PCs. To please them, I have compiled a list of options that you have - even with older versions such as Siebel Analytics 7.8. In order to solidify the discussion, I have created a small, maybe incomplete compilation of options that we have to integrate office suites (not necessarily limited to MS Office) with Oracle BI. Just to prepare you: Might be a lot more than you expected. Click here to download the file...
Data Lineage in Oracle BI EE
Earlier this year, I had the opportunity to work in a small Oracle BI EE project with a not so small source database. One of my tasks was to enable the project team members to easily identify objects with specific indications such as long-running queries or a high number of requests or a redundancy problem or the like. To put it short, what they wanted was: Data Lineage for Oracle BI metadata The design - and later implementation - included the following Oracle BI Usage Tracking (standard module)combined with presentation catalog metadatacombined with rpd metadataThere were some obstacles on the way, as usual. First, the Oracle BI rpd file is, well, a file and the data is not accessible like in a relational database. A fact which has been subject to criticism in recent times. The same holds true for the presentation catalog which has its information spread across thousands of small xml files. To overcome this, we used the Repository Documentation utility of the Oracle BI Administration Tool. This allows you to create a flat csv file with the dependencies of all objects from presentation layer, business model and mapping layer and physical layer. The screenshot shows the file after the insertion of a primary key column, which is a necessary task if you wish to connect to it as a data source in Oracle BI. In the project we used an import package to load the file into a MS SQL Server database. You can do the same with the presentation catalog using the Create Report option in the Tools menu of the Catalog Manager. Both tasks are purely manual and up to this moment I have not found an automation solution for it (if you did, please drop a comment), which is the main reason why data lineage for Oracle BI is a little bit cumbersome. Whenever the rpd or catalog content changes, an administrator must manually extract the csv files and (ideally) load them into tables in a relational database. As one commenter to this post has found out, there is an execution plan named Data Lineage in the current DAC repository (as created by the installer for Oracle BI Applications 7.9.5). A short investigation reveals that there are indeed table definitions which supposedly hold the data from the rpd and presentation catalog. At the moment this is only in the DAC repository and there is no accompanying ETL mapping in the Informatica repository. I would be so glad to be wrong here - if so, please add your comments below. Data Lineage subject area (inactive by default) in DAC We will see what future versions of Oracle BI Applications bring. Maybe a mapping which loads the csv files into the tables along with a ready-to-use rpd file (just dreamin'...) Now comes the knitting, which means that you have to create complex (physical) joins to glue the rpd metadata together with the presentation catalog data. For a first test you can use the presentation layer object names (table and column) to get first results in Answers. (This post does not deal with the creation of the business model and presentation layer in the rpd file to access the data). The S_NQ_ACCT table holds the valuable data from Oracle BI Usage Tracking, it has a column which contains the request path which allows us to join it to the presentation catalog data. Now we have a somewhat complete data lineage tool. Below is a screenshot from one of the first dashboard prototypes of the a/m project which allowed us to visualize the benefits of caching. There would be more to tell and maybe I find the time to post more on this, but let's dream with me a little more... What about bringing in the DAC repository, the Informatica repository, the Siebel CRM repository (right-click on a Siebel applet and see a report which describes all BC fields, columns and tables and their mapping to Oracle BI)...whoa...just woke up have a nice day...
Fumbling around with the Oracle BI Message Database
not that quickly There is a high number of posts and documentation available on the internet on how to customize the Oracle BI EE User Interface (example here), namely the content of the xml or other files (css, etc) that make up the Oracle BI message database. More commonly known as the msgdb folders. Storing strings and configuration information in easy-to-change text files is of course a benefit but also a curse. Because unlike information stored in a relational database (such as the Siebel CRM repository) it can not be easily merged during an upgrade to a higher release. So simply overwriting the existing files is not an option as an upgrade would just replace the files with newer versions. To avoid this there is a simple but efficient strategy: Copy the files to a custom folder. The trick is that the Oracle BI Presentation service loads the messages from several folder locations in a specific sequence which is revealed below: OracleBIData\web\msgdb\l_xx\customMessagesOracleBIData\web\msgdb\l_en\customMessagesOracleBIData\web\res\customMessagesOracleBI\web\msgdb\l_xx\messagesOracleBI\web\msgdb\messagesl_xx in the above list stands for the language specific folders. Standard (vanilla) files typically reside in the OracleBI folders, customers are encouraged to copy these files to the OracleBIData folders. So when you want to change the content of a specific string such as "My Dashboard" you would do a text search in the OracleBI folder and find the uimessages.xml file. Before manipulating the file you need to copy it to the OracleBIData\web\msgdb\l_en\customMessages folder (create the folder if it does not yet exist). Now you can safely make changes to the file and restart the Oracle BI Presentation service to verify your changes....
Googlin' Bookshelf
file under: rtfm Know that feeling of getting stuck while searching the pdf version of Siebel Bookshelf? Want to use your favorite search engine to look for that specific string? Since Oracle has put all of its documentation - including Siebel Bookshelf - online on OTN, the search bots of Google and the like have happily parsed them and so it's now a part of the index databases of the internet giants. The following is a Google example, using the site: keyword to narrow the search to Siebel Bookshelf 8.0, but it should work in other search engines as well. First thing is to verify the base URL for the bookshelf by simply browsing to a document in OTN. Doing so you find that the base URL for Siebel Bookshelf 8.0 is download.oracle.com/docs/cd/B40099_02 Now let's open Google and type in your query, for example "EAI Siebel Adapter" site:download.oracle.com/docs/cd/B40099_02 (of course you can bookmark this for later use) Et voilá: all results for "EAI Siebel Adapter" Works for Oracle BI, Oracle Database, you name it ;-) have a nice day...
Marketing Segmentation, File Export and Dashboards
While delivering an Oracle BI EE course, I came across an interesting requirement. End users want to download csv files and modify them on their workstations. External systems should access these files, too. Of course, this can be accomplished using the standard download links in Answers and Dashboards. However the number of records that these end users want to handle is in the millions, so any system in between (like Presentation Service or the browser itself) would be a bottleneck. Furthermore there are reports of browser crashes when users try to load very large tables. Given the fact that the Marketing Segmentation module of Oracle BI EE has a standard functionality of producing large export files (comma-separated, fixed width, XML) and a nice interface to control the schema, the content and the output format of the files, it is an ideal candidate for a proof of concept. First, you need to modify the rpd and create a Target Level, a List Catalog and the accompanying Qualified List Item, which is typically a primary key and glues the former two together. If you are not familiar with the marketing metadata in the rpd file, here is some documentation and there is also a nice training you can book. Second, open the BI Client and navigate to More Products > Marketing > Create a List Format. List formats define the columns you would like to export and the output format (CSV, XML or even direct inserts into a database table). Here we have created a simple list format. Make sure that you check the “Re-qualify list results against original segment criteria” check box to make your list format generic and it works with any segment. You can set Options such as output format, headers and footers and use the Preview tab to see how it works. Next, we create a simple segment from our target level and associate it with the list format (List Preview File Format in the Advanced Options tab). Click the Generate Lists button. In the popup dialog you can issue commands to run the list generation or to preview the list. The final task is to enable end users to access this dialog. A simple solution would be to permit access to the segment designer, but let’s try a more elegant way to access the list generation from a dashboard page. We could use the Embedded object feature but we need the URL behind the popup. So let’s launch good old firebug and inspect the popup. In the Script tab you can expand the current URL and see that the following URL is used to retrieve the Preview popup: http://localhost/analytics/saw.dll ?MktgEditExportFormatReport &Action=previewFromSegment &Path=%2Fusers%2Fadministrator%2FCustomer%20List%20for%20Export &SegmentPath=%2Fusers%2Fadministrator%2FWest%20Customers It is interesting that the URL has two path parameters, one for the list format, the other one for the segment. So this allows for some automation scenarios, where one could think of variables passing the path of a segment. Now we can embed the URL into a dashboard The final result: A dashboard page from which end users can generate and download export files....
Oracle BI EE Variables
really quick Some time ago I compiled a document about the various variables in Oracle BI EE, how to set them, how to get them etc. We have the following variables in Oracle BI EE: 1. Server-side variables 1.1. Repository variables (dynamic and static) 1.2. Session variables (system and non-system) 2. Presentation variables I tried to condense the information of the a/m document and have created a single page doc which gives an overview of the variable types and how to initialize the variables set the variable valuesaccess the variable values from within the rpd and Answers (all about the notorious @{variable} style syntax in Answers) click to enlarge You can download a pdf version of the summary here....
Remove system-wide default settings in Oracle Answers
d'oh I am spending much time on delivering Oracle BI EE training these days. I like these opportunities of inquisitive questioning and recently read in an internal doc about creating dashboards to "never use the 'save as system-wide default for this data type' option". Otherwise things would be screwed up. The privilege to save formatting for columns in answers as system-wide default is in fact a default privilege, so almost anyone can do it. And some research shows that we can really screw things up badly: First, let's use the Sample Sales demo application, delivered with Oracle BI EE 10.1.3.4 and set the system-wide default for text columns to something like "Garamond, 14 pts, brown color". You can open any request in answer, do the setting and leave the request. click to enlarge The dashboard now looks really screwed: click to enlarge How to get rid of system-wide defaults The answer is to be found in the presentation catalog. Buried deep inside the system folder must be the system-wide defaults. And indeed, using Catalog Manager in offline mode we are able to find the metadata subfolder and the _datatype_formats element. Be very, very, very careful when you do the following! You might screw things up even worse. So make sure you do a backup of the catalog before you start. Right-click the _datatype_formats element, select Properties and click the Edit XML button. Click Edit again to set the editor in write mode. Then carefully delete the entry that annoys you and save the entry. Click to enlarge After restarting the Oracle BI Presentation Service, we can check the dashboard: click to enlarge Summary Using the system-wide default for columns of the same data type might result in unexpected and undesired formatting. Using the Catalog Manager you can edit the metadata to remove the entries. However, it sometimes would be best to remove the privilege to save system-wide defaults....
Oracle BI EE 10.1.3.4 has arrived
A new release of Oracle BI EE, formerly known as Siebel Analytics has been made available for download last week. There are several new features and interesting points about the product direction. My personal highlights are: Integration with EPM Workspace and Smart SpaceDiscoverer .eex to .rpd migration toolNew sample application with support for marketing segmentationEnhanced wsdl support for BI PublisherEnhanced DAC Client (released independently) that supports upgrades from Analytics 7.8.4 But let's discuss each feature in detail. Most of this information is taken from the documentation and while the product is still hot from the oven, I was lucky to try a few things. As with all new features, they will have to prove their practicability in real life. We'll see... General New Features Integration with Oracle EPM Workspace, Fusion Edition Oracle Enterprise Performance Management Workspace (EPM Workspace) is a component of Oracle's Hyperion Foundation Services. It is the central Web interface for users to access all Performance Management content and tools. In the new release, the following Oracle BI EE applications have been integrated into EPM Workspace: Oracle BI AnswersInteractive DashboardsDeliversBI Publisher Integration with Oracle Smart Space, Fusion Edition Oracle Smart Space is a personalized information delivery solution for Business Intelligence and Enterprise Performance Management that uses configurable desktop gadgets to deliver BI and EPM to every user in the enterprise, utilizing the Windows desktop. In addition, Oracle Smart Space includes a development toolkit for creating additional gadgets that employs common development languages and methodologies and a secure instant messaging system for shared decision making. You can launch and interact with Oracle BI Interactive Dashboards, Answers requests and BI Publisher reports in the Smart Space Content Viewer and Smart Book gadget and add them to the Favorites gadget. You can use Smart Space Collaborator to share Oracle BI content with other Smart Space users. You can also configure iBot results to be sent as Smart Space notifications and view these in the Notification gadget. You can set up for users to download Oracle Smart Space and Oracle Smart View for Microsoft Office from within Oracle BI. Once Smart Space is connected to Oracle BI, you can use Windows Explorer to browse the Oracle BI Presentation Catalog and see the folders (Shared Folders and My Folders) and documents (Dashboard and Answers request) that are available to you. Migrate Discoverer eex files to rpd files The new release includes a utility to accelerate the migration of Oracle BI Discoverer metadata (in the form of an EEX file, version 10.1.2 or higher) to Oracle BI EE metadata (in the form of an RPD file). The utility is a command line executable (MigrateEUL.exe) and accompanying properties file that can be found in the \OracleBI\Server\bin directory. An instruction document can be found in the \OracleBI\Server\Document directory. Reading the document, you find a chapter named "Why migrate to Oracle BI EE?" and the answer is given as a summary of the Oracle BI EE functionality and benefits. The rest is up to you... The screenshots below show a first encounter with the utility. I have converted a simple Discoverer EUL into an rpd file. It completed the task without errors, however there is additional manual work to be expected within the rpd file. migrateEUL.exe command line utility, click to enlarge rpd file generated by migrateEUL.exe, click to enlarge Time-aware line charts A new type of line chart (Line Time Series) is available to plot time series data. The chart automatically scales the X-axis based on the time that has elapsed between data points. The chart requires a single date or date-time data column to be selected on the X-axis. It has a single Y-axis, but supports multiple data series. There are several formatting restrictions for this chart type. New line time series chart, click to enlarge Support for Oracle WebLogic Server 10.x. (formerly known as BEA WebLogic Server) You can use Oracle BI EE and Oracle BI Publisher with the Oracle WebLogic Server New Sample Oracle BI Application and Data Set A new sample Oracle BI application and data set called "Sample Sales" has been designed to better and more fully illustrate the capabilities of Oracle BI 10.1.3.4. It showcases presentation (Answers formula building, resentation Variables, Filtering, Layouts, Navigations, and so on) and modeling techniques. The content is designed to demonstrate as much as possible of OBI EE capabilities and is primarily meant to help customers who want examples and templates to extract ideas from. This new set is meant to replace the former Paint sample content. The new Sample Sales application includes numerous reports organized in 20 dashboard pages around the following: Rankings and ToppersTrends and HistoryTiering and DistributionDetailed ReportsLists and Segmentation (Marketing) Particularly nice features of the new sample application are the detailed help and the good quality of sample data. I am also positively surprised about the presence of marketing metadata, because the marketing segmentation functionality is something that probably only a few people using Siebel Marketing are aware of, yet it can be used standalone as well. Sample Sales comes with a detailed online help, click to enlarge. The Rankings and Toppers dashboard of the new sample sales application Marketing Segmentation: Prompted Segmentation and Contact Planning Rules The segment designer now supports the "is prompted" operator as filter criteria which enables passing of values (such as a list of customer Ids) into the segment, thus enabling dynamic segments for so-called event triggered campaigns (also referred to as inbound campaigns). Contact planning rules allow a company to place volume, frequency and recency rules on all forms of communication across customer, channel, and program dimensions. Rules are created as special segments which act as a filter for other segments. Segment Tree Designer New Features for Oracle BI Publisher Besides the integration with EPM and Smart Space, which we have discussed above, there are the following notable new features for BI Publisher: Support for multidimensional data sources Oracle BI Publisher can now access the following multidimensional data sources: Oracle's Hyperion EssbaseMicrosoft SQL Server 2000...
Student Favorites
one-stop shop This is a somewhat structured list of websites which are related to Oracle, the Siebel CRM and Oracle BI EE product lines as well as training and documentation links. Please also consider the list of favorite blogs on this site. Oracle Website Siebel Product Site Business Intelligence Product Site Oracle Technology Network Siebel Bookshelf download and online library Oracle BI EE documentation download and online library Oracle BI Applications documentation download and online library Oracle Education Oracle Certification Certification Upgrade Information Page ilearning - web based training for Siebel (login required) Oracle BI EE Tutorials (free) Oracle Software Download - edelivery (registration required) License Codes metalink3 - support portal (login required) Special Links: Siebel Query Language online reference (Personalization Administration Guide) Ospace - Oracle Applications Business Community...
Oracle Master Data Management
a closer look These days I am reading a white paper on Oracle Master Data Management (MDM). A customer is interested in training on MDM and I wanted to find out what role the Siebel Customer Data Integration (CDI) and Universal Customer Master (UCM) solution and Oracle BI EE (formerly known as Siebel Analytics) play in the Oracle MDM offering. You can download the technical white paper on the Oracle Master Data Management website. The paper is in fact helpful to help us define the problem areas of existing IT infrastructures, the half-baked solutions that lack the power to combine operational and analytical data into a single view of the customer. It also defines the ideal information architecture and gives a nice overview of the Oracle products (yes, including Siebel CDI, UCM and Oracle BI EE) available to build or buy an MDM solution. The N² problem It starts with the N² (n square) problem that occurs when data synchronization between transactional applications is accomplished with code. IT managers all over the globe experience this on a daily basis. Enterprise Application Integration Of course there is a more elegant solution established over the last decade which is usually described as an information bus or hub-and-spoke topology, supported by Enterprise Application Integration (EAI) technology. Service Oriented Architecture EAI has recently evolved into serice oriented architecture (SOA) where interfaces can be called from an application's service layer independently of the programming language or software platform. SOA is more than just synchronizing data, it also supports business process orchestration across separate systems. Data Quality So when your IT infrastructure has evolved to SOA, you will find that the old saying "garbage in, garbage out" is more true than ever before, because data quality is crucial to successful business process integration. So the paper concludes that an MDM solution that really deserves this name must also embed data quality solutions. Data Warehousing, Business Intelligence and Reporting Most companies today have established data warehouses and ETL processing that pulls data from the transactional systems into the DW. And most of them have invested in Business Intelligence tools to analyze the billions of records that they store in the DW in order to drive business decisions. So far so good. But the following should make us think twice: Company A rolls out the new CRM system.A few years later, the analytical CRM project is startedShortly after the first pilots, the data quality project is launched. So the BI system suffers from the poor data quality of the transactional systems. Garbage in, garbage out again. An ideal information architecture The paper boldly announces the ideal information architecture which brings the MDM system into play as a central instance which enables metadata and data cleansing and forms the base source system for ETL. Building an MDM solution using Oracle Products Today, after uncounted strategic acquisitions, Oracle is able to support the ideal architecture with its software stack. So let's look at the architecture from a software perspective. Oracle 11g with RAC for the DatabaseOWB for ETL and ProfilingODI for ETL and Data MigrationMaster entity data modelsESB for integrationBPEL PM for orchestrationPortal for the user interfaceIdM for managing usersWS Manager for managing servicesBI EE for analyticsJDeveloper for creating or extending the MDM management application. Oracle utilizes these technologies to build its MDM Data Hubs. Customers who want to build their own MDM solution should use these components as well. Summary MDM can be seen as an approach to solve the common IT problems like ever increasing data volume, poor data quality and lack of business insight. Oracle offers a variety of products to build a solution and also offers pre-built MDM applications like Oracle Customer Hub and Oracle Product Hub. Siebel CRM is represented by the Siebel CDI and UCM applications and by Oracle BI EE (formerly known as Siebel Analytics). So to get full grips to an MDM solution, there is a lot to learn and a lot to gain. have fun @lex...
Oracle BI courses accepted toward Siebel Analytics certification
get certified Until recently, all those who took one of the Oracle BI classes and wanted to pursue the certification (which is still based on Siebel Analytics 7.7 and the respective course offerings) found to their dismay that Oracle Certification only accepted those for the exam who sat the Siebel 7.7 Analytics classes. However, these days the following message appears on the Oracle University website: "Due to the decreasing availability of the Siebel 7.7 Analytics courses, Oracle Certification will accept the Oracle BI courses toward Analytics certification. However, please remember that the Siebel 7.7 Analytics courses remain the best way to prepare for these exams and Oracle BI courses may not sufficiently help prepare candidates." click to enlarge It is in fact true that the Oracle BI courses do not cover all the topics that might be subject in the exam, but it is a good solution for those who wish to add "Certified Professional" to their business cards....
Oracle BI EE Courses
get trained So you have to get up to speed with Oracle BI EE 10g (formerly known as Siebel Analytics) and don't know where to start? click to enlarge This post is here to help. It organizes the course offerings by products so you should be able to easily identify the ideal learning path for you or your colleagues. Please click on the link to view details about the course content and schedule. General Overview, Architecture of Oracle BI EE 10g: Oracle BI 10g: Analytics Overview (1 day) Oracle Answers, Dashboards, Delivers, BI Office, Briefing Books, Presentation Server: Oracle BI Suite EE 10g R3: Create Reports and Dashboards (3 days) Allows to certify as Siebel 7.7 Analytics Application Developer Professional Oracle BI Publisher (formerly known as XML Publisher): Oracle BI Publisher 10g: Fundamentals (3 days) Oracle BI Administration Tool, BI Server: Oracle BI Suite EE 10g R3: Build Repositories (5 days) Allows to certify as Siebel 7.7 Analytics Server Architect Professional Oracle BI Applications, Pre-built ETL, DAC Server, Informatica Repository: Oracle BI Applications 7.9: Develop a Data Warehouse (5 days) Allows to certify as Siebel 7.7 Data Warehouse Developer Professional Siebel CRM Marketing Enterprise (Uses Integration with Oracle BI EE 10g): Marketing Manager (Siebel 7.7) - User perspective (2 days) Marketing: Server Architect (Siebel 7.7) - Administrator perspective (3 days) Siebel Pharma Analytics, Disconnected Analytics: Pharma Analytics (Siebel 7.8) (2 days) Real-Time Decisions (RTD): Oracle BI 10g: Real-Time Decisions (RTD) for Developers (3 days) These courses are offered worldwide as instructor-led classroom trainings or as live virtual classes via the internet. If you feel that 27 days of training is not enough (or too expensive ;-) there is another possibility to quickly get to grips with the one or the other Oracle Product. This is the online tutorial offering at the Oracle Technology Network. The tutorials on Oracle BI are free of charge as all the other tutorials that you find there. Happy learning @lex...
Nested Presentation Tables - OBI EE Style...
...or "- " vs. "->" If you are a frequent user of Oracle BI Answers, you might find the following rather useful As you know, presentation tables can be nested or indented to ease navigation. I know you're smiling now and think "why is he bothering me with this kindergarden stuff?". Of course you know how this is achieved. Let's visit the Administration Tool: Notice two things here: First, the stop sign icon, which indicates a Presentation Catalog in the Oracle BI Applications rpd file which you should no longer be using. Second, the well-known use of the hyphen and space "- " combination in order to achieve the indentation of presentation tables. Let's label this "Analytics Style" because this is the way it has been done. Now let's have a look at the new presentation catalog: We notice that there are no hyphens and spaces, which by the way made some of the presentation tables inaccessible for external systems in the past. When you open the Properties dialog for an indented presentation table you see how it's done: Simply type "->" in the Description and the BI Presentation Server will interpret this as the command to render an indented presentation table. The description will render into a tool tip and yes, it does include the "->". Let's call this "OBI EE Style" and use it from now on. Happy indenting...
Search All Blogs
Google Search
Feed Subscription
If you use an RSS reader, you can subscribe to a feed of all future entries tagged 'Oracle BI EE'.
