OBIEE Online Training

Monday, June 27, 2011

Financial reporting rpd using obiee

Hi,
      Building RPD and Financial Reporting  by using multidimensional  essbase datasource in obiee

http://www.slideshare.net/alooa2/financial-reporting-rpd-using-obiee-7968605


Thanks and Regards,

Deva


Thursday, June 23, 2011

Migrating Application Roles from Dev to UAT server and Production server.

Hi,

Reference:

To move Application Roles, please kindly review the following information:
Oracle Fusion Middleware Application Security Guide 11g Release 1 (11.1.1)
7.3.2 Migrating Policies with the Command migrateSecurityStore
http://download.oracle.com/docs/cd/E14571_01/core.1111/e10043/cfgauthr.htm#JISEC2929


Thanks and Regards,

Deva

ODBC SQL Server Driver]Optional feature not implemented in RPD - Phesical layer feature

I came across an interesting error recently. I had a very simple data model with 1 fact table and 1 dimension, both coming from a SQL Server 2008 database. When querying the model through Answers I would get ODBC driver errors like the ones below.

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000]
[nQSError: 10058] A general error has occurred.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 43119] Query Failed:
[nQSError: 16001] ODBC error state: 37000 code: 8180 message: [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared..
[nQSError: 16001] ODBC error state: 37000 code: 145 message: [Microsoft][ODBC SQL Server Driver][SQL Server]ORDER BY items must appear in the select list if SELECT DISTINCT is specified..
[nQSError: 16002] Cannot obtain number of columns for the query result. (HY000)

Below thing in addred in Physical layer feature then also it's not working:

Untick the checkbox for EXPRESSIONS_IN_ORDERBY_SUPPORTED in the features tab of the database properties in the physical layer.


However I did notice that from your error that you are using [Microsoft][ODBC SQL Server Driver] and not "[Microsoft][SQL Server Native Client 10.0]" as given by the Doc 1308545.1

Thanks and Regards,
Deva

nQSError: 60008


Hi,
    I came across an interesting error recently, as a admin (weblogic user)  able to see the o/p without any error dashboard page, if any one user/group loging that time they are getting attached screen short error message.

FYI,

SR 3-3888346391: Odbc driver returned an error (SQLExecDirectW) on obiee11g Dashboard page


Solution Statement:

In your OBIEE11g  --> RPD file---> Manage--> Identity -->Users/Application role --> increase the each user/group wise that maximum number of rows the user or group is allowed to retrieve from a database. then it will work.

Reference:

At the rpd level, you can Manage Query Execution Privileges to limit queries by number of rows received by a user or group with
the max rows parameter. It determines the number of rows that can be returned from the database. If the number of rows exceeds this limit, an ODBC error occurs.
From the Administration Tool menu bar, choose Manage > Security.
•In the Security Manager dialog box, in the tree pane, select Users or Groups.
•In the right pane, right-click the name that you want to change and select Properties.
•In the User or Group dialog box, click the Permissions tab.
•In the User/Group Permissions dialog box, click the Query Limits tab and expand the dialog box to view all columns.
•To specify or change the maximum number of rows each query can retrieve from a database, in the Query Limits tab, perform the following steps:
•In the Max Rows column, type the maximum number of rows.
•In the Status Max Rows field, select a status.
•Click OK twice to return to the Security Manager dialog box.
If a query exceeds the limit set by the Administrator, the end user will get the message:
[nQSError: 60008] The query for user 'user1'
exceeded the maximum query governing rows n from the database x
Status  Description 
Disable  When selected, disables any limits set in the Max Rows or Max Time fields 
Enable  This limits the number of rows or time to the value specified. If the number of rows exceeds the Max Rows value, the query is terminated. 
Ignore  Limits will be inherited from the parent group. If there is no row limit to inherit, no limit is enforced 

Thanks and Regards,

Deva

Wednesday, June 22, 2011

By Pass Server Cache in OBIEE Answres

Hi,
   It's used to Overcome below kind of issue:
 .> Data Not Getting Refreshed in Answers when Changed in Base Database. Cache problem.


Let say User wants dashboard data updated on real-time after back-end ETL populates, then rather suggesting user to click on Refresh button each time is not the best option as fickle minded user1 could see stale data and can raise a hue and cry unnecessarily on old data .That could be easily avoided using Bypass Web Server Cache feature in Advanced tab of the corresponding reports .

Monday, June 20, 2011

OBIEE11g Start and Stop services automattically

Hi,

It seems you would like to Start/Stop BI services without entering the login/password details.
Two ways to achieve this.
1. Modifying “StartStopServices.cmd” located in below path:

Monday, June 13, 2011

Reset Prompt and Hiding the Go Button in OBIEE

Hiding the Go Button in OBIEE

   If you need to hide the go button for dashboard prompt in OBIEE insert a static text object on
to the dashboard, select the "Contain HTML markup" option enter the below lines,

<style type="text/css">
.XUIPromptEntry{display:none}
<style>

==========

Prompt Reset Button :

The given below will use to create reset button,
<div><a href ="#" onclick ="return  PersonalizationEditor.removeDefaultSelection(false)" Reset Prompt>
</div>



Regards,

Deva

Saturday, June 11, 2011

Basics of Data Model

Relational Vs Dimensional Model :



1) Dimensional Modeling approach provides a way to improve query performance for summary reports thereby enabling faster business decision making process.
2) Dimensional Modeling is easier to understand and navigate as it represents business subject areas in an intuitive style.
3) Dimensional Data Modeling is used for storing and reporting summarized data. For example, sales data could be collected on a daily basis and then be aggregated to the week level, the week data could be aggregated to the month level, and so on.

Friday, June 10, 2011

IDENTITY row's in SQL Coumns

Hi,
   Auto Increment row's in a column
while creating SQL use  sql for that column.

[Col1] [int] IDENTITY(1,1) Not Null

Regards,
Deva





Customizing Oracle Business Intelligence Enterprise Edition 11g

Deploying Custom Skin
=====================
After exposing
 Copy the default skin (
analyticsRes to WLS successfully, this directory can be used for custom skins. Follow the steps below for deploying a custom skin: ORACLE_HOME/bifoundation/web/app/res/sk_blafp) to analyticsRes In Linux, for example: cp ORACLE_HOME/bifoundation/web/app/res/sk_blafp/analyticsRes/sk_Eden Change the skin name in instaceconfig.xml NOTE: For user specific skin, use NQ_SESSION.SKIN session variable
 Modify the images and css files in
NOTE: If the size of the skin is a problem, delete the unmodified files. While deleting, make sure to not delete any file which is referenced in a modified css file as it picks up the files relative to the local directory. Default files (blafp skin) will be picked for the deleted files.
 Restart the Oracle BI Presentation Services and clear the browser cache to see the changes. Here are a few examples.
 Change the logo: Replace the
 Change the banner color: Modify
sk_Eden directory for achieving the customization. analyticsRes/sk_Eden/b_mozilla_4/oracle_logo.png and analyticsRes/sk_Eden/login/oracle_logo.png with the new png file. Try to keep the size of the new png file close to the original file (119X25 px). HeaderContainer class in analyticsRes/sk_Eden/b_mozilla_4/common.css Change the Tabs color (for dashboard page) in a dashboard: Modify the tab images (*.gif) in analyticsRes/sk_Eden/b_mozilla_4/uicomponents/obips.TabBar Customizing Oracle Business Intelligence Enterprise Edition 11g Page 9 NOTE: If the
 Change the body color of the home page: Modify the background color of the body in
uicomponents directory does not exist in analyticsRes/sk_Eden/b_mozilla_4 then create the uicomponents directory and copy the obips.TabBar from ORACLE_HOME/bifoundation/web/app/res/b_mozilla/uicomponent/obips.TabBar. Delete *.js and *.xml files. analyticsRes/sk_Eden/b_mozilla_4/home.css Change the alert color: Modify the HeaderAlerts class in analyticsRes/sk_Eden/b_mozilla_4/common.css Change the header bar separator line: Modify the HeaderBarSeparator class in analyticsRes/sk_Eden/b_mozilla_4/common.css Change the background color of the dashboard name: Replace the analyticsRes/sk_Eden/b_mozilla_4/l1_seltab_bg.gif with the new image. Make sure the size of the new image is the same as the old one. analyticsRes/sk_Eden/common/header_spacer_bg.gif with the new image. Make sure the size of the new image is the same as the old one. analyticsRes/sk_Eden/b_mozilla_4/l2_spacer_bg.gif with the new image. Make sure the size of the new image is the same as the old one. DashUpperContainer class in portalcontent.css file of the chosen style. This is a bug and is being fixed. For now, change this class to reflect the Eden skin (sk_eden). analyticsRes/sk_Eden/common/page_lev_connected.gif with the new image. Make sure the size of the new image is the same as the old one. menubar_gSeparator.gif in analyticsRes/sk_Eden/b_mozilla_4/uicomponents/obips.UberBar NOTE: If the
 Change the color, font and left margin of the brand name text (next to the logo): Modify the
uicomponents directory does not exist in analyticsRes/sk_Eden/b_mozilla_4, create the uicomponents directory and copy the obips.UberBar from ORACLE_HOME/bifoundation/web/app/res/b_mozilla/uicomponent/obips.UberBar. HeaderBrandName class in analyticsRes/sk_Eden/b_mozilla_4/common.css and appname class in analyticsRes/sk_Eden/login/login.css .HeaderBrandName{..; color:#007700;font-family:Arial; left:120px; ..} Customizing Oracle Business Intelligence Enterprise Edition 11g Page 10 .appname{..; color:#007700; font-family:Arial; ..} Deploying Custom Style The same analyticsRes directory can be used for a custom style using the steps below.
 Copy the default style (
ORACLE_HOME/bifoundation/web/app/res/s_blafp) to analyticsRes In Linux, for example: cp ORACLE_HOME/bifoundation/web/app/res/s_blafp analyticsRes/s_Eden
NOTE: For user specific style, use NQ_SESSION.STYLE session variable
 Modify the images and css files in
NOTE: If the size of the style is a problem, delete the unmodified files. While deleting, make sure to not delete any file which is referenced in a modified css file as it picks up the files relative to the local directory. Default files (blafp style) will be picked for the deleted files.
 Restart the Oracle BI Presentation Services and clear the browser cache to see the changes. As an example:
 Change the background color of the pivot table header: Replace the
Choose the Eden Style in Dashboard Properties analyticsRes/s_Eden directory to achieve your customization. analyticsRes/s_Eden/viewui/pivot/ptgrd_overly.png with the new image. Make sure the size of the new image is the same as the old one. Deploying Custom Message Custom messages should be stored in the same analyticsRes directory.
 Create
In Linux, for example:
customMessages folder in analyticsRes directory for the custom messages (.xml file). A good example would be writeback template that should be saved here. mkdir customMessages analyticsRes/ Customizing Oracle Business Intelligence Enterprise Edition 11g Page 11
 Change the brand name text –
For creating the language dependent custom message, create the appropriate directory structure within analyticsRes directory. As an example: o
In Linux, for example:
Create the message directory for the required language (English language here). mkdir analyticsRes/customMessages/l_en/messages o Create CompanyName.xml and add the text within kmsgHeaderBIBrandName tag: <WebMessageTables xmlns:sawm="com.siebel.analytics.web/message/v1"><WebMessageTable protect="true" export="true" translate="false" system="ProductMessages" table="ProductNames">
<WebMessage name="kmsgHeaderBIBrandName"><TEXT> Report Center </TEXT></WebMessage>
</WebMessageTable></WebMessageTables>

Regards,
Deva
.HeaderBarSeparator{..; border-top: 1px solid #005500; ..}
 Change the header spacer line: Replace the
 Change the background color of the dashboard page edit and help icon: Replace the
NOTE: The path of this image is hard coded in
 Change the status icon next to Sign Out (top right corner): Replace the
 Change the menu bar separator line: Replace the .HeaderAlerts a:hover{..; color:#FF7777; ..} body{..; background-color: #006600; ..} .HeaderContainter {..; background-color: #006600; ..} <UI><DefaultSkin>Eden</DefaultSkin></UI>

How to Replace Null Values in an OBIEE Pivot Table?

How to Replace Null Values in an OBIEE Pivot Table

It's simple tip that allows you to supress null values in a pivot for cells which have no data.
Create a simple report. I’m using the Samplesales RPD here.
 
A pivot table view of this data would look something like this by default:
 
Now switch back to the criteria tab and edit the ‘column properties’ associated with your fact measure. Choose the ‘Data Format’ tab, tick to override the default format and choose ‘Custom’.
It seems that the syntax for this custom format is positive-value-mask (semi colon) negative-value-mask (semi colon) null-mask. So this means we have a few options.
E.g. if you want zeros (0) instead of null then enter:
#,##0;-#,##0;0
 
If you want a dash/strike (-) then you could enter:
#,##0;-#,##0;-
Or if you want to add a custom message then something like this would work:
#,##0;-#,##0;no data
Our pivot table now shows something other than null values.


Its a bug in OBIEE11g

I have raised SR and confirmed it defect obiee11.1.1.3.version but after obiee11.1.5 released also that major bug is not yet resolved that why i am just wondering
fyi:
Fix by 11.1.1.6.1 as mentioned in the Bug.
Bug 13054445 [http://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=13054445] - REPLACING NULL VALUES WITH "0" IN AN OBIEE 11G PIVOT TABLE IS NOT WORKING
for more refer :
https://forums.oracle.com/forums/thread.jspa?threadID=2319791


Regards,
Deva

Removing BrandName text (next to oracle logo) on obiee11g home page

Removing BrandName text (next to oracle logo)  on obiee11g home page
D:\OBIEE_HOME\Oracle_BI1\bifoundation\web\msgdb\l_en\messages\productmessages.xml
Rds,
Deva

OBIEE - LDAP Configuration and implementation Reference

Hi,

    Check the Below link for OBIEE - LDAP Configuration and implementation in Prod Server.
   
http://download.oracle.com/docs/cd/E14571_01/bi.1111/e10543/privileges.htm#BABCDCFE
You need to get the following information from the network team.
 
1. LDAP Server name
2. Base DN
3. Bind DN
4. Bind Password
5. Whether it is ADSI or not.
6. User Attribute
Regards,
Deva

Exporting in Excel to download more than 65000 rows in obiee11g/10

Hi,
   update the below code in you instance config.xml file, after that restart all bi services.
<Pivot>
<MaxCells>1920000</MaxCells>
<MaxVisibleColumns>30</MaxVisibleColumns>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>64000</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<DefaultRowsDisplayed>64000</DefaultRowsDisplayed>
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>64000</DefaultRowsDisplayedInDownload>
<DisableAutoPreview>false</DisableAutoPreview>
</Pivot>
<Table>
<MaxCells>1920000</MaxCells>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>64000</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<DefaultRowsDisplayed>64000</DefaultRowsDisplayed>
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>64000</DefaultRowsDisplayedInDownload>
</Table>
Thanks and Regards,
Deva

obiee-date-expressions-reference

obiee-date-expressions-reference
===========================
1)  First Day of the Previous Year
-------------------------------------------
TIMESTAMPADD( SQL_TSI_YEAR , -1, TIMESTAMPADD( SQL_TSI_DAY , EXTRACT( DAY_OF_YEAR FROM CURRENT_DATE) * -(1) + 1, CURRENT_DATE))
From right to left the first TIMESTAMPADD returns the first day of the current year. The second TIMESTAMPADD removes a year from the returned date for the First Day of the Previous Year.
2) First Day of the Current Year

Thursday, June 9, 2011

Cutomizing "No Data View" in 11g

Alerting Users to No Data in the Results of Analyses:
=======================================================
When the results of an analysis return no data, the following default message is displayed to users:
No Results
The specified criteria didn't result in any data.
This is often caused by applying filters and/or selections that are too
restrictive or that contain incorrect values.
Please check your Analysis Filters and try again.
The filters currently being applied are shown below.

Rather than display the default message, you can create a customized message to alert users. This allows you to provide your own explanation as to why the analysis returned no data.

To create a custom message to alert users to no data in the results of an analysis:

1. Edit the analysis to which you want to add a custom message.
2. Click the "Analysis editor: Results tab".
3. Click the Analysis Properties toolbar button. The "Analysis Properties dialog" is displayed.
4. In the No Results Settings box, select Display Custom Message.
5. In the Header field, enter the text of the header for the custom message.
6. In the Message field, enter the explanatory text.
7. Click OK.

Reference:
Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition 11g Release 1 (11.1.1) user guide down loadable from http://download.oracle.com/docs/cd/E14571_01/bi.1111/e10544.pdf.
chapter 2 Creating Analyses. Page # 2-12.

Regards,
Deva

Wednesday, June 8, 2011

This note provides a quick reference to guide the users how to create a default footer/header for all new Analytics reports?


Hi,

This note provides a quick reference to guide the users how to create a default footer/header for all  new Analytics reports.
Solution
To implement the solution, follow the steps below:
1.Make a backup of Answerstemplates.xml.
2.Refer to Add Default Header or Footer to New Reports (Page 61) to accomplish the setting.

3. Retest the change.


References

NOTE:535619.1 - Footer Text and Column Headings Printing on Every Page
NOTE:577373.1 - Add image on the header of Configurator view
NOTE:759856.1 - Add custom text in the "Footer" section of all pages in eChannel application(SI)
B31766-01

Regards,

Deva

how to remove brand name text (next to the logo) on obiee 11g home dashboards?

You can Customise OBI welcome page by overriding XML messages. Please follow the below steps to change the Brand Name:-

a. Create a directory named customMessages under <ORACLE_INSTANCE>\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\msgdb\l_en\
Note:- Please create l_en directory if this does not exist.
b. Create an xml file under customMessages directory.
c. Add the below contents inthis xml file and add any customised text you require between TEXT tag:-
--------------------------------------------------------------- <?xml version="1.0" encoding="utf-8"?>
<WebMessageTables xmlns:sawr="com.siebel.analytics.web/response/v1" xmlns:sawm="com.siebel.analytics.web/message/v1" sawm:systemMessages="false">
<WebMessageTable system="Custom Messages">
<WebMessage name="kmsgHeaderBIBrandName">
<TEXT>Customised Text</TEXT>
</WebMessage>
</WebMessageTable>
</WebMessageTables>
---------------------------------------------------------------

Restart Presentation services for the changes to take effect.

Method 2:

Removing BrandName text (next to oracle logo)  on obiee11g home page

D:\OBIEE_HOME\Oracle_BI1\bifoundation\web\msgdb\l_en\messages\productmessages.xml

For more:

for more refer
Customizing Oracle Business Intelligence Enterprise Edition 11g An Oracle White Paper
http://www.oracle.com/technetwork/middleware/bi/customizing-oracle-biee-11g-176387.pdf


Regards,

Deva

Change BGBanner name in OBIEE11g Portal header

If you want to change the OBIEE11g Common portal header name open <MW_HOME>\Oracle_BI1\bifoundation\web\msgdb\l_en\messages\
productmessages.xml (You can make changes in this file to change browser title for application)
search for webmessage name=kmsgHeaderBIBrandName and change the text in <TEXT> </TEXT> tag
E.g:
<WebMessage name=”kmsgHeaderBIBrandName”>
<TEXT>Business Intelligence</TEXT> ——-> change this text to your application name e.g: BI Application
</WebMessage>
Regards,

Deva

Enabling Sorting order for more than 1000 rows - OBIEE

I have a report which a normal table view where customer wants to show 1000 rows per page with a sorting order enabled.Normally,
if we have (>=)1000 rows per page the sorting order option will not work because by default MaxHydercubeRecords =1000 we need to reset in InstanceConfig.xml (OracleBIData/Web/Config/InstanceConfig.xml)
Add following tag
>Hypercube< >MaxTableViewRecords>12000<MaxTableViewRecords< >Hypercube <
Regards,

Deva

how to Changing theOBIEE11g homepage for all users/group wise?

Hi,

Changing the homepage for all users

https://forums.oracle.com/forums/thread.jspa?threadID=2315792&tstart=0


1. Created a session init block
2. Used data source as select '/shared/SH Test/_portal/Test1' from dual
3. Assigned this value to PORTALPATH session variable
4. In Presentation services > Administration > My account > Default dashboard should be set to 'default'. Then only the dashboard specified in init block will be displayed otherwise My account will override the init block.

LDAP Configuration in obiee11g

for more clear steps in this context.
http://download.oracle.com/docs/cd/E14571_01/bi.1111/e10543/sso.htm#CEGJJFED

http://download.oracle.com/docs/cd/E21764_01/bi.1111/e10543/toc.htm.

SSO can be implemented in OBIEE 11g by steps like

1. Configure the SSO authentication provider.
2. Configure HTTP proxy.
etc

How to create session variables for UserID in obiee?

http://forums.oracle.com/forums/thread.jspa?messageID=3447246&#3447246
http://forums.oracle.com/forums/thread.jspa?messageID=3376727&#3376727
http://gerardnico.com/wiki/dat/obiee/saw_url_session_variable

fetching dashboards login userid
session variable:
--------
DISPLAYNAME
init block:
---------
datasource type is OBIEE server
SELECT username,groupname from usera where username=':USER'

Unable to Sign In into presentation services and RPD obiee 11

Issue :I had a  trouble to login into RPD (online mode) the Presentation services lately.
It was working fine before and after changed console user sequrity things changed and was having issues to login lately after that.
It always gives me invalid username/Password was entered message when I tried to login no matter what ever username I tried.
I was able to login into Enterprise manger and Weblogic Admin console successfully with out any issues. All the processes are up and running with out any issues.
Tried rebooting successfully and still it wont let me login into Answers. So I tried if i could login into Admin tool and it wont let me login there as well.
So I created new Admin user in the Weblogin console and tried to login using the new user and still no luck. The new admin will let me login into the EM and WLC but not into Answers and rpd.
I tried deleting old references of the user directories in the catalog and still no luck.
It has something to do with the credential store. What ever user name I created its not mapping it to the Answers/rpd inspite of both the services are running
 Solution:
======

1. Please follow instructions given in
How to fix “Unable to Sign in. An error occured during Authentication" error when a user logs in OBIEE 11g (Doc ID 1302924.1) step by step, for those steps you have done, please double check and make sure what you've done are correct.

2. You are still not able to logon because you have missed a few steps as the following:
8. Edit the NQSConfig.INI file to reset the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES to NO and restart the Oracle BI Servers.
9. Remove, set to none, or comment out the line (see UpgradeAndExit in the following example) added to the instanceconfig.xml file (that instructs Oracle BI Presentation Server to refresh GUIDs on restart).
10. <ps:Catalog xmlns:ps="oracle.bi.presentation.services/config/v1.1">
11. <ps:UpgradeAndExit>false</ps:UpgradeAndExit>
12. <ps:UpdateAccountGUIDs>none</ps:UpdateAccountGUIDs>
13. Restart the Presentation Server for the instanceconfig.xml file that was updated.
14. Make sure Oracle WebLogic Server and the system components are also running, if they are not running, restart them.

b) Relogin as the problematic user to verify if you still see the “Unable to Sign In” error

Step 2 : Delete user from rpd if present

a)Launch admin tool and open rpd in OFFLINE Mode
b)Click Manage > Identity > Users tab to verify if you see this user present
Note : Normally you will only see list of users when you open rpd in ONLINE mode. Unless the users were created manually in rpd, no users should be visible in OFFLINE mode
c)If the user is present, delete this user entry from rpd
d)save rpd and deploy this changed rpd using EM
e)restart OBI Server component
f)relogin as the problematic user to see if you still see “Unable to Sign In” error

Step 3 : Delete the cacheduserinfo file from webcatalog
If Step1 and Step2 does not work, then do the following
Note : In the example below, catalog name is SampleApp and the user who gets “invalid Login” error is Administrator user.


a)Take a backup of your webcatalog
b)Navigate to C:\OBIEE11G\instances\instance2\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\SampleApp\root\users\Administrator\_prefs
c)Delete the files name cacheduserinfo and cacheduserinfo.atr
d)Launch OBIEE 11.1.1.3 and test by logging in as the specific user.

the best one is 3rd one.

Replacing Null as 0 in obiee

 criteria tab and edit the ‘column properties’ associated with your fact measure. Choose the ‘Data Format’ tab, tick to override the default format and choose ‘Custom’.
It seems that the syntax for this custom format is positive-value-mask (semi colon) negative-value-mask (semi colon) null-mask. So this means we have a few options.
E.g. if you want zeros (0) instead of null then enter:
#,##0;-#,##0;0
2) in that formula columns we have put it below case condition also ,
CASE WHEN Nom_amt IS NULL THEN 0 ELSE Nom_amt END
3) we have uncheked IS NULL check box in the admin tool also
IFNULL(columname,0)


IN OBIEE 11g above mothods won't work because it's a bug in obiee11.1.1.5.0 version please refer the BUG reference :

Bug 13054445 - REPLACING NULL VALUES WITH "0" IN AN OBIEE 11G PIVOT TABLE IS NOT WORKING

Thanks

Deva

Write Back in OBIEE11g

Hi,

OBIEE11g Writeback Configuration
https://docs.google.com/file/d/0BwMedcpXjz5bUS1EQ09lb3lwcDQ/edit 

Thanks
Deva

Migrating application role from DEV to Prod server in obiee11g

Hi,
  
http://download.oracle.com/docs/cd/E14571_01/core.1111/e10043/cfgauthr.htm#JISEC2929

Migrating Policies with the Command migrateSecurityStore
Application-specific policies or system policies can be migrated manually from a source repository to a target repository using the WLST command migrateSecurityStore.
This command is offline, that is, it does not require a connection to a running server to operate; therefore, the configuration file passed to the argument configFile need not be an actual domain configuration file, but it can be assembled just to specify the source and destination repositories of the migration.
Note:
Since the command migrateSecurityStore recreates GUIDs and takes a long time to migrate large volume of data, you may want to consider migrating stores with an alternate procedure that uses Oracle Internet Directory bulk operations. For details, see Section 6.5.2.3, "Migrating Large Volume Policy and Credential Stores.".
For further details about WLST commands and their syntax, see section Overview of WLST Command Categories, in Oracle Fusion Middleware WebLogic Scripting Tool Command Reference.
To migrate all policies (system and application-specific, for all applications) use the script (first) or interactive (second) syntaxes (arguments are written in separate lines for clarity):
migrateSecurityStore.py -type policyStore
                        -configFile jpsConfigFileLocation
                        -src srcJpsContext
                        -dst dstJpsContext
migrateSecurityStore(type="policyStore", configFile="jpsConfigFileLocation", src="srcJpsContext", dst="dstJpsContext")
                     
The meanings of the arguments (all required) are as follows:
  • configFile specifies the location of a configuration file jps-config.xml relative to the directory where the command is run. Typically, this configuration file is created just to be used with the command and serves no other purpose. This files contains two jps-contexts that specify the source and destination stores.
    In addition, if the migration involves one or two LDAP-based stores, then this file must contain a bootstrap jps-context that refers to the location of a cwallet.sso file where the credentials to access the LDAP based involved in the migration are kept. See second example below.
  • src specifies the name of a jps-context in the configuration file passed to the argument configFile.
  • dst specifies the name of another jps-context in the configuration file passed to the argument configFile.
The contexts passed to src and dst must be defined in the passed configuration file and must have distinct names. From these two contexts, the command determines the locations of the source and the target repositories involved in the migration.
To migrate just system policies, use the script (first) or interactive (second) syntaxes (arguments are written in separate lines for clarity):
migrateSecurityStore.py -type globalPolicies
                        -configFile jpsConfigFileLocation
                        -src srcJpsContext
                        -dst dstJpsContext
migrateSecurityStore(type="globalPolicies", configFile="jpsConfigFileLocation", src="srcJpsContext", dst="dstJpsContext")
The meanings of the arguments (all required) are identical to the previous case.
To migrate just application-specific policies, for one application, use the script (first) or interactive (second) syntaxes (arguments are written in separate lines for clarity):
migrateSecurityStore.py -type appPolicies
                        -configFile jpsConfigFileLocation
                        -src srcJpsContext
                        -dst dstJpsContext
                        -srcApp srcAppName
                       [-dstApp dstAppName]
                       [-overWrite trueOrfalse]
                       [migrateIdStoreMapping trueOrfalse]
                                       [mode laxOrstrict]
migrateSecurityStore(type="appPolicies", configFile="jpsConfigFileLocation", src="srcJpsContext", dst="dstJpsContext", srcApp="srcAppName", [dstApp="dstAppName"], [overWrite="trueOrfalse"], [migrateIdStoreMapping="trueOrfalse"], [mode="strict"])
The meanings of the arguments configFile, src, and dst are identical to the previous cases. The meaning of other five arguments is as follows:
  • srcApp specifies the name of the source application, that is, the application whose policies are being migrated.
  • dstApp specifies the name of the target application, that is, the application whose policies are being written. If unspecified, it defaults to the name of the source application.
  • migrateIdStoreMapping specifies whether enterprise policies should be migrated. The default value is True. To filter out enterprise policies from the migration, that is, to migrate just application policies, set it to False.
  • overWrite specifies whether a target policy matching a source policy should be overwritten by or merged with the source policy. Set to true to overwrite the target policy; set to false to merge matching policies. Optional. If unspecified, defaults to false.
  • mode specifies whether the migration should stop and signal an error upon encountering a duplicate principal or a duplicate permission in an application policy. Either do not specify or set to lax to allow the migration to continue upon encountering duplicate items, to migrate just one of the duplicated items, and to log a warning to this effect.
If the input does not follow the syntax requirements above, the command execution fails and returns an error. In particular, the input must satisfy the following requisites: (a) the file jps-config.xml is found in the passed location; (b) the file jps-config.xml includes the passed jps-contexts; and (c) the source and the destination context names are distinct.

Auto Update Dashboard Content in obiee

Hi,
Kindly add the below code to the Dashboard text object and enable the html option,

<META HTTP-EQUIV="REFRESH" CONTENT="500">
<META HTTP-EQUIV="CACHE-CONTROL" CONTENT="NO-CACHE" >

then it ill work based upon time..setted

Regards,

Deva