Details

    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: Milestone 1.2, WebSynergy Plugin, Liferay plugin, Milestone 1.1, Further Updates, Demo for JavaOne, CEQ Documentation , Sunspace
    • Fix Version/s: Milestone 1.4
    • Component/s: CeQ math
    • Labels:
      None

      Description

      *1. calculate dally,weekly,monthly equity statistics per info, per person and per tag during aging process and store it data in cache tables.
      2. Provide function which can create statistics and caches from scratch based on the CeQ activity log.
      3. Provide webservice API to access statistical data (more details will be provided by PRE/MAX)
      4. Implement access control (need to define details)

      Services API is on http://wikis.sun.com/display/ceqdoc/Statistics+Service

        Activity

        Hide
        PRE added a comment -

        Dima - How do I know that the statistics was calculated ? I looked at the statistics-* db tables and they are all empy

        Show
        PRE added a comment - Dima - How do I know that the statistics was calculated ? I looked at the statistics-* db tables and they are all empy
        Hide
        DmitryRyashchentsev added a comment -

        Now statistics-* table is the only way to test.
        But statistics is calculated only for past days (till yesterday)

        Show
        DmitryRyashchentsev added a comment - Now statistics-* table is the only way to test. But statistics is calculated only for past days (till yesterday)
        Hide
        PRE added a comment - - edited

        hmm - what if we import a feed which has activities which are a few month old ? Actually this is what I am doing right know e.g. importing SunSpace ATOM feed for the last few month. Mayb we need a parameter to define the aging start date

        see http://kenai.com/jira/browse/COMMUNITY_EQUITY-488

        Show
        PRE added a comment - - edited hmm - what if we import a feed which has activities which are a few month old ? Actually this is what I am doing right know e.g. importing SunSpace ATOM feed for the last few month. Mayb we need a parameter to define the aging start date see http://kenai.com/jira/browse/COMMUNITY_EQUITY-488
        Hide
        DmitryRyashchentsev added a comment - - edited

        That should work for activity older then a day.
        Can you please write me the feed URL and other parameters.

        Try http://mb.sunsolutioncenter.de/index.php/activitystream?days=50&pagesize=5000
        Site feed = checked
        Application=SunWiki
        Feed Type = activitystream

        You can change days and pagesize

        Show
        DmitryRyashchentsev added a comment - - edited That should work for activity older then a day. Can you please write me the feed URL and other parameters. Try http://mb.sunsolutioncenter.de/index.php/activitystream?days=50&pagesize=5000 Site feed = checked Application=SunWiki Feed Type = activitystream You can change days and pagesize
        Hide
        DmitryRyashchentsev added a comment -

        The problem was the first statistics calculation did for previous day only (the following statistics starts from date of last calculated one).
        In this feed there were no activity for May,6.

        I changed behaviour, now the first statistics is calculated for the whole period till previous day.
        I did not risk to do it initially because it can take much time: for example above I got statistics for 169 days - that took ~9mins (3 secs per day).

        Now the progress of statistics calculation can be observed only in the server.log, the aging?type=2 only starts the process.

        Show
        DmitryRyashchentsev added a comment - The problem was the first statistics calculation did for previous day only (the following statistics starts from date of last calculated one). In this feed there were no activity for May,6. I changed behaviour, now the first statistics is calculated for the whole period till previous day. I did not risk to do it initially because it can take much time: for example above I got statistics for 169 days - that took ~9mins (3 secs per day). Now the progress of statistics calculation can be observed only in the server.log, the aging?type=2 only starts the process.

          People

          • Assignee:
            DmitryRyashchentsev
            Reporter:
            PRE
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: