Package: when 1.0.0

Jose Samos

when: Definition of Date and Time Dimension Tables

In Multidimensional Systems the When dimension allows us to express when the analysed facts have occurred. The purpose of this package is to provide support for implementing this dimension in the form of date and time tables for Relational On-Line Analytical Processing star database systems.

Authors:Jose Samos [aut, cre], Universidad de Granada [cph]

when_1.0.0.tar.gz
when_1.0.0.tar.gz(r-4.5-noble)when_1.0.0.tar.gz(r-4.4-noble)
when_1.0.0.tgz(r-4.4-emscripten)when_1.0.0.tgz(r-4.3-emscripten)
when.pdf |when.html
when/json (API)
NEWS

# Install 'when' in R:
install.packages('when', repos = c('https://cran.r-universe.dev', 'https://cloud.r-project.org'))

Peer review:

Bug tracker:https://github.com/josesamos/when/issues

Pkgdown:https://josesamos.github.io

Uses libs:
  • openjdk– OpenJDK Java runtime, using Hotspot JIT
Datasets:

openjdk

4.68 score 2 packages 161 scripts 166 downloads 25 exports 37 dependencies

Last updated 11 months agofrom:1e19734590. Checks:OK: 2. Indexed: no.

TargetResultDate
Doc / VignettesOKDec 05 2024
R-4.5-linuxOKDec 05 2024

Exports:define_characteristicsdefine_instancesgenerate_tableget_attribute_definition_functionget_day_partget_level_attribute_namesget_level_namesget_tableget_table_attribute_namesget_table_csvget_table_rdbget_table_xlsxget_week_date_rangeselect_date_levelsselect_day_levelselect_month_levelselect_quarter_levelselect_semester_levelselect_time_levelselect_week_levelselect_year_levelset_attribute_definition_functionset_day_partset_table_attribute_nameswhen

Dependencies:backportscachemclicpp11DBIdmdplyrfansifastmapgenericsgluehmsigraphlatticelifecyclelubridatemagrittrMatrixmemoisepillarpkgconfigpurrrR6rJavarlangsnakecasestringistringrtibbletidyrtidyselecttimechangeutf8vctrswithrxlsxxlsxjars

Generating the When Dimension based on date and time tables

Rendered fromwhen.Rmdusingknitr::rmarkdownon Dec 05 2024.

Last update: 2024-01-10
Started: 2024-01-10

Readme and manuals

Help Manual

Help pageTopics
Precalculated date setdate_days
Define dimension characteristicsdefine_characteristics define_characteristics.when
Define instancesdefine_instances define_instances.when
Generate tablegenerate_table generate_table.when
Get attribute definition functionget_attribute_definition_function get_attribute_definition_function.when
Get day partget_day_part get_day_part.when
Get level attribute namesget_level_attribute_names get_level_attribute_names.when
Get level namesget_level_names get_level_names.when
Get the table of the dimensionget_table get_table.when
Get table attribute namesget_table_attribute_names get_table_attribute_names.when
Store the table in a csv filesget_table_csv get_table_csv.when
Store the table in a relational databaseget_table_rdb get_table_rdb.when
Store the table in a xlsx fileget_table_xlsx get_table_xlsx.when
Get week date rangeget_week_date_range
Configure date levelsselect_date_levels select_date_levels.when
Configure day levelselect_day_level select_day_level.when
Configure month levelselect_month_level select_month_level.when
Configure quarter levelselect_quarter_level select_quarter_level.when
Configure semester levelselect_semester_level select_semester_level.when
Select time levelselect_time_level select_time_level.when
Configure week levelselect_week_level select_week_level.when
Configure year levelselect_year_level select_year_level.when
Set attribute definition functionset_attribute_definition_function set_attribute_definition_function.when
Set day partset_day_part set_day_part.when
Set table attribute namesset_table_attribute_names set_table_attribute_names.when
Time in seconds of a daytime_seconds
'when' S3 classwhen