Sunday, October 27, 2013

Total Supply & Total Demand in Demand Summary Shows No Data

APCC - Total Supply & Total Demand Shows blank in the report:
--------------------------------------------------------------------------------
1: Validate the required tables used in the report is getting loaded from the source.
2: Analyse the physical sql of the report for Supply / demand and idenify the query root cause failure
3: If the Fact tables has the data for supply / demand analyse more on the filter criteria
4: Trace back from the Fact table to see how the data population and the dependent objects used by
5: Once the Root cause is found then refresh all the set of objects used to refresh the APCC tables
6: Challenges faced will be between the RBS SSO and OBIEE after serval Trial and Errors finally got it to work
7: RPD Changes for APCC 1: Disables and enabel few initiablock of Transaltion and SSO
8: Change the ocnnection pool and connection scripts for the Db to point to EBS Database.
9: Validate the Database and Database specific features on the RPD to make sure Required features are checked
10: Modify the Instanceconfig and autenicationschema.xml for the SSO to work and hand shake between OBIEE and EBS
11:set the Required profile in EBS for APCC and also the Server name of OBIEE in EBS for Profile.
12: Navitage from EBS supplychain analyst to OBIEE Reports and everyting works as normal and data is visible for Suppply and Demand
13: Challenges faced in finding the right focus area for debug in Database, OBIEE and EBS.
14: Errors Occured - ODBC errors for reports, function not getting called, packages mismatch, RPD database features, Config files, Init blocks etc.

Monday, April 1, 2013

OBIEE 11.1.1.7.0 Released & ready for download

OBIEE 11g Links

http://www.skurabigroup.com/blog/?p=719
http://nerdsofobiee.wordpress.com/
http://www.oramoss.com/wiki/index.php
http://total-bi.com/category/obiee-11g/
http://obieetalk.com/obiee-11gr1-installation-and-initial-configuration
http://www.rittmanmead.com
http://www.ealliancebusinessintelligence.com/knowledge.php
http://sites.google.com/site/ashishrkabra/obiee
http://obiee.nl/?paged=13
http://download.oracle.com/docs/cd/E14571_01/
http://st-curriculum.oracle.com/obe/db/11g/r1/olap/cube/buildicubes.htm
http://sandybi.wordpress.com/2010/08/17/hierarchies-in-obiee-11g-part-1/
http://www.ealliancebusinessintelligence.com/implementingobiee.php
http://www.cetanasoftware.com/blog/
http://onlineappsdba.com/index.php/
http://shivabizint.wordpress.com/
http://skrajend.blogspot.com/
http://www.analyticspartners.com/ProductsServices/11G.aspx
http://obieetalk.com/obiee-11gr1-basic-system-administration