Posts
This is no something that just became available yesterday. The ability to gain access to OBIEE through mobile devices such as Iphone, Ipad is going to become a way going to the future. OBIEE has the feature to do just that. After all, smart phone's raising popularity is changing the way we interact with the world. If you want to know how to set up OBIEE Mobile, oracle has an excellent document. This is not as complicated as we might think, nor is it the same as we used to understand as Disconnected Analytics.Go here to find out howHave fun playing!Until...
Wednesday, March 28, 2012
Saturday, March 24, 2012
OBIEE 11G: Dealing with errors when starting Services
Hello againYou can see that OBIEE 11g has made a lot of architectural changes from 10g. When it comes to managing services, it is done on weblogic instead of managing it as OS services manually. In this entry, we will just go over something simple yet common scenario of starting services, it is helpful in getting familiar with how 11g works.So, let's start with a problem that I can't have access to the presentation service, the link isn't working....
Thursday, March 22, 2012
OBIEE 11G: Easy way to understand the High-Level Architecture and Sub-components
Hello here again.Today I want to talk about the OBIEE 11g's architecture and how to navigate through some of the important components. 11g utilizes the concept of web logic, which makes its architecture very different from 10g. There are a lot of documents and articles that gives excellent introductions on how it works. However, nothing really clicks unless you actually work on it.Therefore, I am going to lay out the basic ways to look at 11g's...
Tuesday, March 20, 2012
OBIEE11G Presentation Variable To Dynamically Switch Filtered Column Values Based On Dashboard Prompt Values
Hello Again
Today, I want to blog about a scenario that I have encountered, which is very interesting to me. Let me describe the scenario without getting too much into details.
In the dashboard, the user want to be able to have an option to filter either by Month or by Year with a switch. In other words, the first thing they want to do on a dashboard is to select the option of "Year" or "Month". Once the option is selected, the next prompt...
Configuring Incremental Loading In Oracle BI Apps Part 5
So far we have been configuring Informatica to implement the incremental mapping logic. The last piece is to configure DAC to run these workflows and to ask DAC to tell informatica what these parameter values should be. It is a fairly simple configuration that I will take you through now.Here in DAC, we already have 2 source system parameters, so now we can go ahead and create a task for PA_EVENT: Notice that in the Task set up, there are 2 fields:Commend...
Thursday, March 15, 2012
Configuring Incremental Loading In Oracle BI Apps Part 4
From last time, we just went through the whole process of building the Informatica Mapping with incremental logic. This time, let's create the session and workflow.The process of doing it is pretty standard and straightforward, I will just high line the few areas that needs attention.First of all, we will have 2 sessions and 2 workflows, one for full load and the other for incremental load. Both session will use the same mapping that we just created....
Monday, March 12, 2012
Configuring Incremental Loading In Oracle BI Apps Part 3
In the previous post, we have covered up until configuring the lookup transformation. So now we know that we have 1 output from lookup transformation and it is brought into the expression transformation.So from there, as we know that the lookup output are either going to have a list of records that satisfies the lookup condition or it is NULL when it doesn't satisfy the condition. In expression, will define meanings for the NULLs and No-Nulls by...
Wednesday, March 7, 2012
Configuring Incremental Loading In Oracle BI Apps Part 2
In the previous post, I briefly talked about how Incremental loading works and how to go about it at the high level. So, it's time to get to the details.So let's start with an easy example that there is 1 source and 1 target, which is PA_EVENT table. This table has 3 unique columns "Task_ID", "PROJECT_ID" and "Event_Num". Before we start with the mapping, let's make these 2 columns the primary key in target designer: In Dac, make sure we have 2 global...
Tuesday, March 6, 2012
Configuring Incremental Loading In Oracle BI Apps Part 1
HelloAs we all know, BI Apps is a package of tools with out of the box configuration catered to specific business area. It consists of pre-build Informatica ETL mappings, Dac Tasks and OBIEE data models & dashboards. More often than none, we have to customized these pre-build objects in order to have it fit in to our specific project environments. These customization includes adding new fields across the ETL, changing the data models, adding incremental logic to non-incremental mapping and so on. Today, let's talk about how to configure Incremental...
Subscribe to:
Posts (Atom)
