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

Publications_All_Info

Document4

Documents is composed by three reports that show:
1. publications list with related source documents and FolderPath
2. recurring scheduling on publications, with refers to source publications and NextRuntime date
3. scheduling instances generated by publications

 

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 (five in total) used to extract data:

Query1 (Publications):

SELECT
int(Properties.si_id),
Properties.si_cuid,
Properties.si_kind,
Properties.si_name,
relationship(Properties.si_parent_folder),
relationships(Properties.si_publication_documents)
FROM
Properties
WHERE
(
Properties.si_kind = 'publication'
AND
flag(Properties.SI_INSTANCE) = 0
)

 

Query2 (Publication_FolderPath):

SELECT
int(Properties.si_id),
Properties.si_name,
folderPath(Properties.si_path)
FROM
Properties
WHERE
int(Properties.si_id) IN (<Id=ParentFolder from query Publications>)

 

 

Query3 (PublishedDocument_Info):

SELECT
int(Properties.si_id),
Properties.si_kind,
Properties.si_name,
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 (<Id=Publication-To_Documents from query Publication>)

 

Query4 (RecurringScheduling_on_Publications):

SELECT
int(Properties.si_id),
Properties.si_cuid,
Properties.si_kind,
Properties.si_name,
relationship(Properties.si_parent_folder),
Level1.si_name,
folderPath(Level1.si_path),
int(Properties.SI_SCHEDULE_STATUS),
datetime(Properties.SI_NEXTRUNTIME),
Properties.si_owner,
int(Properties.si_parentid)
FROM
Properties,
Properties Level1
WHERE
( Properties.join=Level1.join )
AND
(
int(Properties.si_parentid) IN (<ParentId=Id from query Publications>)
AND
flag(Properties.SI_RECURRING) = 1
)

 

Query5 (Instances_on_Publications):

SELECT
int(Properties.si_id),
Properties.si_cuid,
Properties.si_kind,
Properties.si_name,
int(Properties.SI_SCHEDULE_STATUS),
flag(Properties.SI_RECURRING),
datetime(Properties.si_starttime),
datetime(Properties.si_endtime),
relationship(Properties.si_parent_folder),
Level1.si_name,
folderPath(Level1.si_path),
int(Properties.si_parentid)
FROM
Properties,
Properties Level1
WHERE
( Properties.join=Level1.join )
AND
(
flag(Properties.SI_INSTANCE) = 1
AND
flag(Properties.SI_RECURRING) = 0
AND
int(Properties.si_parentid) IN (<ParentId=Id from query Publications>)
)

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_20171130.zip

Guide to construct the document: Publications_All_Info.docx

  • No labels