Row Wise Initialization in OBIEE11g

Row wise initialization allows BI Server to create session variable dynamically when session begins and it initiate values at that time.

For example in my previous post I explained Data Level Security there I created one variable which returns one value as shown in below screen shot.

But in row wise initialization option allows BI server to create dynamically when session begins.

Create one initialization block with below query and assign connection pool which we created earlier while explaining Data Level Security.

select distinct 'REGION',country_region as varreg from countries.

Click on ok.

And click on Edit Data Target to enable row wise initialization as shown in below screen shot.

Click on ok.

Now click on Test button to test the Initialization block.

Here we initialized one variable with list of values.This REGION variable we can use in Data Level security and the process is same as I explained in that post. Only in Identity manager in fx formula we need cahnge as below.

"SH"."COUNTRIES"."COUNTRY_REGION" = VALUEOF(NQ_SESSION.REGION)


Bye ...... Until next post