Skip to content

Definition of Date and Time Dimension Tables

1packages depend
2.4Kdownloads / year
87.9%test coverage
0/13flavors OK

Overview

About

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.

Changes in 1.0.0
  • Initial CRAN submission.

From NEWS.md in the release

Install

Health

CRAN checks
13NOTE
Check messages
NOTEDESCRIPTION meta-informationr-devel-linux-x86_64-debian-clang, r-devel-linux-x86_64-debian-gcc, r-devel-linux-x86_64-fedora-clang, r-devel-linux-x86_64-fedora-gcc, r-devel-windows-x86_64, r-oldrel-macos-arm64, r-oldrel-macos-x86_64, r-oldrel-windows-x86_64, r-patched-linux-x86_64, r-release-linux-x86_64, r-release-macos-arm64, r-release-macos-x86_64, r-release-windows-x86_64

r-devel-linux-x86_64-debian-clang, r-devel-linux-x86_64-debian-gcc, r-devel-linux-x86_64-fedora-clang, r-devel-linux-x86_64-fedora-gcc, r-oldrel-macos-arm64, r-patched-linux-x86_64, r-release-linux-x86_64, r-release-macos-arm64, r-release-macos-x86_64

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    ‘define_characteristics.Rd’ ‘define_instances.Rd’ ‘export.R’
    ‘generate_table.Rd’ ‘get_attribute_definition_function.Rd’
    ‘get_day_part.Rd’ ‘get_level_attribute_names.Rd’ ‘get_level_names.Rd’
    ‘get_table.Rd’ ‘get_table_attribute_names.Rd’ ‘get_table_csv.Rd’
    ‘get_table_rdb.Rd’ ‘get_table_xlsx.Rd’ ‘select_date_levels.Rd’
    ‘select_day_level.Rd’ ‘select_month_level.Rd’
    ‘select_quarter_level.Rd’ ‘select_semester_level.Rd’
    ‘select_time_level.Rd’ ‘select_week_level.Rd’ ‘select_year_level.Rd’
    ‘set_attribute_definition_function.Rd’ ‘set_day_part.Rd’
    ‘set_table_attribute_names.Rd’ ‘week.R’

r-devel-windows-x86_64, r-oldrel-windows-x86_64, r-release-windows-x86_64

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    'define_characteristics.Rd' 'define_instances.Rd' 'export.R'
    'generate_table.Rd' 'get_attribute_definition_function.Rd'
    'get_day_part.Rd' 'get_level_attribute_names.Rd' 'get_level_names.Rd'
    'get_table.Rd' 'get_table_attribute_names.Rd' 'get_table_csv.Rd'
    'get_table_rdb.Rd' 'get_table_xlsx.Rd' 'select_date_levels.Rd'
    'select_day_level.Rd' 'select_month_level.Rd'
    'select_quarter_level.Rd' 'select_semester_level.Rd'
    'select_time_level.Rd' 'select_week_level.Rd' 'select_year_level.Rd'
    'set_attribute_definition_function.Rd' 'set_day_part.Rd'
    'set_table_attribute_names.Rd' 'week.R'

r-oldrel-macos-x86_64

Missing dependency on R >= 4.1.0 because package code uses the pipe
  |> or function shorthand \(...) syntax added in R 4.1.0.
  File(s) using such syntax:
    ‘export.R’ ‘week.R’

CRAN check page ↗

Slowest check: 2.4 min · r-oldrel-windows-x86_64
Status changes
  • NOTE13 NOTE2026-06-09
  • ERROR12 NOTE, 1 ERROR2026-06-08
  • NOTE3 OK, 11 NOTE2026-04-06
  • ERROR3 OK, 10 NOTE, 1 ERROR2026-04-04
  • NOTE3 OK, 11 NOTE2026-03-10
Advisories

none known

Documentation

In release 1.0.0
READMEYes · 788 wordsVignettesYes · 1 · dynamicNEWSYes · 67% structured · mentions 1.0.0Citation fileNoWebsiteYes · pkgdown
Help pages
65 (38 internal)
Examples that run
96%24 run in a plain check · 1 only when donttest examples are enabled (R CMD check --as-cran)
Exported functions with examples
100%
Documented parameters
100%
Return-value docs
100%
Help pages citing references
0%

Downloads

2.4K
CRAN downloads in the past year
Rank #18,460 · ~7/day · ~203/mo
Daily download trend is not available in this view yet.
28930 days
69890 days
2.4K1 year
Compare downloads with other packages →
Also on72 r2u4 autocran

Repository

1Stars
0Forks
0Open issues
0Open PRs
1Releases
72Commits
1Commit identities
72 commits · Last activity 2024-01-09 · Default branch at 1.0.0.9000, ahead of CRAN 1.0.0 (checked 2026-10-11)
Responsiveness
How these are sampled
PRs merged (all time)
100%
Median days to close, 50 most recently updated closed issues
9
Median days to close, 50 most recently updated closed PRs
0

Stars over time

2024-08-06 · 12026-07-07 · 1
PracticesBeta

9 development-tooling and community-health practices detected across 5 families in the upstream repository

Checks run against github.com/josesamos/when on 2026-10-11.

Continuous integration (2)
GitHub ActionsR CMD check workflow

The R CMD check workflow runs on Linux, macOS and Windows, and on R-devel

Docs source (4)
README.Rmdpkgdown

GitHub Pages site last deployed 2024-01-09 · The repository has a site deploy workflow

pkgdown site last built 2024-01-09

Coverage (1)
Coverage reporting (Codecov)
CRAN release process (1)
cran-comments.md
Show all practicesHide 1 practice
Lint, format, editor (1)
RStudio project
How this is detected·Detection ruleset v3 (2026-09-26)

Dependencies

Declared dependencies
17 external dependencies (excludes base and recommended)

Installing when adds 33 packages (18 with compiled code, 33 MB of source tarballs). Heaviest: stringi 11 MB, xlsxjars 9.8 MB, dm 2.7 MB.

Depends (1)
R >= 2.10
LinkingTo (0)
none
Enhances (0)
none
Reverse dependencies
1direct
1indirect
Imports 1
Depends, Imports or LinkingTo, most downloaded first

Datasets

People & History

People (2)
Author, Maintainer since 1.0.0 (2024)
Copyright holder
Releases (1)
  • R
    R 4.6.0 released · 2026-04-24
  • R
    R 4.5.0 released · 2025-04-11
  • R
    R 4.4.0 released · 2024-04-24
  • 1.0.0Latest
    2024-01-09 · current release
  • R
    R 4.3.0 released · 2023-04-21

Package metadata

First published
2024-01-09
Total releases
1 / 2 yrs
License
MIT + file LICENSE OSI
Minimum R
≥ 2.10
Bundled data
246 KB / 2 files
Download size
272 KB

Cite

Cite this package

Run in R for the authors' preferred citation:

citation("when")
Samos, J., & Universidad de Granada. (2024). when: Definition of Date and Time Dimension Tables (Version 1.0.0) [Computer software]. https://doi.org/10.32614/CRAN.package.when

This package has no citation file, so citation() returns this entry built from DESCRIPTION.

Cite the R Observatory

For a number measured here: a download total, a coverage figure, an archival date.

APA

Balamuta, J. J. (2026). R Observatory: Metrics for when version 1.0.0 [Data set]. HJJB, LLC. Data release v2026-10-19. https://doi.org/10.5281/zenodo.21843040

From data release v2026-10-19, which the citation names so these numbers can be found later. More on citing and the projects behind them.

Report a problem with this page →

Privacy choices

These apply to this browser and are stored on this device only. Nothing about your choice is sent to us.

Read the privacy policy