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

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

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".

3) Case-Insensitive Searching
When using the "search" facility to choose your filter values within Answers, there is now a "Match Case" option that enables you to perform a case-insensitive search.

NOTE: There is also a "Match Case" option when performing member selection

4) Conditional Formatting

Conditional formatting is now possible on Pivot Tables (even on Hierarchical Columns).   

5) Dashboard Prompts

There is a new style of dashboard prompt called a "Variable Prompt" which allows you to specify your own custom list of values for the dashboard prompt (instead of always having to source the values from a Subject Area)

6) Importing RPD Metadata

Within the Physical layer of the RPD, when you right-mouse click on a Connection Pool there is a new "Import Metadata" option.    When adding further tables, this new option is much better than the "File > Import" menu option because all the new metadata will get imported directly into the existing Physical Database (so you won'tyou get another Physical Database created).

To make it even better, this new "Import Metadata" option will perform an incremental update of your existing tables and their columns.   So if you create new columns on your database, the tables in the RPD will be incrementally updated.   


7) Time Series Calculations

There are now 3 types of Time Series calculation available (AGO, TODATE and PERIODROLLING).    Another great enhancement is that it is now possible for report developers to build their own Time Series calculations in Answers, so you no longer have to rely on them being created in the RPD.   


8) Building Subject Areas

In the BI Administration tool, you can right-mouse click on a Business Model and choose the option "Build Subject Areas for Logical Stars and Snowflakes".    This option will automatically create a Subject Area dedicated to each logical fact in your Business Model.    Each Subject Area will one logical fact together with all its related logical dimensions.

9) Archiving/Unarchiving
You can now archive/unarchive BI Presentation Catalog content directly within the dashboard front-end, you no longer need to use the BI Catalog Manager utility.

10) Presentation Variables
It is now possible to assign multiple values to a Presentation Variable.

11) Rename Wizard
In the BI Administration Tool, you can now right-mouse click on an object and choose the "Rename Wizard" option.   This is a short-cut which will invoke the Rename Wizard directly for all the objects you selected.    In OBIEE 10g, you could only invoke the Rename Wizard via the "Tool" menu and it meant you would always have a few extra steps to do the renaming you wanted to.

There is also new new formatting option with the Rename Wizard:  Change all occurences of "_" into a space

12) LDAP Authorization
With the new OBIEE 11g security model, it is now possible for OBIEE to find out the "groups" belonging to a user directly from an LDAP store.    In OBIEE 10g, you could only do this indirectly via a PL/SQL package.

13) BI Publisher - Local Excel Files
It is now possible with BI Publisher 11g to upload your own local MS Excel files and use them as a data source for your BI Publisher reports.

14) RPD File Compression
To reduce storage needs, repositories are now stored in a compressed format. Because of this, you may notice that the size of an RPD file opened and saved in this release is significantly smaller than the size of RPD files from previous releases.

15) Oracle OLAP Integration
OBIEE 11g can now supports Oracle OLAP as a data source.    This means Oracle OLAP is now a definite option for OBIEE if you need to optimise the underlying Data Warehouse.


16) Master-Detail Linking
In addition to "drill-down" and "navigation", there is a new "Master-Detail Linking" capability which allows users to click on one table/graph/map to automatically apply filters to other views within the same Analysis (it can even apply filters to other Analyses on the same Dashboard Page).


17) View Selectors

It is now possible to include Compound Layouts in view selectors.

fyi..refer more:

http://www.peakindicators.com/index.php/knowledge-base/99-obiee-11g-features-the-ones-you-didnt-know

Thanks

Deva

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

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

HI,

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