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.

1 comment:

Unknown said...

I am surprised that these steps are showing no data. There must be something that you are missing. Anyway thanks for sharing your thoughts. We have some OBIEE tutorials that may benefit your readers at https://www.youtube.com/playlist?list=PLbbJy7LxchQNrpaqFXQQ2eUEccYVI1sS2