Anonymous, bureaucrat, administrator
7,528
edits
Changes
From All n One's bxp software Wixi
no edit summary
'''Unique data records''', or '''unique records''', is the terminology for reducing the output list to only showing a unique CDA once in a report despite having multiple matching CCLs.
The CDA details shown will always be the most recent information.
== Period Selection ==
Choosing dates and times for reports is a key element of the reports and bxpsupplies a handy assortment of '''date-time keywords''' to save on date and time selection.
Clicking the key words of the date time selector ensures that the times of reports are selected correctly. Selectable dates default to 00:00:00 because most reports are set to a day or week period.
It is easy to change the dates and times by clicking the date / time selector icon to the right of the appropriate box. NOTE: The date time can be cleared with the red X to the right of that.
[[File:dataprofiling_descriptions_001.png]]
Where appropriate the reporting time can default to the current date and time. This requires the user generating the report to be vigilant about the time period requested.
NOTE: bxp will always ''include'' the start date and time in the report but ''exclude'' the end date and time. For example, if 2014-01-07 00:00:00 had been chosen as the end time, 23:59:59 would be included, but 2014-01-07 00:00:00 would not.
== Volume of Data and Integrated Warehousing ==
When a report is run, a lock is placed on the CDA and CCL. This allows reports and look ups to be performed on the data, but stops data being added to the tables.
For this reason, when big reports are run using Report by Data by Outcome, the tables can become locked which tends to be counterproductive during an operational day.
When a campaign exceeds 20,000 records, a feature called Integrated Warehousing (IW) is applied to the campaign CDA and CCL tables. The structure becomes: [[File:Dataprofiling_descriptions_002.png]]
Any report generated from the Data Profiling module will check for the existence of the IW versions. If IW exists the report will be performed on the _Report versions of the table, if not it will be performed on the CDA and CCL tables as normal.
As part of using reports in Integrated Warehousing, there is an automated update feature which copies the delta of the records from CDA and CLL to the CDA_Report and CCL_Report tables. This creates a lock to allow the copying to complete. This '''IW Lock''' is used to keep records from duplicate copies occurring.
It can also occur that two users try to generate large reports at the same time. The IW lock also locks up the _Report tables until the first user report is finished.
== Closed Vs. Open Questions ==
A '''closed question''' means data entered is from a preselected list such a drop down list or set of radio buttons. These closed question types are easily counted and reports and graphics are readily applied to them.
'''Open questions''' allow the user to enter any data they like into the box on screen but they will need to be individually graded by a tutor.
== Reporting Perspectives ==
Reports in bxp are usually titled from the perspective of the reports that will be generated
* '''My''' reports will limit the returned data to that for the current user.
* '''My Department''' reports will limit returned data to the department the current user is a member of.
* '''My Team''' reports will include all teams that the user is a member of.
* '''Customised''' means that only those records matching specified parameters are returned.
* '''All''' reports will include all information, but with limitations such as time used as a safeguard against the generation of enormous reports.
NOTE: The Data Profiling module reports will always be from the ''All'' perspective.
= Jump offs =
