Package fr.becpg.repo.olap.impl

Class OlapServiceImpl

java.lang.Object
fr.becpg.repo.olap.impl.OlapServiceImpl
All Implemented Interfaces:
OlapService
@Service("olapService") public class OlapServiceImpl extends Object implements OlapService

OlapServiceImpl class.

Version:
$Id: $Id
Author:
matthieu

  • Field Details

    • ROW_HEADER

      private static final String ROW_HEADER
      Constant ROW_HEADER="ROW_HEADER_HEADER"
      See Also:

    • LEVEL_SEPARATOR

      private static final String LEVEL_SEPARATOR
      Separates the levels of a multi-level row axis inside the single label published.
      See Also:

    • logger

      private static final org.apache.commons.logging.Log logger
      Constant logger

    • olapPublicUrl

      @Value("${becpg.olap.url.public}") private String olapPublicUrl

    • olapServerUrl

      @Value("${becpg.olap.url.internal}") private String olapServerUrl

    • enabled

      @Value("${becpg.olap.enabled}") private Boolean enabled

    • fileFolderService

      @Autowired private org.alfresco.service.cmr.model.FileFolderService fileFolderService

    • personService

      @Autowired private org.alfresco.service.cmr.security.PersonService personService

    • nodeService

      @Autowired private org.alfresco.service.cmr.repository.NodeService nodeService

    • contentService

      @Autowired private org.alfresco.service.cmr.repository.ContentService contentService

    • repoService

      @Autowired private RepoService repoService

    • beCPGTicketService

      @Autowired private BeCPGTicketService beCPGTicketService

  • Constructor Details

    • OlapServiceImpl

      public OlapServiceImpl()

  • Method Details

    • retrieveOlapCharts

      public List<OlapChart> retrieveOlapCharts()

      retrieveOlapCharts.

      Specified by:
      retrieveOlapCharts in interface OlapService
      Returns:
      a List object.

    • collectCharts

      private void collectCharts(org.alfresco.service.cmr.repository.NodeRef folder, List<OlapChart> olapCharts)
      Adds every .saiku document of a folder to the chart list.
      Parameters:
      folder - the folder to read, ignored when null
      olapCharts - the list to fill

    • getPersonalOlapQueriesFolder

      private org.alfresco.service.cmr.repository.NodeRef getPersonalOlapQueriesFolder()
      Resolves the current user's personal OLAP query folder.

      beCPG OLAP saves a user's own queries under their home folder rather than in the shared system space, so the dashlet has to read both. The folder carries the localised name of path.olapqueries; every translation is accepted, because the folder may have been created by an OLAP session running in another language than this repository's default.

      Returns:
      the folder, or null when the user has none

    • personalFolderNames

      private static List<String> personalFolderNames()
      Names the personal query folder can carry: this repository's locale first, then every other translation of path.olapqueries.
      Returns:
      the candidate folder names, never null

    • getOlapQueriesFolder

      public org.alfresco.service.cmr.repository.NodeRef getOlapQueriesFolder()

      getOlapQueriesFolder.

      Specified by:
      getOlapQueriesFolder in interface OlapService
      Returns:
      a NodeRef object.

    • retrieveOlapChartsFromSaiku

      public List<OlapChart> retrieveOlapChartsFromSaiku() throws IOException, org.json.JSONException

      retrieveOlapChartsFromSaiku.

      Specified by:
      retrieveOlapChartsFromSaiku in interface OlapService
      Returns:
      a List object.
      Throws:
      IOException - if any.
      org.json.JSONException - if any.

    • retrieveChartData

      public OlapChartData retrieveChartData(String olapQueryId) throws IOException

      retrieveChartData.

      Parse [ [{"value":"null","properties":{},"type":"COLUMN_HEADER"},{"value": "Oct","properties":{},"type":"COLUMN_HEADER"}] ,[{"value":"Type","properties":{"levelindex":"0"} ,"type":"ROW_HEADER_HEADER"} ,{"value":"Week41/2011","properties":{"levelindex" :"1","dimension":"Date de modification" },"type":"COLUMN_HEADER"}],[{"value" :"finishedProduct","properties":{"levelindex" :"0","dimension":"Type de produit" },"type":"ROW_HEADER"},{"value":"10","properties" :null,"type":"DATA_CELL"} ],[{"value":"rawMaterial","properties":{"levelindex" :"0","dimension":"Type de produit" },"type":"ROW_HEADER"},{"value":"14","properties" :null,"type":"DATA_CELL"}]]
      Specified by:
      retrieveChartData in interface OlapService
      Parameters:
      olapQueryId - a String object.
      Returns:
      a OlapChartData object.
      Throws:
      IOException - if any.

    • countRowHeaders

      private static int countRowHeaders(org.json.JSONArray headerRow) throws org.json.JSONException
      Counts the leading row-header columns of a cell set, which is how many levels the query put on rows.
      Parameters:
      headerRow - the first row of the cell set
      Returns:
      the number of row-header columns, at least one
      Throws:
      org.json.JSONException

    • joinHeaderLabels

      private static String joinHeaderLabels(org.json.JSONArray headerRow, int rowHeaders) throws org.json.JSONException
      Joins the captions of the row levels into the single column name the consumers expect.
      Parameters:
      headerRow - the first row of the cell set
      rowHeaders - how many of its columns are row headers
      Returns:
      the joined caption
      Throws:
      org.json.JSONException

    • joinRowLabels

      private String joinRowLabels(org.json.JSONArray row, int rowHeaders) throws org.json.JSONException
      Joins the row-header values of one data row into a single label.
      Parameters:
      row - a data row of the cell set
      rowHeaders - how many of its columns are row headers
      Returns:
      the joined label
      Throws:
      org.json.JSONException

    • xmlEscape

      private String xmlEscape(String input)

    • runMdxQuery

      public OlapChartData runMdxQuery(String cube, String mdxQuery) throws IOException, org.json.JSONException

      runMdxQuery.

      Specified by:
      runMdxQuery in interface OlapService
      Parameters:
      cube - the cube name.
      mdxQuery - the MDX query.
      Returns:
      a OlapChartData object.
      Throws:
      IOException - if any.
      org.json.JSONException - if any.

    • getSSOUrl

      public String getSSOUrl()

      getSSOUrl.

      Specified by:
      getSSOUrl in interface OlapService
      Returns:
      a String object.

    • getOlapChart

      private OlapChart getOlapChart(String olapQueryId)

      getOlapChart.

      Parameters:
      olapQueryId - a String object
      Returns:
      a OlapChart object

    • retrieveDataType

      private String retrieveDataType(org.json.JSONObject cell)
      The class a column's values will be published as, taken from the first data cell of that column.
      Parameters:
      cell - the first data cell under the header being described
      Returns:
      the simple class name of the converted value

    • cellValue

      private Object cellValue(org.json.JSONObject cell)
      The value of one cellset cell. A Saiku data cell carries the measure twice: value, formatted for the connection locale, and properties.raw, the number itself. Only the second one can be parsed without guessing — the displayed "1,148" is 1 148, and the same shape elsewhere in the payload is a genuine fraction. See OlapUtils.convertCell(String, String).
      Parameters:
      cell - a cellset cell
      Returns:
      the converted value

    • buildDataUrl

      private String buildDataUrl(String olapQueryId, OlapContext context) throws org.apache.commons.httpclient.URIException

      buildDataUrl.

      Parameters:
      olapQueryId - a String object
      context - a OlapContext object
      Returns:
      a String object
      Throws:
      org.apache.commons.httpclient.URIException - if any.

    • buildCreateQueryUrl

      private String buildCreateQueryUrl(String olapQueryId, OlapContext context) throws org.apache.commons.httpclient.URIException

      buildCreateQueryUrl.

      Parameters:
      olapQueryId - a String object
      context - a OlapContext object
      Returns:
      a String object
      Throws:
      org.apache.commons.httpclient.URIException - if any.

    • buildRepositoryUrl

      private String buildRepositoryUrl(OlapContext context) throws org.apache.commons.httpclient.URIException

      buildRepositoryUrl.

      Parameters:
      context - a OlapContext object
      Returns:
      a String object
      Throws:
      org.apache.commons.httpclient.URIException - if any.

    • buildQueryUrl

      private String buildQueryUrl(String queryName, OlapContext context) throws org.apache.commons.httpclient.URIException

      buildQueryUrl.

      Parameters:
      queryName - a String object
      context - a OlapContext object
      Returns:
      a String object
      Throws:
      org.apache.commons.httpclient.URIException - if any.