Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Current »

COMMON

ORACLE Database

  1. Pass the Upgrade SCRIPT VMCLASSROOTGUID 

insert into "VMCLASSROOTGUID"
("BOLD_ID","BOLD_TYPE","CREATEDATE","CREATEUSER","MODIFDATE","MODIFUSER","OBJSTATUS","STOREDGUID")
select "BOLD_ID","BOLD_TYPE",SYSDATE,' ',SYSDATE,' ','1',' '
--SELECT *
from "ABSECUREITEM"
where BOLD_ID NOT IN (SELECT DISTINCT BOLD_ID FROM "VMCLASSROOTGUID")
commit;

SQLServer Database

INSERT INTO [dbo].[VmClassRootGUID]([BOLD_ID],[BOLD_TYPE],[CreateDate],[CreateUser],[ModifDate],[ModifUser],[ObjStatus],[StoredGUID])
SELECT [BOLD_ID],[BOLD_TYPE],'1900-01-01 00:00:00.000','','1900-01-01 00:00:00.000','','1',''
FROM [dbo].[AbSecureItem]
WHERE BOLD_IDNOT IN (SELECT DISTINCT BOLD_ID FROM [dbo].[VmClassRootGUID])

Migrate old VM Installation

If you chose to migrate your old data you need WIP to convert existing VM Folder structure to WIP and split folders containing Universes to another folder structure [Universes], SAP-BI documents will be moved to [Files] section. Note you will not be able to see any documents in the [SAP-BI Files] and [SAP-BI Universes] sections and folders till migration is done

Migrate VM folder structure to WIP

  • Login WIP With VMMANAGER (Access as User / Admin)

  • Select Files Section

  • You need to migrate to SAP, select any root folder and Press Migrate to SAP ( All folders will be migrated not only the selected one)

VM .UNX universes

WIP will not migrate old VM unx universes as the way to store them and process them have totally changed in WIP. You need to import they latest versions from the SAP-Servers.

Once all your SAP Servers connected,

  • login using a SAP-BI Administrator into WIP

  • select or create a Universe Folder in the Universes Section

  • press the SAP-BI Explorer button

  1. Select a folder

  2. Press explorer Check-in

  3. Select only the .unx

  4. Press the check-in button

WIP will create all explorer folder structure inside selected WIP folder recursively

  • No labels