Overview
There are a number of different ways to structure dates in OLAP cube hierarchies. This article discusses the formats that are currently supported by the Jet Dashboard Builder. The supported formats encompass the two different syntaxes that have been used in Jet Analytics standard projects over time. If these syntaxes are not used, Jet Global cannot guarantee compatibility of some Dashboard Builder functionality such as relative date filters.
Process
The supported date hierarchy formats for the Jet Dashboard Builder are as follows:
Year:
| Example | Supported Syntax |
|---|---|
| 2012 | [Posting Date].[Date - YQMD].[Year].&[2012] |
Quarter:
| Example | Supported Syntax |
|---|---|
| Q2 2012 |
[Posting Date].[Time - YQMD].[Quarter].&[2]&[2012] [Posting Date].[Date YQMD].[Quarter].&[201202] |
Month
| Example | Supported Syntax |
|---|---|
| January 2012 |
[Posting Date].[Time - YQMD].[Month].&[1]&[2002] [Posting Date].[Date YQMD].[Month].&[201201] |
Day:
| Example | Supported Syntax |
|---|---|
| April 23, 2014 |
[Posting Date].[Time - YQMD].[Month].&[4]&[2014].&[2014-04-23T00:00:00] [Posting Date].[Date YQMD].[Day].&[2014-04-23T00:00:00] |
Comments