Synopsis
360Eyes [OPTIONS] <jobType> <cms> <user> <password> <auth> <configurationFolder>
Description
360Eyes is a powerful tool for auditing and analyzing your BOE platform.
GENERAL PARAMETERS
- -DBurl=<eyesDatabaseJDBCurl>
-
360eyes DataBase JDBC URL (Mandatory parameter)
Jobs:
ALL - -DBuser=<eyesDatabaseUser>
-
360eyes Database User (Mandatory parameter)
Jobs:
ALL - -DBpass=<eyesDatabasePassword>
-
360eyes Database Password (Mandatory parameter)
Jobs:
ALLThe password can be set in clear text, or using encoded text surrounded with "ENC()".
-
E.G. -DBpass=ENC(DiEH6AbsS==)Note: See the online documentation to encode the password: https://360eyes.documentation.wiiisdom.com/en_US/guides/passwordEncryption).
-
- -schema=<eyesDatabaseSchema>
-
360eyes Database SCHEMA .
Jobs:
ALLSet this parameter only if your 360Eyes database has schemas.
- -replaceMode
-
Sets how snapshots will be created .
Jobs:
ALLDefault value:
REPLACE-
-replaceMode=REPLACEreplaces the previous snapshot. -
-replaceMode=ADDadds a new snapshot.
-
- -keep
-
Keeps the Snapshot in the 360Eyes database.
It will never be replaced by another Snapshot and can only be deleted manually.
Warning: Do not set this parameter in the 360eyes.param file, it must be set only as an argument of the job instance.
Jobs:
CMS, IA, WEBI, CRYSTAL, UNIVERSEDefault value:
OFF-
'-keep' will keep and lock the snapshot in the database.
-
- -snapshot.limit
-
Limits the number of snapshots to keep .
Jobs:
ALLDefault value:
OFF-
-snapshot.limit=ONkeeps a defined number of snapshots, and deletes the oldest snapshot when the limit is reached. -
-snapshot.limit=OFFkeeps all generated snapshots.Note: If set -snapshot.limit=ON you must specify the snapshot.count.max parameter.
-
- -snapshot.count.max=<maxSnapshotCount>
-
Sets the maximum number of snapshots to keep .
Jobs:
ALLDefault value:
3 - -loadingMode=<loadingMode>
-
Sets how the data will be extracted .
Jobs:
ALL-
loadingMode=FULLwill extract all objects even if they have not been modified between two job executions.Even if you set
loadingMode=FULL, in the case the previous job execution failed then the job will continue the extraction from where it failed. -
loadingMode=FULLFORCEDwill force FULL mode even if previous job execution failed. -
loadingMode=DELTAwill extract objects that have been modified since the last job execution
-
- -previousSnapshotId=<previousSnapshotId>
-
Redefines the preceding Snapshot ID from which the job must initiate in DELTA mode. By default, the job starts from the latest previous Snapshot ID.
- -fullAnalysis
-
No matter which loadingMode is chosen, extract all impact analysis data.
Jobs:
IA, WEBI, CRYSTAL, UNIVERSEDefault value:
OFF-
-fullAnalysis=OFFwill extract impact analysis data from previous snapshot if loadingMode=DELTA. -
-fullAnalysis=ONwill extract all impact analysis data from beginning.
-
- -delta.deletebehavior
-
Sets the behavior for deleted documents.
Prerequisites :
-loadingMode=DELTAJobs:
WEBI,CRYSTAL,IA,UNIVERSEDefault value:
DELETE-
-delta.deletebehavior=DELETEdelete the rows corresponding to the removed SAP BusinessObjects documents and universes. -
-delta.deletebehavior=FLAGflag the rows corresponding to the removed SAP BusinessObjects documents and universes (Faster job execution).FLAGwill respectively set the DOCUMENT_DELETED or UNIVERSE_DELETED columns from EYE_DOCUMENT or EYE_UNIVERSE tables to 1.
-
- -delta.failed_doc
-
Sets the behavior for failed documents.
Prerequisites :
-loadingMode=DELTAJobs:
WEBI,CRYSTAL,IA,UNIVERSEDefault value:
DISMISS-
-delta.failed_doc=RETRYwill analyse the documents that failed in the previous job execution. -
-delta.failed_doc=DISMISSwill skip the documents that failed in the previous job execution unless they have been modified.
-
- -folderType[=<folderType>[\s*,\s*<folderType>…] [<folderType> [<folderType> [<folderType>]]]]
-
Sets the type of top level folders from which to extract metadata and documents.
Jobs:
CMS,WEBI,CRYSTAL,IADefault value:
PUBLICThe parameter can contain multiple values separated by
,from the following list:-
PUBLIC
-
FAVORITE
-
INBOX
-
TEMP
Eg.
-folderType=PUBLIC|-folderType=PUBLIC,TEMP|-folderType=PUBLIC,FAVORITE,INBOX,TEMP
-
- -usage, -extractObjectUsage
-
Activates extraction of objects usage .
Jobs:
WEBI,CRYSTAL,IADefault value:
OFF-
-extractObjectUsage=OFFDon’t activate usage extraction for queried objects. -
-extractObjectUsage=ONActivates usage extraction for queried objects.
-
- -extractDocumentContent
-
Activates extraction of documents' content (i.e. blocks, cells, etc) .
Jobs:
WEBIDefault value:
OFF-
-extractDocumentContent=OFFDon’t activate documents' content extraction. -
-extractDocumentContent=ONActivates Extract documents' content extraction.
-
- -cms.content=<cmsContents>
-
Sets the kinds of content to extract with the CMS job .
Jobs:
CMSDefault value:
FOLDER,GROUP,USER,CONNECTION,UNIVERSE,OVERLOAD,DOCUMENT,APPLICATION,INSTANCEThe parameter can contain multiple values separated by
,from the following list:-
FOLDERExtract Folders (also depends on-folderType). -
DOCUMENTExtract Documents (also depends on-folderType). -
INSTANCEExtract Documents' Instances (also depends on-folderType). -
DOCUMENT_PROMPTExtract Document Instances' Prompts and Prompts' values (also depends on-folderType). -
GROUPExtract User Groups. -
USERExtract Users. -
USER_CONNECTIONExtract User Connections. Login and Logout out events in the audit database. Also extracts Login errors. -
USER_SESSIONExtract User Sessions. Calculate users' session duration. To feed '360eyes CMS - 20 Session Peak' only. -
APPFOLDERExtract Universe Folders, Connection Folders. -
CONNECTIONExtract Connections. -
UNIVERSEExtract Universes. -
OVERLOADExtract Universes' Restrictions. -
ACCESSLEVELExtract Access Levels. -
SERVERExtract Servers. -
APPLICATIONExtract Applications. -
QAAWSExtract QAAWS. No provided document. -
EVENTExtract Events. No provided document. -
CALENDARExtract calendars. No provided document. -
PROFILEExtract Users' Profiles. No provided document. -
PROMOTIONJOBExtract Promotion Jobs. No provided document. -
BUSINESSVIEWExtract Business Views. No provided document. -
SERVER_LICExtract SAP BusinessObjects licenses. No provided document. -
FRS_CHECKExtract whether an object still exists in the SAP BusinessObjects FRS. No provided document.
-
- -loglevel=<logLevel>
-
Sets the Eyes Job Logging Level. Ranging from detailed debug information to critical errors, it allows developers to filter and prioritize log output for efficient debugging and monitoring of applications. Possible values: TRACE DEBUG INFO WARN ERROR
- -loglevelrestfulapi=<loglevelRestfulApi>
-
Sets the Eyes Job RESTFUL Logging Level. Ranging from detailed debug information to critical errors, it allows developers to filter and prioritize RESTFUL log output for efficient debugging and monitoring of applications. Possible values: TRACE DEBUG INFO WARN ERROR
- -cms.content.instance.schedule_status=<cmsInstanceStatuses>[\s*,\s*<cmsInstanceStatuses>…]
-
Limit the number of extracted instances by filtering them by schedule status.
Jobs:
CMSDefault value:
ALLThe parameter can contain multiple values separated by
,from the following list:-
RECURRINGExtract only recurring instances. -
RUNNINGExtract only running instances. -
SUCCESSExtract only succeeded instances. -
ERRORExtract only failed instances. -
EXPIREDExtract only expired scheduled instances. -
PAUSEDExtract only paused scheduled instances. -
ALLExtract all instances.
-
- -cms.calendarLimitDays=<cmsCalendarLimitDays>
-
Sets the maximum number of future calendar days to extract.
Prerequisites :
-cms.content=CALENDARJobs:
CMSDefault value:
50 - -parseDataProviderSQL
-
Parses the documents' dataproviders SQL queries in order to extract queried tables and columns.
Jobs:
WEBI,CRYSTAL,IADefault value:
OFF - -universe.parsederivedtablesql
-
Parses the universes' derived tables SQL queries in order to extract queried tables and columns.
Jobs:
UNIVERSEDefault value:
OFF - -parseDataProviderSQL.parser=<dataProviderSqlParser>
-
Sets the SQL parser technology used .
Jobs:
WEBI,CRYSTAL,IA,UNIVERSEDefault value:
DEFAULT-
-parseDataProviderSQL.parser=DEFAULTSets parser to DEFAULT for classic agnostic database engine queries analysis. -
-parseDataProviderSQL.parser=ORACLESets parser to ORACLE for complex Oracle queries analysis. -
-parseDataProviderSQL.parser=BIGQUERYSets parser to BIGQUERY for complex BIGQUERY queries analysis.Note: If set to
ORACLE, in case of issue, theDEFAULTparser is used for a second try.
-
- -ia.content=<iaContent>[\s*,\s*<iaContent>…]
-
Sets the kinds of content to extract with the IA job .
Jobs:
IADefault value:
EXPLORERSPACE,XCELSIUS,QAAWS,ANALYSIS_OLAP,DESIGNSTUDIO-
WEBIPerforms impact analysis on Web Intelligence documents. Equivalent to run the WEBI job. -
CRYSTALREPORTPerforms impact analysis on Web Intelligence documents. Equivalent to run the CRYSTAL job. -
LUMIRAPerforms impact analysis on Lumira Discovery & Designer dashboards. -
SHAREDELEMENTPerforms impact analysis on shared report elements. -
DESIGNSTUDIOPerforms impact analysis on old Design Studio dashboards. (Deprecated) -
QAAWSPerforms impact analysis on QAAWS. -
EXPLORERSPACEPerforms impact analysis on information spaces and exploration views. -
ANALYSIS_OLAPPerforms impact analysis on Analysis OLAP. -
HYPERLINKPerforms impact analysis on Hyperlinks between documents. -
XCELSIUSPerforms impact analysis on Xcelsius dashboards. -
AGNOSTICExtract audit actions for all other agnostic dontent in SAP BusinessObjects.Note: Audit actions are extracted running the IA, WEBI, CRYSTAL jobs.
-
- -crystal.sdk=<crystalSdk>
-
Sets the Crystal SDK technology used.
Jobs:
CRYSTALDefault value:
DEFAULT-
-crystal.sdk=DEFAULTSets to RAS then INFOSTORE as failover. -
-crystal.sdk=RASSets SDK to RAS. -
-crystal.sdk=INFOSTORESets SDK to INFOSTORE. -
-crystal.sdk=LocalSets SDK to INFOSTORE. Requires extra configuration.Note: If set to
DEFAULT, in case of issue, theINFOSTORESDK is used for a second try.
-
- -cms.futureinstancesdays=<daysAheadToCompute>
-
Sets on how many days to calculate the future instances executions.
Jobs:
CMSDefault value:
0 - -cms.isTimeStampUTC
-
Sets dates timezone .
Jobs:
CMSDefault value:
ON-
-cms.isTimeStampUTC=OFFDoes not activate date conversion to UTC timezone. -
-cms.isTimeStampUTC=ONActivates date conversion to UTC timezone.
-
- -paramFile=<paramFile>
-
Absolute path to a 360eyes parameter file
- -cms.content.document.type=<cmsDocumentType>[\s*,\s*<cmsDocumentType>…]
-
Sets the types of document to extract with the CMS job.
Jobs:
CMSThe parameter can contain multiple values separated by
,from the following list:-
WEBIExtract Web Intelligence documents. -
CRYSTALREPORTExtract Crystal Reports and Crystal Reports for Enterprise documents. -
PUBLICATIONExtract Publication objects. -
PROGRAMExtract Program objects. -
LCMJOBExtract Promotion Job. -
PDFExtract PDF documents. -
EXCELExtract Excel documents. -
WORDExtract Word documents. -
POWERPOINTExtract PowerPoint documents. -
TXTExtract Text documents. -
VISILUMSExtract Lumira documents. -
LUMXExtract Lumira documents. -
ANALYSISExtract Analysis for Office documents. -
AGNOSTICExtract Agnostic documents. -
OTHERExtract all others types of documents.
-
COLLIBRA PARAMETERS
- -collibra.url=<collibraUrl>
-
Collibra URL (Mandatory parameter)
- -collibra.username=<collibraUserName>
-
Collibra User (Mandatory parameter)
- -collibra.password=<collibraPassword>
-
Collibra Password (Mandatory parameter)
The password can be set in clear text, or using encoded text surrounded
with “ENC()”.
- -collibra.domain.id=<collibraDomainId>
-
Sets the Id of the domain in
the Collibra instance where the metadata will be imported.
- -collibra.import.status.nbRetryMax=<collibraImportStatusNbRetryMax>
-
Sets the maximum number of retries to get the status of the Import Job in Collibra.
Default value:
50-
'-collibra.import.status.nbRetryMax=50' will retry a maximum of 50
times maximum before failing the COLLIBRA job.
-
- -collibra.sap-bo-server.filter=<collibraSapBoServerFilter>
-
Filters on the SAP BusinessObjects Server CMS name.
Jobs:
COLLIBRAThe parameter can contain multiple values separated by
,.-
-collibra.sap-bo-server.filter=mycms.mybo.comwill exportonly the metadata corresponding to the specified server name to Collibra.
-
- -collibra.export-sql-queries
-
Enables the extraction of the SAP BusinessObjects SQL Queries to Collibra Platform.
This parameter will enrich the Collibra attributes:
SAP BO SQL Queries,SAP BO Universe Obj SelectandSAP BO Universe Obj Where.Jobs:
COLLIBRA-
-collibra.export-sql-queries=ONwill enable the sending of all the SQL statements to Collibra.
-
- -collibra.asset.status=<collibraAssetStatus>
-
Sets another default Status for all Assets imported in Collibra.
By default, the Assets will be created with the "Approved" Collibra status.
If the defined status is not present in the Collibra platform, the import tasks will failed.Jobs:
COLLIBRA-
-collibra.asset.status=Acceptedwill create all SAP BO Assets with the "Accepted" status.
-
- -collibra.sql.batch.size=<collibraSqlBatchSize>
-
Extracts data from 360Eyes database by block of N objects.
Jobs:
COLLIBRADefault value:
10000-
-collibra.batch.size=1will extract data one by one. -
-collibra.batch.size=Nwill extract data in packets of N.
-
CMS SECURITY
- -securityMode=<securityMode>
-
Sets the security extraction behavior .
Jobs:
CMSDefault value:
OFF-
OFF: No security information is extracted. -
EXPLICITExtracts the explicit security. -
INHERITEDExtracts the explicit and inherited security. As displayed in the CMC, meaning it will not compute groups and users hierachies. -
EFFECTIVEExtracts the effective security for all groups and users hierarchy. This option is time consuming. -
ADVANCEDExtracts the effective security as well as advanced permissions defined in thesecurityFineRightsparameter. -
QUICKADVANCED, Same asADVANCEDwith an alternative algorithm.
-
- -inherited
-
Sets
securityModetoINHERITED - -effective
-
Sets
securityModetoEFFECTIVE - -advanced, -effectiveplus
-
Sets
securityModetoADVANCED - -quickfine, -quickadvanced
-
Sets
securityModetoQUICKADVANCED - -securityFineRights, -securityAdvancedRights=<securityFineRights>[\s*,\s*<securityFineRights>…]
-
Sets the advanced permissions that are analyzed when
securityModeis set toADVANCEDorQUICKADVANCED.Jobs:
CMSDefault value:
View objectsThe parameter can contain multiple values separated by
,. - limitMode, -limitMode
-
Enables the extraction of excess instances limits, specific rights that automates how object instances are cleaned up in the system.
/!\ Limits are not extracted when
securityModeis set toQUICKADVANCED.Jobs:
CMSDefault value:
OFF-
-limitMode=OFFLimits are not extracted. -
-limitMode=ONLimits are extracted.
-
- -securityObjects=<securityObjects>[\s*,\s*<securityObjects>…]
-
Sets the kinds of content for which the security is extracted .
Jobs:
CMSDefault value:
GROUP,USER,UNIVERSE,OVERLOAD,CONNECTION,FOLDER,DOCUMENT,APPLI,APPFOLDER - -folderTypeSecurity=<folderTypeSecurity>[\s*,\s*<folderTypeSecurity>…]
-
Sets the type of top level folders from which to extract security .
Jobs:
CMSDefault value:
PUBLICThe parameter can contain multiple values separated by
,from the following list:-
PUBLIC
-
FAVORITE
-
INBOX
-
TEMP
Eg.
-folderTypeSecurity=PUBLIC|-folderTypeSecurity=PUBLIC,FAVORITE|-folderTypeSecurity=PUBLIC,FAVORITE,INBOX,TEMP
-
- -securityPrincipals=<securityPrincipals>[\s*,\s*<securityPrincipals>…]
-
Sets the principals type for which to extract security .
Jobs:
CMSDefault value:
GROUP,USERThe parameter can contain multiple values separated by
,from the following list:-
GROUP
-
USER
Eg.
-securityPrincipals=GROUP,USER|-securityPrincipals=GROUP|-securityPrincipals=USER`This parameter has an effect only if `securityModeis set toEFFECTIVE,ADVANCEDorQUICKADVANCED.
-
- -securityprincipalids=<securityPrincipalIDs>[\s*,\s*<securityPrincipalIDs>…]
-
Sets the principal IDs for which you want to extract security
Jobs:
CMSThe parameter can contain multiple values separated by
,.If empty, the extraction is made for all principals.
This parameter has an effect only if
securityModeis set toEFFECTIVE,ADVANCEDorQUICKADVANCED.
AUDIT DATA
- -audit.extended
-
Enables analysis of audit event details.
Prerequisites :
-cms.content=USER_CONNECTIONJobs:
CMSDefault value:
OFF-
-audit.extended=ONwill extract the audit event details about documents' actions and users' connections. -
-audit.extended=OFFwill not extract any audit event details.Events details extracted : ROW_COUNT, FORMAT, IP_CLIENT, IP_SERVER & MESSAGE.
-
- -cms.session.sampling[=<cmsSessionSampling>]
-
Sets the sampling precision of the user session calculation in minutes.
Prerequisites :
-cms.content=USER_SESSION,USERJobs:
CMSDefault value:
60-
-cms.session.sampling=NSessions' duration is calculated with a N minutes precision.
-
- -auditor.users_to_include_from_audit=<auditorUsersToIncludeFromAudit>
-
Limits the analysis of audit data to the specified usernames.
The parameter can contain multiple usernames separated by
,.Jobs:
CMS, AUDIT-
-auditor.users_to_include_from_audit=…will extract audit data for specified users only.
-
- -auditor.users_to_exclude_from_audit=<auditorUsersToExcludeFromAudit>
-
Excludes the specified usernames from the audit data analysis.
The parameter can help to not retrieve fake events generated by 360eyes.
The parameter can contain multiple users' names separated by
,.Jobs:
CMS, AUDIT-
-auditor.users_to_exclude_from_audit=Xwill not extract audit data for specified usernames.
-
- -audit.since[=<auditSince>]
-
Limits the audit data extraction to the last X months.
By default, the job extracts audit data from the last month only.
Jobs:
CMS, AUDIT-
-audit.since=Xwill extract audit data of the last X months.Caution : The higher the value, the longer it takes to complete the job.
-
- -restartFromAuditSince
-
Purge and restart the Audit Event extraction to the last X months.
Jobs:
AUDITDefault value:
OFF-
-restartFromAuditSince=ONwill purge already extracted Audit Event data to restart from audit.since. -
-restartFromAuditSince=OFFwill continue the extraction from last event date extracted.
-
- -audit.batch.size[=<auditBatchSize>]
-
Extracts data from SAP BOBJ Audit database by block of N objects.
Jobs:
CMS, AUDITDefault value:
100000-
-audit.batch.size=1will extract data one by one. -
-audit.batch.size=Nwill extract data in packets of N.
-
- -anonymize, -anonymize_audit
-
Anonymizes all extracted Audit data.
Jobs:
AUDITDefault value:
OFF-
-anonymize_audit=OFFwill not encrypt all usernames. -
-anonymize_audit=ONwill encrypt all usernames.
-
- -DBAUDurl=<dbauDurl>
-
Sets the SAP BusinessObjects Audit Database JDBC URL.
- -DBAUDuser=<dbauDuser>
-
Sets the SAP BusinessObjects Audit Database User.
- -DBAUDpass=<dbauDpass>
-
Sets the SAP BusinessObjects Audit Database password.
The password can be set in clear text, or using encoded text surrounded with "ENC()".
-
E.G. -DBAUDpass=ENC(DiEH6AbsS==)Note: See the online documentation to encode the password: https://360eyes.documentation.wiiisdom.com/en_US/guides/passwordEncryption).
-
- -audit.prefix=<auditPrefix>
-
Sets the table’s prefix used for the SAP BusinessObjects Audit Database.
-
-audit.prefix=dbowill add 'dbo.' before each tables' name in all SQL queries.
-
- -audit.event_types=<auditEventTypes>
-
Sets the Event Types to extract with the AUDIT job.
WEBI PARAMETERS
- -webi.alerters
-
Enables WebIntelligence documents' alerters extraction.
Jobs:
WEBIDefault value:
OFF-
-webi.alerters=OFFwill not extract detailed data about alerters. -
-webi.alerters=ONwill extract detailed data about alerters.
-
- -webi.properties
-
Enables WebIntelligence documents' properties extraction.
Properties extracted: Creation Time, Modification Time, Refresh On Open, Strip Query,Permanent Regional Formatting, Merge Prompts, Extend Merged Dimensions, Query Drill, Auto SynchroHide Warnings In Chart, Enable Alternate User To Edit Doc, Can Enable Query Stripping, Author.
Jobs:
WEBIDefault value:
OFF-
-webi.properties=OFFwill not extract WebIntelligence documents' properties. -
-webi.properties=ONwill extract WebIntelligence documents' properties.
-
- -webi.variables
-
Enables the extraction of WebIntelligence documents' variables' basic information.
Jobs:
WEBIDefault value:
OFF-
-webi.variables=ONwill extract variable’s Id, Name, Qualification and Type. -
-webi.variables=OFFwill not extract variables.
-
- -webi.variables.details
-
Enables the extraction of WebIntelligence documents' variables' details.
Jobs:
WEBIDefault value:
OFF-
-webi.variables.details=ONwill extract variable’s Description and Formula. -
-webi.variables.details=OFFwill not extract variable’s Description and Formula.
-
- -webi.dataproviders
-
Enables WebIntelligence documents' dataproviders extraction.
Jobs:
WEBIDefault value:
OFF-
-webi.dataproviders=OFFwill not extract WebIntelligence documents' dataproviders. -
-webi.dataproviders=ONwill extract WebIntelligence documents' dataproviders.
-
- -webi.dataproviders.prompts
-
Enables WebIntelligence documents' dataproviders' prompts extraction.
Jobs:
WEBIDefault value:
OFF-
-webi.dataproviders.prompts=OFFwill not extract dataproviders' prompts. -
-webi.dataproviders.prompts=ONwill extract dataproviders' prompts.
-
- -webi.dataproviders.queryplan
-
Enables WebIntelligence documents dataproviders' query plan extraction.
Extract IsUsingSetOperator and IsCustomSql field. Sql Query is extracted too in some case.
Caution : Only available from SAP BO BI4.1 SP4.
Jobs:
WEBIDefault value:
OFF-
-webi.dataproviders.queryplan=OFFwill not extract dataproviders' query plan. -
-webi.dataproviders.queryplan=ONwill extract dataproviders' query plan.
-
- -webi.dataproviders.queryspecification
-
Enables WebIntelligence documents' dataproviders' query objects extraction.
Jobs:
WEBIDefault value:
OFF-
-webi.dataproviders.queryspecification=OFFwill not extract dataproviders' query objects. -
-webi.dataproviders.queryspecification=ONwill extract dataproviders' query objects.
-
- -webi.reports
-
Enables WebIntelligence documents' contents extraction (table, cells,…).
Jobs:
WEBIDefault value:
OFF-
-webi.reports=OFFwill not extract documents' contents. -
-webi.reports=ONwill extract documents' contents.
-
- -webi.reports.hierarchy
-
Enables WebIntelligence documents' contents' drill hierarchies extraction.
Allows knowing if Query Objects are drillable. Fills the column
EYE_QUERY_OBJ.OBJ_IS_DRILLABLE.Prerequisites :
-webi.reports=ONJobs:
WEBIDefault value:
OFF-
-webi.reports.hierarchy=OFFwill not extract documents' reports' drill hierarchies. -
-webi.reports.hierarchy=ONwill extract documents' reports' drill hierarchies.
-
- -webi.reports.filter
-
Enables WebIntelligence documents' contents' filters extraction.
Extracts detailed information from the filters applied to the contents and contents' elements.
Prerequisites :
-webi.reports=ON and (-extractObjectUsage=ON or -extractDocumentContent=ON)Jobs:
WEBIDefault value:
OFF-
-webi.reports.filter=OFFwill not extract data of reports' filters. -
-webi.reports.filter=ONwill extract data of reports' filters.
-
- -webi.folder.webintelligence
-
Enables
~WebIntelligencefolder extraction.Jobs:
WEBIDefault value:
OFF-
-webi.folder.webintelligence=OFFwill not extract documents from ~WebIntelligence folder. -
-webi.folder.webintelligence=ONwill extract documents from ~WebIntelligence folder.
-
- -webi.notscanbexqueries
-
Disables WebIntelligence documents' dataproviders' Bex Queries extraction.
Prerequisites :
-webi.dataproviders=ONJobs:
WEBIDefault value:
FALSE-
-webi.notscanbexqueries=FALSEwill extract data from dataproviders' Bex Queries. -
-webi.notscanbexqueries=TRUEwill not extract data from dataproviders' Bex Queries.
-
- -nocleanupcms
-
Disables the cleaning of all objects deleted since the last CMS snapshot.
By default, all objects deleted in SAP BusinessObjects since the last CMS snapshot are purged from the 360Eyes database.
Jobs:
CLEANUPDefault value:
FALSE-
-nocleanupcms=FALSEwill purge all objects deleted since the last CMS Job execution. -
-nocleanupcms=TRUEwill not purge all objects deleted since the last CMS Job execution.
-
- -nocleanupuniverse
-
Disables the cleaning of all objects deleted since the last UNIVERSE snapshot.
By default, all objects deleted in SAP BusinessObjects since the last UNIVERSE snapshot are purged from the 360Eyes database.
Jobs:
CLEANUPDefault value:
FALSE-
-nocleanupuniverse=FALSEwill purge all objects deleted since the last UNIVERSE Job execution. -
-nocleanupuniverse=TRUEwill not purge all objects deleted since the last UNIVERSE Job execution.
-
- -nocleanupwebi
-
Disables the cleaning of all objects deleted since the last WEBI snapshot.
By default, all objects deleted in SAP BusinessObjects since the last WEBI snapshot are purged from the 360Eyes database.
Jobs:
CLEANUPDefault value:
FALSE-
-nocleanupwebi=FALSEwill purge all objects deleted since the last WEBI Job execution. -
-nocleanupwebi=TRUEwill not purge all objects deleted since the last WEBI Job execution.
-
- -nocleanupcrystal
-
Disables the cleaning of all objects deleted since the last CRYSTAL snapshot.
By default, all objects deleted in SAP BusinessObjects since the last CRYSTAL snapshot are purged from the 360Eyes database.
Jobs:
CLEANUPDefault value:
FALSE-
-nocleanupcrystal=FALSEwill purge all objects deleted since the last CRYSTAL Job execution. -
-nocleanupcrystal=TRUEwill not purge all objects deleted since the last CRYSTAL Job execution.
-
DEBUG FLAGS
- -limits=<limits>
-
Limits the number of objects extracted from SAP BusinessObjects.
Jobs:
ALLDefault value:
100000000-
-limits=Nwill extract only N first objects.
-
- -blocksize=<blockSize>
-
Extracts data from SAP BusinessObjects by block of N objects.
Useful to avoid locking the SAP BusinessObjects database.
Jobs:
ALLDefault value:
1000-
-blocksize=Nwill extract data by block of N objects.
-
- -sql.batch.size[=<sqlBatchSize>]
-
Inserts data in 360Eyes database by block of N objects.
Jobs:
ALLDefault value:
1000-
-sql.batch.size=1will insert data one by one. -
-sql.batch.size=Nwill insert data in packets of N.
-
- -delete.blocksize=<deleteBlockSize>
-
Deletes data in 360Eyes database by block of N objects.
Useful to avoid locking the 360Eyes database.
Jobs:
ALLDefault value:
0-
-delete.blocksize=0will delete all objects in one block. -
-delete.blocksize=Nwill delete data by block of N objects.
-
- -executor.timeout=<executorTimeout>
-
Set a timeout of N minutes for the asynchronous subtasks.
Useful to avoid stuck jobs.
Jobs:
IA, WEBI, CRYSTAL, UNIVERSEDefault value:
60-
-executor.timeout=Nwill stop the subtask after N minutes.
-
- -no_impact_analysis
-
Disables documents' contents extraction.
Jobs:
IA, WEBI, CRYSTAL-
-no_impact_analysiswill not extract data about documents.
-
- -no_db_update
-
Disables the update of the 360Eyes Database, considering the DB is up-to-date.
Jobs:
CMS, COMPLIANCE-
-no_db_updatewill not update the 360Eyes database.
-
- -forcecluster=<forcedClusterName>
-
Sets a custom CMS Name in 360Eyes to create a cluster of snapshots.
=> The custom CMS Name will be also set in the document's hostname in 360Eyes.
Jobs:
ALL-
-forcecluster=…will set a custom CMS name in the 360Eyes database.
-
- -ia.reader_max_size_mb_memory[=<iaReaderMaxSizeMbMemory>]
-
internal use only, do not use.
- -restart[=<restartCycle>]
-
internal use only, do not use
- -ids_to_exclude=<idsToExclude>
-
Excludes the specified objects' IDs or CUIDs from the extraction.
Jobs:
CMS, WEBI, CRYSTAL, IA, UNIVERSEThe parameter can contain multiple values, IDs and CUIDs mixed, separated by
,.-
-ids_to_exclude=Xwill not extract data from the item X.
-
- -ids=<idsToExtract>
-
Limits the extraction to the specified objects' IDs or CUIDs.
Jobs:
CMS, WEBI, CRYSTAL, IA, UNIVERSEThe parameter can contain multiple values, IDs and CUIDs mixed, separated by
,.-
-ids=Xwill extract data from the object X only.
-
- -parent_ids=<parentIdsToExtract>
-
Limits the extraction to the objects present in the specified folders' IDs or CUIDs.
Jobs:
CMS, WEBI, CRYSTAL, IA, UNIVERSEFor CMS job, this parameter only applies to the FOLDER and DOCUMENT content types.
The parameter can contain multiple values, IDs and CUIDs mixed, separated by
,.-
-parent_ids=Xwill extract data from all documents and folders in the parent folder X only.
-
- -parent_ids_to_exclude=<parentIdsToExclude>
-
Excludes the objects present in the specified parents' IDs or CUIDs from the extraction.
Jobs:
CMS, WEBI, CRYSTAL, IA, UNIVERSEFor CMS job, this parameter only applies to the FOLDER and DOCUMENT content types.
The parameter can contain multiple values, IDs and CUIDs mixed, separated by
,.-
-parent_ids_to_exclude=Xwill not extract data from all documents and folders present in the parent folder X.
-
FINE TUNING (Do not modify unless explicitly asked by 360eyes team members)
- -snapshot.distinct.user
-
Enables the possibility to distinguish two snapshots by the user name, in addition to the type and CMS.
Jobs:
ALLDefault value:
OFF-
-snapshot.distinct.user=ON: will not replace a snapshot ran by a different user. -
-snapshot.distinct.user=OFF: will replace a snapshot ran by a different user.
-
- -extractDocumentInstances=<extractDocumentInstances>
-
Enables the extraction of documents' instances.
Jobs:
IA, WEBI, CRYSTALDefault value:
OFF-
-extractDocumentInstances=OFFwill not extract data about documents' instances. -
'-extractDocumentInstances=LASTONLY` will extract data about the last instance of documents.*
-extractDocumentInstances=ONwill extract data about documents' instances.
-
- -ia.key_obj
-
Sets the kind of KEY_OBJ link between universe data and report data.
Jobs:
IA, WEBI, CRYSTAL, UNIVERSEDefault value:
ID-
-ia.key_obj=IDwill links universe and report by the object ID. -
-ia.key_obj=NAMEwill links universe and report by the object NAME.
-
- -opendoc.regexp=<openDocREGEXP>
-
Sets a Regular Expression to detect and extract opendoc Linked documents.
Jobs:
IA, WEBI, CRYSTALDefault value:
.*openDocument.jsp.*iDocID=(\w+)&.*-
-opendoc.regexp=.openDocument\.jsp.*iDocID=(\w+)&.will extract all opendoc linked documents by the iDocID.
-
- -syntax.upperSQLKeywords
-
Saves SQL Keywords as capital letters in the 360Eyes database.
Jobs:
IA, WEBI, CRYSTAL, UNIVERSEDefault value:
OFF-
-syntax.upperSQLKeywords=OFFwill not transform SQL keywords in capital letters. -
-syntax.upperSQLKeywords=ONwill transform SQL keywords in capital letters.
-
- -lmbi[=<lmbiCategories>]
-
Enables the extraction of access rights defined on categories from the License Measurement tool for SAP BusinessObjects Business Intelligence platform (LMBI).
Jobs:
COMPLIANCE-
-lmbiwill extract rights defined on categories for each user from the LMBI.
-
- -restful.url=<restfulURL>
-
Overrides the RESTful WebService URL provided by SAP Business Object.
Jobs:
IA, CRYSTAL, WEBI-
-restful.url=http://<host>:<port>/biprwswill force the 360Eyes jobs to call this url in place of the one configured in the SAP Business Object.
-
- -restful.timeout=<restfulTimeout>
-
Sets a timeout in seconds after which the call to the SAP RESTFUL Web Service will be canceled.
Jobs:
IA, CRYSTAL, WEBIDefault value:
3600-
-restful.timeout=600will cancel the call after 10 minutes, even if the API doesn’t return the response.
-
- -threads=<threads>
-
Sets the maximum number of threads that the 360Eyes job can use.
Jobs:
WEBIDefault value:
0The possible values are :
-
-threads=1will disable the multi threading, -
-threads=0will use all available threads, -
-threads=nwill use n threads (within the limit of the number of cpu cores available).
-
- -nbThreadsWhenCopyingSnapshot=<nbThreadsWhenCopyingSnapshot>
-
Sets the maximum number of threads that the 360Eyes job can use to copy data from the previous snapshot to the new one.
Jobs:
ALLDefault value:
0The possible values are :
-
-threads=1will disable the multi threading, -
-threads=0will use all available threads, -
-threads=nwill use n threads (within the limit of the number of cpu cores available).
-
- -extract.translation
-
Activates extraction of the Universes objects translations.
Jobs:
UNIVERSE-
-extract.translation=ONwill extract all translations items and locales. -
-extract.translation=OFFwill not extract all translations items and locales.
-
- -dbConnection.poolIdleTimeout=<poolIdleTimeout>
-
Sets the idle timeout in seconds for the database connection pool.
Jobs:
ALLDefault value:
300-
-dbConnection.poolIdleTimeout=0will disable the timeout.
-
Arguments
- <jobType>
- <cms>
- <user>
- <password>
- <auth>
- <configurationFolder>