COMMON
Install WIP Web Server : WIP Install Guide
Install SAP Plugin : WIP Connect to SAP-BI
Install WIP Addon on the client machines : Install WIP Addon
Purge WIP Repositroy
ORACLE Database
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
For each Root Folder you need to migrate to SAP, select the root folder and Press Migrate to SAP
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
Select a folder
Press explorer Check-in
Select only the .unx
Press the check-in button
WIP will create all explorer folder structure inside selected WIP folder recursively
0 Comments