This Calendar dimension is created for Power BI reports. This excludes accounting period of 0, 997, and 998.
| Field Name | Source or calculation | Notes |
|---|---|---|
Fiscal Month | ACCOUNTING_PERIOD in UM_GLQ_REPRTING | |
Fiscal Year | "FY" - FISCAL_YEAR in UM_GLQ_REPRTING | |
Fiscal Year Number | FISCAL_YEAR in UM_GLQ_REPRTING | |
| Full Month | Fiscal Month - Month | |
| Month | The first three characters of the month |
Examples:
Attachments:
image2021-3-29_10-6-52.png (image/png)
image2021-3-29_10-6-4.png (image/png)
image2021-3-29_9-24-34.png (image/png)
image2021-3-29_9-24-19.png (image/png)
image2021-3-29_9-8-38.png (image/png)
image2021-3-29_9-52-53.png (image/png)
image2021-3-29_10-23-1.png (image/png)