Problems in BI 7.0 Upgradation

These r the some issues which u can face.Duplicate Fiscal Period values in Query If you open up a drop down box ("Select Filter Value") for Fiscal Year/Period to filter your query, you are presented with duplicate entries for Month & Year. Due to Fiscal Year Period InfoObject taking data from Master Data not InfoProvider. Thus it picks up all available periods not just Z2. Auto-Emails being delayed Emails coming from BW from process chains are delayed 2 hours on BW before being released Due to userids that send these emails (e.g. ALEREMOTE) being registered on a diffferent timeazone (i.e. CET) from the BW system (i.e. GMT) “Pgm_Not_Found” short dump Whenever a query is run via RRMX or RSRT Call transaction RS_PERS_ACTIVATE to Activate History and Personalisation Characteristics not found When running a query the warning message Characteristic does not exist is displayed for the following: 0TCAACTVT, 0TCAIPROV, 0TCAVALID We activated the three characteristics listed and the warnings stopped. NO need to make them authorisation-relevant at this stage.(also did 0TCAKYFNM) System generated Z pgms have disappeared Post-upgrade the system Z-pgms ceased to exist Discovered in Development so we compared with pre-upgraded Production and then recreated them or copying them from production. Conversion issues with some Infoobjects Data fails to Activate in the ODS targets For the InfoObjects in question, set the flag so as not to convert the Internal values for these infoobjects InfoObject has Conversion routine that fails, causing load to fail The routine prefixes numeric PO Numbers with 0’s. SD loads were failing as it was not able to convert the numbers. Presumably the cause of the failure was the running of the Pre-Prepare RSMCNVEXIT pgm. Check the Tick box in the Update rule to do the conversion prior to loading rather than the other way round. Requests fail to Activate on numeric data Request loads OK (different from above issue) but fails to Activate Forced conversion within the update rules using Alpha routine. Deleted Request and reloaded from PSA.
Database views missing after pre-PREPARE work Views got deleted from database, although not from data dictionary Recreated the views in the database using SE14.
Workbook role assignations lost We lost a few thousand workbook assignments when we transported the role they were attached to into Production The workbooks did not exist in Development, thus they all went AWOL. We wrote an ABAP program to re-assign them in production

Please go thru the below link https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/9767Hope this helps you.

Kindly check the Service Market Place in the below mentioned links with regards to upgrade.You would find the upgrade guides at http://service.sap.com/instguides or http://service.sap.com/upgrade. You would find the neccesary information in http://service.sap.com/bi .This might also help immensely.Just check.

try this https://www.sdn.sap.com/irj/sdn/wiki?path=/display/BI/Upgrade+from+BW+3.X+to+BI+7.0+%28SP13%29