SAP Knowledge Base Article - Public

3738314 - What is the correct syntax for Date Hierarchy - SAC

Symptom

What is the correct syntax for Date Hierarchy?

For example, when setting the dimension filter for date dimension, the following syntax are possible.

Table_1.getDataSource().setDimensionFilter("Date", "[Date].[YQM].&[2026]");

Table_1.getDataSource().setDimensionFilter("Date", "[Date].[YQM].[Date.YEAR].[2026]";

Environment

SAP Analytics Cloud

Resolution

The hierarchy structure may differ between systems so if you are unsure what the correct syntax for your system, you can hit Ctrl+SPACE after [Date], and you will be prompted to select a member.

After you select a member the correct syntax will be filled for you.

Keywords

EPM, syntax, format, hierarchy, structure, date , KBA , LOD-ANA-AD , Analytics Designer , How To

Product

SAP Analytics Cloud 1.0