Posts

Automated RPD updates using UDML (Unix or Windows Env)

http://oraclebizint.wordpress.com/2008/04/04/oracle-bi-ee-101332-udml-to-automate-repository-updates-migration-of-repositories-from-development-to-testproduction-environment/

Changing RPD Connection Pool Passwords automatically for migration (Windows Env)

Image
If you had gone through my blog entry here, i would have talked about using UDML as a way for automating migration from dev to test/prod environments. But the major problem with UDML is that one cannot update the passwords of Connection Pools, Users etc since the UDML expects them to be encoded. In such a case, for updating passwords alone we can use an undocumented command line switch option for the AdminTool. For example, look at the screenshot below. This is nothing but the connection Pool property of the ORCL database. Here, we would like to change the schema names and its corresponding passwords. For example, we would like to change the schema to SH and also would like to change the password. In order to do that, open a text editor and enter the below command. Save the file in the same directory as the Admin Tool ({OracleBI}\Server\Bin). If not, then you would have to give the full path of the file. Open Dev_Machine.rpd Administrator Administrator SetProperty "Connectio...

Multiple RPD & Presentation Services on Single Server

Image
Courtesy: D£bashis' Blog The objective of the thread is to understand the process of configuring multiple RPD and Presentation service in same BI server instance .Once that will be understood it can be further extended in scalable solution to integrate the approach on multiple server based instance as per business demands .The OBIEE suite documentation mentioned this functionality could be achieved but never mentioned the detail steps how to achieve this . The initial bit could be found at below URL of Mark Rittman though not in detail : http://www.rittmanmead.com/2007/09/11/managing-multiple-presentation-services-on-the-same-unix-box/ My goal in this thread is to clearly define the entire process however multiple Presentation Services instances on a machine is “NOT SUPPORTED BY ORACLE” . The effective use of this approach will support multiple RPD editing online and also modifying multiple BI catalog online through two different instance .Also this would facilitate the ...

Adding hints without Repository (RPD) change

Image
Adding hints without Repository (RPD) change Adding hints at the table level or join level is most common however requires a RPD change. This involves server restarts and downtimes. Sometimes it may be necessary to use different hints in some specific answers based reports. And that needs a way to apply hints in OBIEE Answers level, here is how… NB: These hints are always overridden by the repository hints, so in order to make these to work there shouldn’t be any hints in the repository atleast for the same tables. 1. Go to BI answers and start a new request 2. To add a report specific hint in the request, the first column in the request should have a function with the hint as shown here As shown in the above diagram the evaluate function is used to create the hint in the database sql but with the table alias, to know the table alias – use the Query repository utility in the BI Admin tool   So in this case the alias will be T69092. It is very...

Between Prompts for Date Columns

Image
Say you need a report containing Start Date, Sales and Number of Days where Number of Days is the number of days between the values chosen in the dashboard prompt, to achieve this using Presentation Variables. This is a variation of the approach that we saw earlier here. Lets start with creating a dashboard prompt. This dashboard prompt shall contain 2 prompts on any column. For both the columns, in the formula tab enter the below formulas CASE WHEN 1=0 THEN CHANNELS.TOTAL_NAME ELSE ‘Test’ END CASE WHEN 1=0 THEN CHANNELS.TOTAL_NAME ELSE ‘Test1′ END We have used the above formula in order to protect the columns from getting the filters. This is very important for setting presentation variables and at the same time not affecting any columns Now, for both the prompts convert the Results to SQL Results and enter the below SQL SELECT DISTINCT TIMES.CALENDAR_MONTH_START_DATE FROM SH2 In the above case, TIMES.CALENDAR.MONTH_START_DATE is my date column. Make both th...

OBE for Oracle BI EE (Link for Life)

Oracle BI Online Tutorials : http://apex.oracle.com/pls/apex/f?p=9830:bi:4045727751880523 Expaling things like; Component : BI Admin Tool # Creating a Repository Using the Oracle Business Intelligence Administration Tool # Setting Up Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool # Cloning and Synchronizing Oracle BI Requests and Dashboards Using Content Accelerator Framework # Setting Up Usage Tracking in Oracle BI EE # Creating and Modeling Aggregate Tables # Merging/Importing Objects from Different Repositories using Oracle BI Administration Tool # Using Oracle OLAP 11g With Oracle BI Enterprise Edition # Integrating Oracle Essbase with Oracle Business Intelligence Suite Enterprise Edition # Federating Essbase and Relational Data Sources in Oracle Business Intelligence Suite EE+ Component : BI Answers # Creating Interactive Dashboards and Using Oracle Business Intelligence Answers Component : BI Delivers # Sending Alerts Using Oracle ...

Using Initialization Blocks with LDAP and database queries to control authentication and authorization

Image
Courtesy: Borkur Steingrimsson To set up an existing LDAP server to validate the credentials of the use who is logging on to the OBIEE we first open the Administrator tool and in the Manager->Security… tool we define a new LDAP server: The values you enter here are, of course, dependent on your system and your LDAP administrator can give you the correct values you need. But once you have defined an LDAP server we pop over to the Manager->Variables… tool and start the real work. First off we define an Initialization Block called something like LDAP Init Block. An Init Block needs a data source, so we define one by clicking on the ‘Edit Data Source…’ button and choose data source type: LDAP. Click on the ‘Browse…’ button and select the LDAP server we defined before. You can actually create new LDAP servers here as well, by clicking the ‘New…’ button (which just starts the same wizard we used previously). Next we need to map LDAP attributes to Session Variables. Click ...