when

Definition of Date and Time Dimension Tables

v1.0.0 · Jan 9, 2024 · MIT + file LICENSE

Description

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.

Downloads

169

Last 30 days

19768th

169

Last 90 days

169

Last year

CRAN Check Status

1 ERROR

10 NOTE

3 OK

Show all 14 flavors

Flavor	Status	Time
r-devel-linux-x86_64-debian-clang	ERROR	4.6s
r-devel-linux-x86_64-debian-gcc	NOTE	63.6s
r-devel-linux-x86_64-fedora-clang	NOTE	123.2s
r-devel-linux-x86_64-fedora-gcc	NOTE	149.5s
r-devel-macos-arm64	NOTE	26s
r-devel-windows-x86_64	NOTE	118s
r-oldrel-macos-arm64	OK
r-oldrel-macos-x86_64	OK	67s
r-oldrel-windows-x86_64	OK	143s
r-patched-linux-x86_64	NOTE	82.3s
r-release-linux-x86_64	NOTE	80.8s
r-release-macos-arm64	NOTE
r-release-macos-x86_64	NOTE	81s
r-release-windows-x86_64	NOTE	116s

Check details (14 non-OK)

ERROR r-devel-linux-x86_64-debian-clang

package dependencies

Package required but not available: ‘xlsx’

See section ‘The DESCRIPTION file’ in the ‘Writing R Extensions’
manual.

NOTE r-devel-linux-x86_64-debian-gcc

DESCRIPTION meta-information

  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’

NOTE r-devel-linux-x86_64-fedora-clang

DESCRIPTION meta-information

  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’

NOTE r-devel-linux-x86_64-fedora-gcc

DESCRIPTION meta-information

  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’

NOTE r-devel-macos-arm64

DESCRIPTION meta-information

  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’

NOTE r-devel-windows-x86_64

DESCRIPTION meta-information

  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'

OK r-oldrel-macos-arm64

OK r-oldrel-macos-x86_64

OK r-oldrel-windows-x86_64

NOTE r-patched-linux-x86_64

DESCRIPTION meta-information

  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’

NOTE r-release-linux-x86_64

DESCRIPTION meta-information

  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’

NOTE r-release-macos-arm64

DESCRIPTION meta-information

  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’

NOTE r-release-macos-x86_64

DESCRIPTION meta-information

  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’

NOTE r-release-windows-x86_64

DESCRIPTION meta-information

  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'

Check History

ERROR 3 OK · 10 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE Mar 9, 2026

ERROR r-devel-linux-x86_64-debian-clang

package dependencies

Package required but not available: ‘xlsx’

See section ‘The DESCRIPTION file’ in the ‘Writing R Extensions’
manual.

NOTE r-devel-linux-x86_64-debian-gcc

DESCRIPTION meta-information

  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’

NOTE r-devel-linux-x86_64-fedora-clang

DESCRIPTION meta-information

  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’

NOTE r-devel-linux-x86_64-fedora-gcc

DESCRIPTION meta-information

  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’

NOTE r-devel-macos-arm64

DESCRIPTION meta-information

  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’

NOTE r-devel-windows-x86_64

DESCRIPTION meta-information

  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'

NOTE r-patched-linux-x86_64

DESCRIPTION meta-information

  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’

NOTE r-release-linux-x86_64

DESCRIPTION meta-information

  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’

NOTE r-release-macos-arm64

DESCRIPTION meta-information

  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’

NOTE r-release-macos-x86_64

DESCRIPTION meta-information

  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’

NOTE r-release-windows-x86_64

DESCRIPTION meta-information

  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'

Reverse Dependencies (1)

imports

rolap

Dependency Network

Version History

new 1.0.0 Mar 9, 2026

Maintainer

Jose Samos

Dependencies

Depends

R (>= 2.10)

Imports

DBI dm dplyr hms lubridate rlang snakecase tibble utils xlsx

Suggests

dbplyr DiagrammeR DiagrammeRsvg knitr pander rmarkdown RSQLite testthat (>= 3.0.0)

Compilation

No compilation needed

First Published

Mar 9, 2026

RSS Feed

CRAN Checks

View on CRAN →