Business Intelligence (BusinessObjects)
Page tree
Skip to end of metadata
Go to start of metadata

Scheduling_List

Document3

Report extracts all scheduling (recurring or not) setted on every object.

It shows:
1. Kind, Id, Name of Scheduling Instance/Recurring
2. Id, Kind, Name, FolderPath of Scheduled Object
3. Next Runtime, Start/End Time, Duration Time, Owner, Status of Scheduling Istance/Recurring.
There is an input control to filter by Scheduled Object FolderPath.

Added Custom Linked Universe

In attached biar there is a custom universe linked to original "BI platform CMS system database.unx" in order to create other infoobject's properties , under "MyInfoObjects" dimension folder (as suggested by Thomas Jentsch in "Split development using linked universe" page at https://wiki.scn.sap.com/wiki/x/HJDZGg )

Below screenshots of every query (two in total) used to extract data:

Query1 (Scheduling_List):

SELECT
int(Properties.si_id),
flag(Properties.SI_RECURRING),
Properties.si_name,
Properties.si_kind,
int(Properties.si_scheduleinfo.SI_SCHEDULE_TYPE),
int(Properties.SI_SCHEDULE_STATUS),
datetime(Properties.SI_NEXTRUNTIME),
Properties.si_owner,
int(Properties.si_parentid),
datetime(Properties.si_starttime),
datetime(Properties.si_endtime)
FROM
Properties
WHERE
flag(Properties.SI_INSTANCE) = 1

Query2 (Scheduled_objects_list):

SELECT
int(Properties.si_id),
Properties.si_name,
Properties.si_kind,
relationship(Properties.si_parent_folder),
folderPath(Level1.si_path),
Level1.si_name
FROM
Properties,
Properties Level1
WHERE
( Properties.join=Level1.join )
AND
int(Properties.si_id) IN (<ParentId from query Scheduling_List >)

I use the first query "Environment" in each webi document to obtain the name of the CMS environment I'm exploring :

SELECT
Properties.si_name
FROM
Properties
WHERE
Properties.si_kind = 'EnterpriseNode'

Document biar: Biar_20171128.zip

Guide to construct the document: Scheduling_List.docx

  • No labels