Jet Reports Homepage |  Community Forum |  Downloads |  Submit A Ticket |  Jet Express Support
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 Enterprise standard projects over time. If these syntaxes are not used Jet Reports 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:

2012

Supported syntax:

[Posting Date].[Date - YQMD].[Year].&[2012]

Quarter:

Example:

Q2 2012

Supported syntaxes:

[Posting Date].[Time - YQMD].[Quarter].&[2]&[2012]

[Posting Date].[Date YQMD].[Quarter].&[201202]

Month

Example:

January 2012

Supported syntaxes:

[Posting Date].[Time - YQMD].[Month].&[1]&[2002]

[Posting Date].[Date YQMD].[Month].&[201201]

Day:

Example:

April 23, 2014

Supported syntaxes:

[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