Skip to Content
avatar image
Former Member

Can we add rows to VM$_TMP_WIP_TABLES, to create additional synonyms in ODS?

We would like to add two more synonyms to the ODS, which will point back to tables in WIP, via the database link. There are 59 synonyms now in our ODS (ME 6.1.4). Those are generated by Oracle stored procedure Create_ODS_Synonym_Proc, based on the 59 rows in VM$_TMP_WIP_TABLES. Would there be any harm if we would add two rows to that table, in order to force the core procedure to generate our two additional synonyms? Would it work?

Thanks,

Barry

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 03, 2015 at 09:45 AM

    Hi Barry,

    There's nothing to stop you, but that's not how it is intended to work.

    There are 3 create synonyms SQL scripts which find all tables named like AL_% ODS_% or AR_% with the list temporarily put into that TMP table just before it calls Create_ODS_Synonym_Proc which uses that list so the contents you see in the TMP table is from the last of the three to run.

    The problem is that the TMP tale will be dropped and recreated each time the script runs, so if you want a repeatable script, it would be easier just to create and execute an SQL script to create your two synonyms.

    But you write that you want the synoyms to point back to tables in WIP: nothing wrong with that, but the standard synonyms created by this procedure point to tables in ODS so that they can be accessed as if they were WIP tables. So an alternative might be to use the AL tables?

    Regards,

    Andrew.

    Add comment
    10|10000 characters needed characters exceeded

    • Barry

      The simplest way is to let the CTC wizard execute the SQL scripts. You can locate the SQL scripts on the server, but it's best and easiest just to re-execute the CTC.

      See section 4.1.3 of the installation guide, titled Executing “SAP ME Database Setup for Installation”. In this, there is simply a check box "Create Database Tables for SAP BusinessObjects Reports". This creates the ODS reporting tables required for the BOBj reports and also the synonyms back to WIP. So, this entire CTC can be re-executed even if just the reporting tables/synonyms were missed the first time.