OBIEE11g Customisations Directory

Doing look and feel customisations in OBIEE11g is not harder then in then 10g, you just need to pay attention where you put stuff. Since the weblogic server tend to overwrite stuff during startup and or updates it’s good practice to have a special directory for your customisations. Here is how you do it in WIndows XP.

First create a new folder say D:\OBIEE11gCustom

Set the security so that everbody can see it, if neccesary make it shared:

Next step is to add the folder to the instanceconfig.xml file:

[Code]

<URL>

<CustomerResourcePhysicalPath>D:\OBIEE11gCustom</CustomerResourcePhysicalPath>

</URL>

[/Code]

In the next article I will show you how to expose it from the weblogic server.

Till Next Time

OBIEE Rittman Mead Bi Forum 2011 abstract survey

For those of you who want to go the Rittman Mead Bi Forum, the abstract survey is open:

http://www.rittmanmead.com/2011/02/rittman-mead-bi-forum-2011-brighton-atlanta-ga-abstract-voting-now-open/

See you in Brighton

OBIEE11g Client only available

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html

and yes Andreas beat me ….. ;-)

http://blog.trivadis.com/blogs/andreasnobbmann/archive/2011/02/10/obiee-11g-client-only-installation-package-available-now.aspx

Till Next Time

OBIEE Sort order in RPD

Don’t panic if the column order in your RPD suddenly has changed from:

to

 

First check if someone (you?) has been playing with the sort options:

Tools > Options > Sort Objects

Till Next Time

OBIEE Using a MSSQL stored procedure as datasource adding a variable:

If our stored procedure uses a variable:

[code]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        John Minkjan
-- obiee101.blogspot.com
-- =============================================
ALTER PROCEDURE sp_dim_Accounts   
@UserName varchar(50) = 'me'
AS
BEGIN
    SET NOCOUNT ON;
    SELECT     dim_Account_ID, Account_Code, Account_Name, @UserName as USERNAME
FROM         dim_Accounts
END
GO

[/code]

You can add the variable by using the VALUEOF() procedure:

 

@VARIABLENAME = N’VALUEOF(NQ_SESSION.VARIABLE_NAME)’

Till Next Time

OBIEE Using a MSSQL stored procedure as datasource

A MSSQL stored procedure can return a table. You can use this table as a normal datasource in your repository.

Let’s  create a basic procedure

[code]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        John Minkjan
-- obiee101.blogspot.com
-- =============================================
CREATE PROCEDURE sp_dim_Accounts   
AS
BEGIN
    SET NOCOUNT ON;
    SELECT     dim_Account_ID, Account_Code, Account_Name
FROM         dim_Accounts
END
GO

[/code]

In the repository create a new table:

Make the type stored procedure:

Add the columns manually:

Add the execute script:

EXEC [DATABASE_NAME].[SCHEMA_NAME].[PROCEDURE_NAME]

You will see that the table symbol has changed:

You can now join it as a normal table to the rest of your model.

Till Next Time