Error : access denied for user to path /users/weblogic/_portal/dashboard layout error

Last week, i faced a issue when i uploaded new RPD /Catalog on BI server. Initially Presentation Services were not coming up.Once it started and i logged in using weblogic user, i got an error :

access denied for user to path /users/weblogicand
access denied for user to path /users/weblogic/_portal/dashboard layout error

I searched many articles where they mentioned about GUID refresh,which seemed to be a long and cumbersome process.
I tried to analyse the issue and found that it was caused due to “USERS” folder and “Users.atr” file present inside the Catalog folder. I tried something which to my surprise, worked out. So thought to share it with my readers here.

original catalog (OFS) path: \Oracle\Middleware\instances\instance2\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\OFS\root\users

NEw Catalog (OBA) Path: \Oracle\Middleware\instances\instance2\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\OBA\root\users

1. delete the folder and .atr from OBA (path defined above)
2. Copy folder and .atr file from OFS original Catalogs and paste it here in OBA catalog path
2. Restart the BI services
3. Login using the user

If it still doesnt work for you then you can try two other methods:

1)  RPD Users deletion
Open the rpd offline before deployment, Goto Manage -> Identity->users .Check if any users are there in the rpd, if so remove them. Now deploy your rpd again.

2) Refresh GUIDs

Its always a best practice to refresh GUIDs, when uploading new rpd/catalog. If the same user name exists in both directory servers (original and new), the original user GUID may conflict with the user GUID contained in new server.A refresh forces the system to reference the user GUID contained in the new directory server.

Follow the below for Refreshing GUIDs:

1. Get the RPD&Catalog to target Machine. Make sure the BI Servers are down
2. Add/Update the below in instanceconfig.xml  (ORACLE_INSTANCE/config/OracleBIPresentationServicesComponent/


3. Add the below in NQSConfig file  (ORACLE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisn) 
4. Save both files
5. Open FMW (Entrerprise Manager) and load new RPD and Catalog. Click Apply and Click Activate Changes. Don’t restart from EM
6. Go to Command line and using opmnctl command to restart the servers
->opmnctl startall
Wait for sometime. (The Presentation server will be stopped automatically)
Now stop all the services using below command
->opmnctl stopall
7. Once the servers are down, UNDO the changes done in both config files.
 instead of making “UpdateAccountGUIDs” to “none” , you should comment the whole tag to improve BI presentation services restart time
8.Start the servers again and try login to Answers.

OBIEE 11g – Export/Print to PDF Does Not Include All Rows

We face this issue about export/print of an analysis to pdf format in OBIEE 11g, where it dos not export all rows. But if you export to an Excel or HTML, it exports all the rows without any issue. 
This issue has nothing to do with the number of rows but the file size which is mentioned in Config File and is limited to 8MB by default.
Need to change the size limit in one of the configuration files. Follow the below steps to achieve it.

1. Navigate to \instances\instance1\config\OracleBIJavaHostComponent\coreapplication_obijh1\
2. Open config.xml file in an editor and search for  the below lines

        3. The default size is 8 MB (1024*8 = 8192), you can increase to the size you want. If you want to set unlimited, then replace 8192 with 0 (zero) but it’s not recommended.
4. Restart BI Services.
For example: you can increased file size to 16 MB like in instance, 



Enjoy till next time 🙂

Adding Mouse hover text on column Rows/data in OBIEE 11g

Creating a report that contains HTML links or mouse hover is quite easy now. You can even “parameterize” the HTML link to include values from other columns on a row by row basis. For example, if you have a product column, and wish to create a column containing a URL which will redirect the user to a Google search using the Product  value as the keyword, here are the steps to implement it in OBI report :
1.     Create a report, and add any column
2.     Choose the Edit Formula for that column
3.     Enter in HTML using OBIEE syntax, such as this in formula area:
a)   to add hyper link:
‘<a target=”_blank”
href=”’ || Products.Name || ‘&btnG=Google+Search”>’ || ‘’
b) to add mouseover :
4.     The single quotes signify a string
5.     The pipes || (in hyperlink) act a string operator to concatenate HTML with an actual OBIEE column.
6.     NOTE: we’ve added the target =”_blank” tag to open the URL in a new browser window
7.     NOTE: if the column values contain spaces, you may need to enclose the column in a REPLACE function to replace spaces with %20, which represents a space in a URL.
8.    NOTE: In mouseover HTML text,  you can place the mouseover text in quotes and then mention the column name.
9.     Once you are finished editing the formula click OK and then go to the
   Column Properties -> Data Format tab. Override the       Default Data Format and select Treat Text As : HTML

Using Repository Variables in Conditional Formatting in OBIEE 11G Reports

Using Variables in Conditional formatting in OBIEE  11G
You can reference variables in several areas of Oracle BI Enterprise Edition, including in analyses, dashboards, KPIs, agents,filters and conditional formatting. There are two types of variables that you can be created through RPD :
  • Session
  • Repository
Session Variables
A session variable is a variable that is initialized at login time for each user. When a user begins a session, the Oracle BI Server creates a new instance of a session variable and initializes it.
There are two types of session variables:
  • System — A session variable that the Oracle BI Server and Oracle BI Presentation Services use for specific purposes.
System session variables have reserved names that cannot be used for other kinds of variables (such as static or dynamic repository variables and non-system session variables).
  • Non-system — A system variable that the administrator creates and names. For example, the administrator might create a SalesRegion non-system variable that initializes the name of a user’s sales region.
The administrator creates non-system session variables using the Oracle BI Administration Tool.
Repository Variables
A repository variable is a variable that has a single value at any point in time.
There are two types of repository variables:
  • Static — Repository variables whose value persist and do not change until the administrator decides to change them.
  • Dynamic — Repository variables whose values are refreshed by data returned from queries.
The administrator creates repository variables using the Oracle BI Administration Tool.
Syntax for using Repository variable in Conditional Formatting:

We have a reporting requirement where the Client wants conditional Formatting to be maintained from DB / RPD. So we tried lot of ways using dynamic filters, BINS but nothing worked out. Then we made a way by creating CASE statements and then utilizing its value in Conditional Formatting.

1)    Repository Variables are defined using the Variable Manager within the Oracle BI Administrator (Manage> Variables).

2)    Create a Dynamic variable and a INIT block in RPD

Now we have 4 Dynamic variables seen above. 
3)    We planned to have conditional formatting  using 2 values as below in Answers Page, Column Threshold_value (column -> Edit Properties-> Formula) :
Case when Threshold_value < 143.1_low then 0 When  (Threshold_value >= 143.1_low and Threshold_value < 143.1_high) then 1 Else 2  END
4)    Then go to same column-> Column properties-> Conditional Formatting
Add condition on column “ Threshold_Value” as :
Threshold_value = 1 , and in formatting set color = Red
Threshold_value=2 , and set color = Yellow.
%d bloggers like this: