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
Package: when 1.0.0.9000
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:
when_1.0.0.9000.tar.gz
when_1.0.0.9000.zip(r-4.7)when_1.0.0.9000.zip(r-4.6)when_1.0.0.9000.zip(r-4.5)
when_1.0.0.9000.tgz(r-4.6-any)when_1.0.0.9000.tgz(r-4.5-any)
when_1.0.0.9000.tar.gz(r-4.7-any)when_1.0.0.9000.tar.gz(r-4.6-any)
when_1.0.0.9000.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
when/json (API)
| # Install 'when' in R: |
| install.packages('when', repos = c('https://josesamos.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/josesamos/when/issues
Pkgdown/docs site:https://josesamos.github.io
Datasets:
- date_days - Precalculated date set
- time_seconds - Time in seconds of a day
Last updated from:41aa1bc251. Checks:9 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-x86_64 | OK | 174 | ||
| source / vignettes | OK | 195 | ||
| linux-release-x86_64 | OK | 164 | ||
| macos-release-arm64 | OK | 113 | ||
| macos-oldrel-arm64 | OK | 107 | ||
| windows-devel | OK | 158 | ||
| windows-release | OK | 174 | ||
| windows-oldrel | OK | 123 | ||
| wasm-release | OK | 141 |
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:backportscachemclicpp11DBIdmdplyrfastmapgenericsgluehmslifecyclelubridatemagrittrmemoisepillarpkgconfigpurrrR6rJavarlangsnakecasestringistringrtibbletidyrtidyselecttimechangeutf8vctrswithrxlsxxlsxjars
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Precalculated date set | date_days |
| Define dimension characteristics | define_characteristics define_characteristics.when |
| Define instances | define_instances define_instances.when |
| Generate table | generate_table generate_table.when |
| Get attribute definition function | get_attribute_definition_function get_attribute_definition_function.when |
| Get day part | get_day_part get_day_part.when |
| Get level attribute names | get_level_attribute_names get_level_attribute_names.when |
| Get level names | get_level_names get_level_names.when |
| Get the table of the dimension | get_table get_table.when |
| Get table attribute names | get_table_attribute_names get_table_attribute_names.when |
| Store the table in a csv files | get_table_csv get_table_csv.when |
| Store the table in a relational database | get_table_rdb get_table_rdb.when |
| Store the table in a xlsx file | get_table_xlsx get_table_xlsx.when |
| Get week date range | get_week_date_range |
| Configure date levels | select_date_levels select_date_levels.when |
| Configure day level | select_day_level select_day_level.when |
| Configure month level | select_month_level select_month_level.when |
| Configure quarter level | select_quarter_level select_quarter_level.when |
| Configure semester level | select_semester_level select_semester_level.when |
| Select time level | select_time_level select_time_level.when |
| Configure week level | select_week_level select_week_level.when |
| Configure year level | select_year_level select_year_level.when |
| Set attribute definition function | set_attribute_definition_function set_attribute_definition_function.when |
| Set day part | set_day_part set_day_part.when |
| Set table attribute names | set_table_attribute_names set_table_attribute_names.when |
| Time in seconds of a day | time_seconds |
| 'when' S3 class | when |
