Document5
Documents is composed by two reports that show:
1. for each universe (UNV kind, complete with its Id and Folderpath) the list of all webi documents linked to it, complete with its Id, Name, Container kind and Folderpath
2. for each universe (UNX kind, complete with its Id and Folderpath) the list of all webi documents linked to it, complete with its Id, Name, Container kind and Folderpath
Both reports have input controls, to filter by Universe FolderPath first and by Universe Name then.
|
|---|
Query1 (List_of_Webi_on_UNV):SELECT
int(Properties.si_id),
Properties.si_kind,
Properties.si_name,
int(Properties.si_parentid),
relationships(Properties.SI_UNIVERSE),
int(Level1.si_id),
Level1.si_kind,
Level1.si_name,
relationship(Level1.si_parent_folder),
Level2.si_name,
folderPath(Level2.si_path)
FROM
Properties,
Properties Level1,
Properties Level2
WHERE
( Properties.join=Level1.join )
AND ( Level1.join=Level2.join )
AND
(
Properties.si_kind = 'webi'
AND
flag(Properties.SI_INSTANCE) = 0
) | |
Query2 (Webi_on_UNV_Path):SELECT
int(Properties.si_id),
Properties.si_kind,
Properties.si_name,
folderPath(Properties.si_path)
FROM
Properties
WHERE
int(Properties.si_id) IN (<Id=ParentId from query List_of_Webi_on_UNV>) |
|
Query3 (List_of_Webi_on_UNX):SELECT
int(Properties.si_id),
Properties.si_kind,
Properties.si_name,
int(Properties.si_parentid),
relationships(Properties.SI_DSL_UNIVERSE),
int(Level1.si_id),
Level1.si_kind,
Level1.si_name,
relationship(Level1.si_parent_folder),
Level2.si_name,
folderPath(Level2.si_path)
FROM
Properties,
Properties Level1,
Properties Level2
WHERE
( Properties.join=Level1.join )
AND ( Level1.join=Level2.join )
AND
(
Properties.si_kind = 'webi'
AND
flag(Properties.SI_INSTANCE) = 0
) | |
Query4 (Webi_on_UNX_Path):SELECT
int(Properties.si_id),
Properties.si_kind,
Properties.si_name,
folderPath(Properties.si_path)
FROM
Properties
WHERE
int(Properties.si_id) IN (<Id=ParentId from query List_of_Webi_on_UNX>) | |
I use 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' | |
|
|---|
