How can I show Confluence Page Owners in a report?

Questions & Answers
1

I am trying to create a report that shows me a list of all Confluence Pages and the associated Owner of that page. I am having trouble since it appears that I am limited to who the author of the page is either at the time of the page creation or as of the most recent update to a page. Is it possible to show the owner of a page?

Report dynamic filters that I want to be available:

  • Space
  • Authors (specifically the owner)
  • Page

Attached in the screenshot is the layout I am looking for. I am able to get it to function and display the Page Author (I think its giving me the author at the time of the page creation). But I want to show the current Page Owner which can be a different person (or account) than the most recent person who updated the page or the person who created the page.

image
image815×183 16.7 KB

2

Hi @Taylor_Quinn,

The page owner field was not readily available from Confluence during data import until recently.
Therefore, it was not being imported and was not available for reports.

The data availability has changed, and we are looking into adding it to some future releases.

In the meantime, it might be possible to import additional property “page owner” for your Conflucence pages using additional REST API data source and then use MDX calculation with context change to filter Owners.

You might set up additional data import as described here - Import from REST API.
You might use the REST API endpoint from Confluence - https://developer.atlassian.com/cloud/confluence/rest/v2/api-group-page/#api-pages-get.
Set up content parameter -

$.results

content parameters
content parameters1588×438 31.9 KB

Then, you could map the Page ID as a key column to the relevant Page and import the Owner ID as a property.

daa mapping
daa mapping1942×516 37.3 KB

Please set “skip missing” for the id column to skip the pages that are not imported into the relevant data cube.

Presuming that every Owner is also an author, you might display the Owner of the page using the following expression.

CASE WHEN
  [Page].CurrentHierarchyMember.Level.Name = 'Page'
 THEN
  [Author].[User].getMemberNameByKey(
    [Page].CurrentHierarchyMember.get('<name of imported page owner property>')
  )
END

It is then possible to use the Author dimension for selecting users and then create a calculation that switches the report context and filters out pages where the selected author is the Owner, regardless of the author of the selected page. That expression might become slow if you have many pages and users, but that is the closest option available so far.

If you add the Pages dimension to report rows and use individual Author (presuming Owner) in report filters, the expression to find the number of pages where the selected user is the Owner might be as follows.

Sum(
  Filter(
    DescendantsSet(
      [Page].CurrentMember,[Page].[Page]
    ),
    Cast([Author].CurrentMember.key as string) = [Page].CurrentMember.get('<name of imported page owner property>')
  ),
  CASE WHEN
  ([Measures].[Page versions created],
   [Author].DefaultMember)>0
  THEN
   1
  END
)

This might work for a single user related to the current report cell.

Regards,
Oskars / support@eazyBI.com