Sign Up for Training |
Jet Global Company Site
Community
Downloads
Submit a Request
Give Feedback

Supported Cube Date Formats for the Jet Dashboard Builder


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]

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments