OBIEE Online Training

Saturday, October 29, 2011

Refreshing GUID in obiee11g

Hi,

To regenerate user GUIDs:

This task requires that you manually edit the configuration files to instruct Oracle BI Server and Oracle BI Presentation Server to regenerate the GUIDs on restart. Once completed, you edit these files to remove the modification. For information about where to locate Oracle Business Intelligence configuration files, see "Where Configuration Files are Located" in Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
1.Update the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter in NQSConfig.INI:
a.Open NQSConfig.INI for editing at:
ORACLE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisn
b.Locate the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter and set it to YES, as follows:
FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = YES;
c.Save and close the file.
2.Update the Catalog element in instanceconfig.xml:
a.Open instanceconfig.xml for editing at:
ORACLE_INSTANCE/config/OracleBIPresentationServicesComponent/
coreapplication_obipsn
b.Locate the Catalog element and update it as follows:
<Catalog>
<UpgradeAndExit>false</UpgradeAndExit>
<UpdateAccountGUIDs>UpdateAndExit</UpdateAccountGUIDs>
</Catalog>
c.Save and close the file.
3.Restart the Oracle Business Intelligence system components using opmnctl:
cd ORACLE_HOME/admin/instancen/bin
./opmnctl stopall
./opmnctl startall
4.Set the FMW_UPDATE_ROLE_AND_USER_REF_GUIDS parameter in NQSConfig.INI back to NO.
Important: You must perform this step to ensure that your system is secure.
5.Update the Catalog element in instanceconfig.xml to remove the UpdateAccount GUIDs entry.
6.Restart the Oracle Business Intelligence system components again using opmnctl:
cd ORACLE_HOME/admin/instancen/bin
./opmnctl stopall
./opmnctl startall
   

For More:
 Refreshing in obiee11g
good one
http://obiee11gqna.blogspot.com/2011/10/obiee11g-updating-guids.html

http://varanasisaichand.blogspot.com/2011/08/refresh-user-guids-obiee-11g.html
http://gerardnico.com/wiki/dat/obiee/migration


Reading the Oracle Documentation I see that the refresh of GUIDs need to be done for Presentation services as well. http://download.oracle.com/docs/cd/E14571_01/bi.1111/e10543/privileges.htm#CHDHGAAH

Thanks

Deva

Monday, October 24, 2011

ODBC driver returned an error(SQLExecDirectW).NQSError:46118 out of disk space



Hi,
   
   Error:
   ODBC driver returned an error(SQLExecDirectW).NQSError:46118 out of disk space






Solution : Need to keep minimum 10MB for obiee-disk memory space...after cleaning the drive that issue was resolved.

Thanks
Deva

Friday, October 21, 2011

OBIEE11g Features


Hi,

OBIEE11g Features

1) Multiple Subject Areas

Did you know that Answers reports (Analyses) can now be sourced from multiple Subject Areas?    This is significant as it means you no longer have to cram lots of content into a single Subject Area!

2) Conditional Data Formatting
When you apply Conditional Formatting via "Column Properties" in Answers, there is an additional tab to allow you to conditonally change the "Data Format" as well as the "Style".

OBIEE Licence supporting components

Hi,
If you are using for practice its available in oracle site for download,else if its for commercial purpose you need to
buy
OBIEE Licence supporting components:
1) Oracle BI Server
2) Oracle BI Answers
3) Oracle BI Interactive Dashboards
4) Oracle BI Delivers
5) Oracle BI Disconnected Analytics:
6) Oracle BI Publisher (formely known as XML Publisher)
7) Oracle BI Briefing Books
8) Hyperion Interactive Reporting
9) Hyperion SQR Production Reporting
10) Hyperion Financial Reporting
11)Hyperion Web Analysis
http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/overview/index.html
for purchase
https://shop.oracle.com/pls/ostore/product?p1=businessintelligencetechnology
FYI...
http://www.oracle.com/technetwork/licenses/standard-license-152015.html

This is the latest Oracle Technology Global Price List; http://www.oracle.com/us/corporate/pricing/technology-price-list-070617.pdf

OBIEE11g Certification Matrix:
http://www.oracle.com/technetwork/middleware/bi/oracle-obia-111151-cert-matrix-525376.xls

http://oraclebi.blogspot.com/2010/09/obiee-11g-certification-matrix-updated.html

Thanks
Deva

Thursday, October 13, 2011

Windows 7 Home Premium edition is supported for installation of OBIEE Server 11.1.1.5

HI,


It is supporting and working fine for more please refer 

http://obieeelegant.blogspot.sg/2012/07/obiee111160-software-only-installation.html





Windows 7 Home Premium edition is not supported for installation of OBIEE Server 11.1.1.5.


Issue: 1
while installing obiee11.1.1.5.0 (software only install ) on win7 64 bit SP1 version i am getting Executing:opmnctl start coreapplication_obisch1 error at the last step


Issue 2:
OBIEE 11g Install On Windows 7 Hangs At Creating Domain Step (Doc ID 1209259.1)
Refer:http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/bi-11gr1certmatrix-166168.xls


Solution:
Please kindly refer to the Certification matrix available from :
http://www.oracle.com/technetwork/middleware/bi/oracle-obia-111151-cert-matrix-525376.xls


http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/bi-11gr1certmatrix-166168.xls


Windows 7 Home Premium edition is not supported for installation of OBIEE Server 11.1.1.5.


Install OBIEE 11.1.1.5 only on certified platform
ie. Windows 2003 with SP2/R2+
or Windows Server 2008 with SP1+
Window 7 is only certified as an OBIEE client.


For more Refe:SR 3-4684846891: Executing:opmnctl start coreapplication_obisch1 while installing obiee11g (11.1.1.5.0) win64bit

Thanks

Deva