oracle 11g data base instalation on wnidows 8

Give mail id and enter

Click on I want to     

And next

Create and config

Desk top class and next

Pass word yours choice

Click on finish

next

next

Allow access

next

Click on ok

Close

Variables available in OBIEE 11.1.1.6

Variables available in OBIEE 11.1.1.6

Scope	Presentation Variable	Example
system	productVersion	system.productVersion = 11.1.1.3 (Build 090619.0110.000)
system	currentTime	system.currentTime = 6/29/2009 7:35:59 PM
session	locale	session.locale = en-us
session	language	session.language = en
session	rtl	session.rtl = false
	This indicates whether the language selection in the Login page is a right to left language. For example, if the language selection is Hebrew, then this variable returns true.
session	timeZone	session.timeZone = (GMT-06:00) Central America
session	timeZone.id	session.timeZone.id = (GMT-06:00) Central America
	This returns a value that is not localized.
session	timeZone.name	session.timeZone.name = (GMT-06:00) Central America
	This returns a localized value.
session	timeZone.value	session.timeZone.value = (GMT-06:00) Central America
	This returns a localized value.
session	loginTime	session.loginTime = 6/29/2009 7:12:01 PM
session	logoutTime	session.logoutTime = 6/29/2009 8:02:01 PM
session	lastAccessTime	session.lastAccessTime = 6/29/2009 7:35:59 PM
session	currentUser	session.currentUser = Administrator
session	currency.name	session.currency.name = $ English - United States
session	currency.symbol	session.currency.symbol = $
session	currency.userPreference	session.currency.userPreference = Global Currency 2
user	id	user.id = Administrator
user	displayName	user.displayName = Administrator
user	homeDirectory	user.homeDirectory = /users/administrator
dashboard	currentPage	dashboard.currentPage = page 1
dashboard	xml	dashboard.xml = the dashboard XML
dashboard	dashboard.currency.name	dashboard.currency.name = Euro
dashboard	dashboard.currency.symbol	dashboard.currency.symbol = $
dashboard	dashboard.currency.userPreference	dashboard.currency.userPreference = Global Currency 1
dashboard	dashboard.path	dashboard.path = /users/administrator/_portal/Sales
	This returns the path in the catalog.
dashboard	dashboard.name	dashboard.name = MyDashboard
dashboard	dashboard.caption	dashboard.caption = Sales
	This returns the localized name of the dashboard.
dashboard	dashboard.location	dashboard.location = Dashboard&PortalPath=/users/administrator/_portal
	This returns the URL for the location.
dashboard	dashboard.description	dashboard.description = Sales by region and district
dashboard	dashboard.author	dashboard.author = Administrator
dashboard.currentPage	dashboard.currentPage.name	dashboard.currentPage.name = Sales page 1
dashboard.currentPage	dashboard.currentPage.path	dashboard.currentPage.path = /users/administrator/_portal/Sales/page 1
dashboard. current Page	dashboard.currentPage.currency.name	dashboard.currentpage.currency.
		name = USD
dashboard.current Page	dashboard.currentPage.currency.symbol	dashboard.currentPage.currency.
		symbol = USD
dashboard. current Page	dashboard.currentPage.currency.userPreference	dashboard.currentPage.currency.userPreference = Global Currency 2
analysis	report.currency.name	report.currency.name = $ English - United States
analysis	report.currency.symbol	report.currency.symbol = $
analysis	report.currency.userPreference	report.currency.userPreference =
		Global Currency 2

Obiee 11g Bi Scheduler Gives Error Nqserror: 75005

Obiee 11g Bi Scheduler Gives Error Nqserror: 75005

when running Agent (iBot), the following error message is seen:

Failed to send AUTH command. 5.7.3 Authentication unsuccessful

The above error message is seen if the BI scheduler cannot ping the mail server specified in the scheduler configuration. In this case, customer is able to ping and telnet the mail server.

The other scenario where the error message is seen is if Username and password are specified in the scheduler configuration.

To view this setting, log in to enterprise manager > Business Intelligence > Coreapplication > Deployment > Mail and you will notice Username, password. If the values are specified for Username and password then Failed to Send Auth Command error is seen.

In this case, Username and password for the scheduler configuration have values.

Once the values are entered, these values cannot be deleted from the EM. In order to delete the values for Username and Password specified in mail configuration, log in to enterprise manager > Weblogic Domain > Right click on bifoundation_domain > Security > Credentials > Expand oracle.bi.enterprise > Highlight mail.server and delete.

After deleting the credential, customer was able to run the agents successfully

OBIEE 11G EVALUATE_SUPPORT_LEVEL

OBIEE 11G EVALUATE_SUPPORT_LEVEL

When using Evaluate Function in OBIEE 11g

Error : Formula syntax is invalid
[nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE. (HY000)

SQL Issued: SELECT EVALUATE('LEAST(%1,%2)', 1, 2) FROM "Disclosures - Encumbered Assets"

Resolution

Change the setting in the nqsconfig.INI

location of File : $MW_HOME/instances/instance1/config/OracleBIServerComponent/coreapplication_obis1


Edit nqsconfig.INI and Change the setting to 2

# EVALUATE_SUPPORT_LEVEL:
# 1: evaluate is supported for users with manageRepositories permssion
# 2: evaluate is supported for any user.
# other: evaluate is not supported if the value is anything else.

EVALUATE_SUPPORT_LEVEL = 2; 

Save changes and Restart the OPMN Services

--Start Services

$MW_HOME/instances/instance1/bin/opmnctl stopall
--Stop Services

nohup $MW_HOME/instances/instance1/bin/opmnctl startall

OBIEE 11.1.1.6.2 Writeback setup

OBIEE 11.1.1.6.2 Writeback setup

Detailed Write Back steps in OBIEE 11.1.1.6.2

Krishna M

Step 1

Amend the instanceconfig.xml and add the LIghtWriteback entry as shown below with in the server instance tags

The instanceconfig.xml file is located in $MW_HOME/instances/instance1/config/OracleBIPresentationServicesComponent
/coreapplication_obips1 directory

Add the LightWriteback tag just above the /ServerInstance tag as in above example.

<LightWriteback>true</LightWriteback>

Restart the OPMN services for the instanceconfig amendment above to take effect

Login to Analytics

http://<hostname>:9704/analytics

Set privileges within Administration screen

Add roles or users to the Write back privileges above

Step 2

Create a table used to store the write back table and import it into the physical layer in RPD

Ensure the connection pool user has required privileges to insert / update data on this table

Step 3

 

 

 

 

 

 

 

 

 

 

In Business Model, switch on the Writable property for all required columns

This completes the one time setup required to carry out write back functionality. Following steps are required for setting up an actual write back

Step 4

Create a new analysis with the required columns

Select the Column Properties using the drop down arrow on each column

Choose the column property and Tick the Enable Write Back check box on the Write Back tab for the required column. In my case, I have enabled only for USD Amount.

Note: If the ‘Writable’ flag is not enabled in RPD then this check box also cannot be enabled

Step 5

 

 

 

 

 

 

 

 

 

 

Note that only the USD_AMT column is displayed as editable

Choose the Edit Table View option and click on Table View Properties

 

 

 

 

 

 

 

 

 

 

Tick the Enable Write Back on enter a Template Name. I entered ‘RPA’ and this can be any user given name. Note this name is case sensitive. Below you will see how to create this template called RPA used here

Step 6

Click on the advanced tab of the analysis

Here under the Analysis XML box we want to note down all the columnID's that we will be using to populate the Writeback table with

Make a note of the columnIDs for the required columns. These will be used in the next step

Step 7

 

 

Create XML file as below and place it in

$MW_HOME/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1

/analyticsRes/customMessages directory if the analytics res directory has been deployed.

Please see the Deploying analyticsRes for custom Messages post that we have created that wont ever get overwritten by Oracle Patches etc

If you dont want to use the analyticsRes custom messages folder then you can use the seeded folder

If the directory ‘customMessages’ does not exist then create one in the path mentioned

 

--------Start of XML--------

<?xml version="1.0" encoding="utf-8" ?>

<WebMessageTables xmlns:sawm="com.siebel.analytics.web/message/v1">

   <WebMessageTable lang="en-us" system="WriteBack" table="Messages">

      <WebMessage name="RPA">

         <XML>

            <writeBack connectionPool="Writeback">

                 <insert></insert>

                <update>update encumbered_rpa set usd_amt = @{cbe48633dbeb2bda8},update_date = sysdate,updated_by = '@{cb26f41933b0c7d7c}' where product_id = @{c9c0a2069f38dda8c}</update>

            </writeBack>

         </XML>

      </WebMessage>

   </WebMessageTable>

</WebMessageTables>

-------End------

 

Within the update tags have the update statement that gets executed in the database using the columnIDs picked from the Advanced tab

Save the XML as RPA.xml

Bounce the OPMN service for this XML to be loaded and available for use

 

 

Step 8

 

 

Run the report that was created in Step 4

 

If all the steps are carried as they should be then you will see two buttons as in the above screen shot. The Update functionality is ready.

Amend the value of any editable field and hit the Update button then the change is carried out in the database and the screen gets refreshed with the new value. The statement that is given in the XML template between the update tags gets executed.

Revert button is used to undo any changes that are not yet sent to the database.

If you have noticed, the insert statement is left blank. But the same XML can be amended to provide the functionality of insert. If the amended record exists in DB, then the update statement is issued and if the amended record does not exist in DB then the insert statement is issued.

You don’t necessarily have a insert statement with the insert tags. You can use a function call here or you can issue an update statement to a different table. Using this base functionality you can deliver tailor made solutions fit for purpose.