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
ORACLE Database
Pass the Upgrade SCRIPT VMCLASSROOTGUID
...
| Code Block | ||
|---|---|---|
| ||
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;
-- Update VmPackage
UPDATE VMPACKAGE SET PACKAGEKIND = 5 WHERE PACKAGEKIND = 4;
...
)
commit; |
SQLServer Database
| Code Block | ||
|---|---|---|
| ||
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
...