us-analytics.png
Get a Quote
blog-Hero.jpg

Blog

OBIEE Tutorial: Preventing Write Back When Using Act As

Share This Post

Recently, I was presented with a unique client requirement. They needed to prevent write back functionality when acting as users who have write back capabilities. They also wanted to be able to turn it on or off depending on the situation, since there are some scenarios where using Write Back in conjunction with Act As is needed. This created a few challenges because of how Act As and Write Back are configured in OBI.

10 Tutorials for OBIEE Power Users

First, let’s look at the Act As and Write Back configuration in my OBIEE 12.2.1.3 test environment.

Act As:

I have set up two users in my proxy table to use for testing.

preventing write back_1

Both of these users are available to weblogic for Act As functionality. For testing purposes, the user Matt has full author access within Answers as well as Write Back capabilities and the user Bill has Read-Only access.

Note: For more information on how to set up Act As in OBIEE 12c, please refer to the Oracle document.

Now, let’s take a quick look in Answers to check the functionality and see how the out-of-the-box session variables behave when using Act As (this will be important later in the blog post).

I’m going to log in using weblogic and create a quick analysis, calling the following session variables:

preventing write back_2

 

 

 

preventing write back_3

Now, I’m going to show the same variables when Acting As the user Matt.

preventing write back_4

 

 

 

preventing write back_5

Notice how the out-of-the-box variables are populated while using Act As the same as if they would be logged in as that user.

Write Back:

For Write Back testing, I have set up a simple template that will allow users with Write Back capabilities to update the Product Name column.

preventing write back_6

 

 

 

 

 

 

 

Note: For more information on how to set up Act As in OBIEE 12c, please refer to the Oracle document.

Now, let’s work through preventing Write Back while using Act As. First, I need to set up a session variable that returns a value when Act As is being used. To do this, open the RPD and navigate to Manage > Variables.

preventing write back_7

 

 

 

 

 

 

I’m going to create a new Init Block using the following SQL to populate the target variable ACT_AS with the value ‘True’ when the RUNAS session variable is equal to the USER session variable:

SELECT CASE WHEN 
UPPER('VALUEOF(NQ_SESSION.RUNAS)') = UPPER(':USER') THEN 'True' ELSE 
'False' END
FROM
TST_BIPLATFORM.OBIEE_PROXY

preventing write back_8

 

 

 

 

 

I am going to use the ACT_AS variable in my custom message template used for Write Back. Make sure to set the Init Block connection pool to the same connection pool as the other variables you are using for Act As. Also, make sure that the target variable’s Default Initializer is set to the same value as the ELSE value in the CASE statement (in this case, ‘False’). This ensures that, if the connection ever fails, the default initializer will populate the variable and users will not lose Write Back functionality. It also ensures that this will be tied with Act As functionality being available for use.

Next, I’m going to alter the SQL in the template used to update Product Name in the customMessages folder to use the ACT_AS Variable. I am going to set the value to ‘False,’ because I only want Product Name to be updated when the Act As functionality is not being used.

preventing write back_9

 

 

Now, it’s time for the test. I’m going to log in as the User Matt and create a quick analysis to show the value of the ACT_AS Session Variable.

preventing write back_10

 

 

 

 

 

preventing write back_11

I’m going to use Write Back as the user Matt and change a value for one of the products in the Product Name column.

preventing write back_12

 

 

 

 

 

 

 

preventing write back_13

 

 

 

 

Next, I’m going to log in as weblogic and Act As the user Matt to see if I can change the value back to its original state.

preventing write back_14

 

preventing write back_15

 

 

 

 



When I click Apply, it notifies me that the update was successful but, when the analysis reloads, the value remains unchanged.

preventing write back_16

 

 

 

 

 

 



I can further verify this by looking at the value in the database itself.

preventing write back_17

 

 

Because the variable value is set to ‘True’ when using Act As, the constraints defined in the template are not satisfied and therefore will not allow Product Name to be altered.

While this is a very specific use case, preventing or allowing Write Back under certain conditions allows for additional layer of flexibility for organizations.

You might also be interested in...

oracle-business-intelligence

Subscribe to Email Updates

Browse by Topic