{ "_id": "6a2680e7794753ddbc3f0d41", "Type": "Package", "Package": "when", "Title": "Definition of Date and Time Dimension Tables", "Version": "1.0.0.9000", "Authors@R": "c(\nperson(\"Jose\", \"Samos\", , \"jsamos@ugr.es\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-4457-3439\")),\nperson(\"Universidad de Granada\", role = \"cph\")\n)", "Description": "In Multidimensional Systems the When dimension allows us\nto express when the analysed facts have occurred. The purpose\nof this package is to provide support for implementing this\ndimension in the form of date and time tables for Relational\nOn-Line Analytical Processing star database systems.", "License": "MIT + file LICENSE", "URL": "https://josesamos.github.io/when/,\nhttps://github.com/josesamos/when", "BugReports": "https://github.com/josesamos/when/issues", "VignetteBuilder": "knitr", "Config/testthat/edition": "3", "Encoding": "UTF-8", "Language": "en-GB", "LazyData": "true", "Roxygen": "list(markdown = TRUE)", "RoxygenNote": "7.2.3", "Config/pak/sysreqs": "make default-jdk libicu-dev", "Repository": "https://josesamos.r-universe.dev", "Date/Publication": "2024-01-09 08:42:22 UTC", "RemoteUrl": "https://github.com/josesamos/when", "RemoteRef": "HEAD", "RemoteSha": "41aa1bc251149cf5570d3966fb5962bded0d6414", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-08 08:40:44 UTC", "User": "root" }, "Author": "Jose Samos [aut, cre] (ORCID: ),\nUniversidad de Granada [cph]", "Maintainer": "Jose Samos ", "MD5sum": "c112b1a0d070c06193a30acd548b0e71", "_user": "josesamos", "_type": "src", "_file": "when_1.0.0.9000.tar.gz", "_fileid": "de6c672efcad2a7452677575c58ff2d9121fe043586b93a6621101d255782834", "_filesize": 433352, "_sha256": "de6c672efcad2a7452677575c58ff2d9121fe043586b93a6621101d255782834", "_created": "2026-06-08T08:40:44.000Z", "_published": "2026-06-08T08:44:23.628Z", "_distro": "noble", "_jobs": [ { "job": 80054482002, "time": 174, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7475343424" }, { "job": 80054481999, "time": 164, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7475339672" }, { "job": 80054481863, "time": 107, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7475319882" }, { "job": 80054481859, "time": 113, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7475321834" }, { "job": 80053924799, "time": 195, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7475279968" }, { "job": 80054481987, "time": 141, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7475331870" }, { "job": 80054481858, "time": 158, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7475337634" }, { "job": 80054481802, "time": 123, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7475324983" }, { "job": 80054481798, "time": 174, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7475343475" } ], "_buildurl": "https://github.com/r-universe/josesamos/actions/runs/27125774560", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/josesamos/when", "_commit": { "id": "41aa1bc251149cf5570d3966fb5962bded0d6414", "author": "josesamos ", "committer": "josesamos ", "message": "readme\n", "time": 1704789742 }, "_maintainer": { "name": "Jose Samos", "email": "jsamos@ugr.es", "login": "josesamos", "description": "R / GIS / Geocomputation / DW / OLAP / Multidimensional Systems", "uuid": 13182483, "orcid": "0000-0002-4457-3439" }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "DBI", "role": "Imports" }, { "package": "dm", "role": "Imports" }, { "package": "dplyr", "role": "Imports" }, { "package": "hms", "role": "Imports" }, { "package": "lubridate", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "snakecase", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "xlsx", "role": "Imports" }, { "package": "dbplyr", "role": "Suggests" }, { "package": "DiagrammeR", "role": "Suggests" }, { "package": "DiagrammeRsvg", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "pander", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" } ], "_owner": "josesamos", "_selfowned": true, "_usedby": 2, "_updates": [], "_tags": [], "_stars": 1, "_contributors": [ { "user": "josesamos", "count": 72, "uuid": 13182483 } ], "_userbio": { "uuid": 13182483, "type": "user", "name": "JOSE SAMOS JIMENEZ", "description": "R / GIS / Geocomputation / DW / OLAP / Multidimensional Systems" }, "_downloads": { "count": 162, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/when" }, "_devurl": "https://github.com/josesamos/when", "_pkgdown": "https://josesamos.github.io/when/", "_searchresults": 285, "_topics": [ "openjdk" ], "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "extra/when.html", "manual.pdf" ], "_homeurl": "https://github.com/josesamos/when", "_realowner": "josesamos", "_cranurl": true, "_releases": [ { "version": "1.0.0", "date": "2024-01-09" } ], "_exports": [ "define_characteristics", "define_instances", "generate_table", "get_attribute_definition_function", "get_day_part", "get_level_attribute_names", "get_level_names", "get_table", "get_table_attribute_names", "get_table_csv", "get_table_rdb", "get_table_xlsx", "get_week_date_range", "select_date_levels", "select_day_level", "select_month_level", "select_quarter_level", "select_semester_level", "select_time_level", "select_week_level", "select_year_level", "set_attribute_definition_function", "set_day_part", "set_table_attribute_names", "when" ], "_datasets": [ { "name": "date_days", "title": "Precalculated date set", "object": "date_days", "class": [ "character" ], "fields": [], "table": false, "tojson": true }, { "name": "time_seconds", "title": "Time in seconds of a day", "object": "time_seconds", "class": [ "character" ], "fields": [], "table": false, "tojson": true } ], "_help": [ { "page": "date_days", "title": "Precalculated date set", "concept": [ "time definition" ], "topics": [ "date_days" ] }, { "page": "define_characteristics", "title": "Define dimension characteristics", "concept": [ "dimension definition" ], "topics": [ "define_characteristics", "define_characteristics.when" ] }, { "page": "define_instances", "title": "Define instances", "concept": [ "dimension definition" ], "topics": [ "define_instances", "define_instances.when" ] }, { "page": "generate_table", "title": "Generate table", "concept": [ "obtaining results" ], "topics": [ "generate_table", "generate_table.when" ] }, { "page": "get_attribute_definition_function", "title": "Get attribute definition function", "concept": [ "dimension definition" ], "topics": [ "get_attribute_definition_function", "get_attribute_definition_function.when" ] }, { "page": "get_day_part", "title": "Get day part", "concept": [ "dimension definition" ], "topics": [ "get_day_part", "get_day_part.when" ] }, { "page": "get_level_attribute_names", "title": "Get level attribute names", "concept": [ "obtaining results" ], "topics": [ "get_level_attribute_names", "get_level_attribute_names.when" ] }, { "page": "get_level_names", "title": "Get level names", "concept": [ "obtaining results" ], "topics": [ "get_level_names", "get_level_names.when" ] }, { "page": "get_table", "title": "Get the table of the dimension", "concept": [ "getting results" ], "topics": [ "get_table", "get_table.when" ] }, { "page": "get_table_attribute_names", "title": "Get table attribute names", "concept": [ "obtaining results" ], "topics": [ "get_table_attribute_names", "get_table_attribute_names.when" ] }, { "page": "get_table_csv", "title": "Store the table in a csv files", "concept": [ "getting results" ], "topics": [ "get_table_csv", "get_table_csv.when" ] }, { "page": "get_table_rdb", "title": "Store the table in a relational database", "concept": [ "getting results" ], "topics": [ "get_table_rdb", "get_table_rdb.when" ] }, { "page": "get_table_xlsx", "title": "Store the table in a xlsx file", "concept": [ "getting results" ], "topics": [ "get_table_xlsx", "get_table_xlsx.when" ] }, { "page": "get_week_date_range", "title": "Get week date range", "concept": [ "dimension definition" ], "topics": [ "get_week_date_range" ] }, { "page": "select_date_levels", "title": "Configure date levels", "concept": [ "dimension definition" ], "topics": [ "select_date_levels", "select_date_levels.when" ] }, { "page": "select_day_level", "title": "Configure day level", "concept": [ "dimension definition" ], "topics": [ "select_day_level", "select_day_level.when" ] }, { "page": "select_month_level", "title": "Configure month level", "concept": [ "dimension definition" ], "topics": [ "select_month_level", "select_month_level.when" ] }, { "page": "select_quarter_level", "title": "Configure quarter level", "concept": [ "dimension definition" ], "topics": [ "select_quarter_level", "select_quarter_level.when" ] }, { "page": "select_semester_level", "title": "Configure semester level", "concept": [ "dimension definition" ], "topics": [ "select_semester_level", "select_semester_level.when" ] }, { "page": "select_time_level", "title": "Select time level", "concept": [ "dimension definition" ], "topics": [ "select_time_level", "select_time_level.when" ] }, { "page": "select_week_level", "title": "Configure week level", "concept": [ "dimension definition" ], "topics": [ "select_week_level", "select_week_level.when" ] }, { "page": "select_year_level", "title": "Configure year level", "concept": [ "dimension definition" ], "topics": [ "select_year_level", "select_year_level.when" ] }, { "page": "set_attribute_definition_function", "title": "Set attribute definition function", "concept": [ "dimension definition" ], "topics": [ "set_attribute_definition_function", "set_attribute_definition_function.when" ] }, { "page": "set_day_part", "title": "Set day part", "concept": [ "dimension definition" ], "topics": [ "set_day_part", "set_day_part.when" ] }, { "page": "set_table_attribute_names", "title": "Set table attribute names", "concept": [ "obtaining results" ], "topics": [ "set_table_attribute_names", "set_table_attribute_names.when" ] }, { "page": "time_seconds", "title": "Time in seconds of a day", "concept": [ "time definition" ], "topics": [ "time_seconds" ] }, { "page": "when", "title": "'when' S3 class", "concept": [ "dimension definition" ], "topics": [ "when" ] } ], "_pkglogo": "https://github.com/josesamos/when/raw/HEAD/man/figures/logo.png", "_readme": "https://github.com/josesamos/when/raw/HEAD/README.md", "_rundeps": [ "backports", "cachem", "cli", "cpp11", "DBI", "dm", "dplyr", "fastmap", "generics", "glue", "hms", "lifecycle", "lubridate", "magrittr", "memoise", "pillar", "pkgconfig", "purrr", "R6", "rJava", "rlang", "snakecase", "stringi", "stringr", "tibble", "tidyr", "tidyselect", "timechange", "utf8", "vctrs", "withr", "xlsx", "xlsxjars" ], "_sysdeps": [ { "shlib": "libjvm", "package": "openjdk-21-jre-headless", "headers": "openjdk-21-jre-headless", "source": "openjdk", "version": "21.0.11+10-1~24.04.2", "name": "openjdk", "homepage": "https://openjdk.java.net/", "description": "OpenJDK Java runtime, using Hotspot JIT (headless)" } ], "_vignettes": [ { "source": "when.Rmd", "filename": "when.html", "title": "Generating the When Dimension based on date and time tables", "engine": "knitr::rmarkdown", "headings": [ "Introduction", "Definition process", "Creating an object", "Definition of general aspects", "Definition of instances", "Selection of levels and attributes", "Generation of the result", "Getting the dimension table", "Other configuration options", "Dimension table features", "Table name", "Surrogate key", "Renaming the attributes", "Names of the parts of the day", "Configuration of day and week levels", "The first day of the week", "Numbering of weeks in the year", "Get date range of weeks", "Change the definition function of an attribute", "Conclusions", "Bibliography" ], "created": "2023-12-23 09:39:14", "modified": "2024-01-02 11:17:12", "commits": 32 } ], "_score": 5.931966114728173, "_indexed": true, "_nocasepkg": "when", "_universes": [ "josesamos" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.0.0.9000", "date": "2026-06-08T08:43:29.000Z", "distro": "noble", "commit": "41aa1bc251149cf5570d3966fb5962bded0d6414", "fileid": "beb8de3fad0ef8abd1e97a10beefbd2f49210850fb05943084451dc432d25de9", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27125774560" }, { "r": "4.6.0", "os": "linux", "version": "1.0.0.9000", "date": "2026-06-08T08:43:19.000Z", "distro": "noble", "commit": "41aa1bc251149cf5570d3966fb5962bded0d6414", "fileid": "f7a97e4246bea8d1c17d833889f5cbaa178146624be362eb6c71f513ddb56ae4", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27125774560" }, { "r": "4.5.3", "os": "mac", "version": "1.0.0.9000", "date": "2026-06-08T08:42:28.000Z", "commit": "41aa1bc251149cf5570d3966fb5962bded0d6414", "fileid": "d5a80134be49f86ede6155e343c0a77afe698d8c96622b05d96639c5f502b46b", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27125774560" }, { "r": "4.6.0", "os": "mac", "version": "1.0.0.9000", "date": "2026-06-08T08:42:37.000Z", "commit": "41aa1bc251149cf5570d3966fb5962bded0d6414", "fileid": "670a158a6ddc1c1eb4c84cd121085f7e792063e49b9ff5540dac336946ac137a", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27125774560" }, { "r": "4.6.0", "os": "wasm", "version": "1.0.0.9000", "date": "2026-06-08T08:43:25.000Z", "commit": "41aa1bc251149cf5570d3966fb5962bded0d6414", "fileid": "180a5eaf41820306488c2ed263f3b7c3764bd6ae9947e4003ad3ebfdd9dd7b35", "status": "success", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27125774560" }, { "r": "4.7.0", "os": "win", "version": "1.0.0.9000", "date": "2026-06-08T08:43:07.000Z", "commit": "41aa1bc251149cf5570d3966fb5962bded0d6414", "fileid": "40d01fe914b21caf4b859f7d7279f255a74f8349873b59063ce2145d30d09fb3", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27125774560" }, { "r": "4.5.3", "os": "win", "version": "1.0.0.9000", "date": "2026-06-08T08:42:27.000Z", "commit": "41aa1bc251149cf5570d3966fb5962bded0d6414", "fileid": "3728e26abb18ccf7f0925c9cd6a5d742374859fb7949915ad32179435ef49c99", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27125774560" }, { "r": "4.6.0", "os": "win", "version": "1.0.0.9000", "date": "2026-06-08T08:43:02.000Z", "commit": "41aa1bc251149cf5570d3966fb5962bded0d6414", "fileid": "38dbf7603b754d7a2bf94d9d7589f78ce07e8af823531c5f0ef8b0390de91284", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/josesamos/actions/runs/27125774560" } ] }