Accéder au contenu principal

Oracle WebCenter Spaces Governance

 

Oracle WebCenter Space allows creation of Collaboratives areas. As it’s very easy to create a WorkSpace, it’s common to observe a workspace proliferation. So, it can be useful to check  the activity inside each of Spacers, and decide if it has to be archived depending the audience.

This post explains how to setup a very simple diagram which provides, inside WebCenter Space, an overall activity statistics for a given Workspace.The idea relies on the fact that activity is recorded in database Table.

Prerequisites

  • Oracle WebCenter Spaces is already installed
  • The schema which contains Spaces metadata is : DEV_WEBCENTER (or an other name) and the password must be known.

Steps

  • Create the following objects in DEV_WEBCENTER schema, with sqlplus or a similar tool

create type ext_array as table of number;

create function
  ext_gen_numbers(n in number default null)
  return ext_array
  PIPELINED
  as
  begin
     for i in 1 .. nvl(n,999999999)
     loop
         pipe row(i);
     end loop;
     return;
  end;

  • Create a diagramm with omniportlet tool (it’s a generic portlet which allows to create diagrams or lists based on SQL statements, XML, etc)

Along the wizzard, choose a SQL source, then enter the following statement:

select to_char(B.ti,'Month YY') month, nvl(A.nb,0) nb from (
select trunc(activity_time,'MONTH') ti, count(*) nb
from WC_SPACE_HEADER S,
WC_AS_ACTIVITY_ELEMENT A
where S.DISPLAY_NAME='ODrink'
group by trunc(activity_time,'MONTH')
) A,
(
select add_months(trunc(sysdate,'MONTH'),-column_value+1) ti
  from TABLE(ext_gen_numbers(12))
) B
where A.ti(+) = B.ti
order by B.ti

In the Layout tab, choose Line displaying:

image

After validating, this is the result which can be easily obtained:

image

 

By instancing the omniportlet multiple time, one can setup a complet dashboard: The following SQL provides Page activity for all the spaces (only three in our sample, but it’s just a demo):

select display_name, count(*) nb
from WC_SPACE_HEADER S,
WC_AS_ACTIVITY_ELEMENT A
where A.SCOPE_ID = S.SPACE_GUID and
service_id like 'oracle.webcenter.page%'
group by display_name, service_id

image

 

Version: 1.1 19-Aug-2010

Commentaires

Enregistrer un commentaire

Posts les plus consultés de ce blog

Oracle Documents Cloud Service - Using Upload File REST API

If the Upload File sample given in ODCS documentation is used "as is", we get a http 400 error. The syntax is strict and every blank line must be empty (no space character for instance). If we cust and paste the sample, there are residual space characters which must be removed. So, use this pattern instead: -----1234567890 Content-Disposition: form-data; name="jsonInputParameters" { "parentID": " " } -----1234567890 Content-Disposition: form-data; name="primaryFile"; filename="example.txt" Content-Type: text/plain Hello World! -----1234567890-- instead the original one: -----1234567890 Content-Disposition: form-data; name="jsonInputParameters" { "parentID":"FB4CD874EF94CD2CC1B60B72T0000000000100000001" } -----1234567890 Content-Disposition: form-data; name="primaryFile"; filename="example.txt" Content-Type: text/plain -----1234567890-- Tests can be...
3 commentaires
Lire la suite

Oracle Sites Cloud Service - Apps

It's possible to add kinds of widgets (named APPS) inside any page of a site built with Oracle Sites Cloud Service (SCS). Any app is materialized by two URL: a Renderer Url which will render any HTML fragment inside an iframe tag at runtime a settings url which will be rendrered at design time in the settings menu. all URLs must be called through https (meaning that the called server has to be ssl enabled) In the following samples, we integrate: a dummy app (a simple html page produced with node.js) which demonstrates the parameteres caried by the Sites Cloud engine when calling the backend server,  a regular Apex report or form,  a custom report which calls a rest api generated by Apex /ORDS Sample node.js server.js below is a sample of parameter values get from a dummy node.js server Main call id=26e45e21-dbb6-4877-9886-482b37213d2f instance=eyJpbnN0YW5jZWlkIjoiQTI0NUNFNUNFNjA5MjE1REZBRTA2RTQyRjExOThBNThFNzc4RDc5NzFDMkIiLCJzaWduZGF0ZSI6IjE0NTAxMDg1M...
Enregistrer un commentaire
Lire la suite

Configuring Oracle Cloud as the Service Provider with SimpleSAMLphp as IDP

In order to establish SSO between enteprise backend and Oracle Public Cloud, it's possible to use SimpleSAMLphp (Federation tool) as an in-house Identity Provider , and setup Oracle Cloud as the Service Povider . Cf official documentation Managing Single Sign-On about the concept. SSO relies on SAML 2.0 standard. Tasks At the Identity Server (IDP) level Install Apache and PHP 5.3 + Install SimpleSAMLphp Just Follow documentation and  yum install php53-mcrypt   instead php-mcrypt if linux complains about it. Test with a simple SP provided with SimplePHPphp. Don't forget to un-comment the  example-userpass ! Export the metadata in a XML file At the Cloud Service level Import the previous metadata file Accept default values and don't change anything. At the IDP server level:  Follow documentation Servive Provider Quickstart Update the config/authsources.php with infos provided in the parameter pages (entity Id) EntityID value must be the sam...
Enregistrer un commentaire
Lire la suite