Time Selection

The page may contain time dimension in rows, columns or context:

Member selector for time dimension will have additional functionality:

There are two radio buttons in the upper part of the dialog. If you select “Date Range” option you will have a possibility to set either fixed or floating time period.

If you use fixed period, you can set “from-to” date range. After pressing «OK» you will see the same selection in the table:

The floating period allows the user to analyze not only the past period, but also to set the sample for the next days/weeks/months/years or specify the time interval. In addition to this, it became possible to set the offset in relation to the current date. Thus, each time you open a report, you will see information for the selected period in relation to the date when you opened the report.

Let’s look at a report example. The problem is that we need to analyze every day of sales for the last 5 days. For this, the following parameters must be specified in the elements selection:

A note:

In order to make it possible to select in “Date range” mode it is necessary to design the dimension in appropriate way. The day key must be in format YYYYMMDD, the month key – in format YYYYMM, the week key – YYYYWW, the quarter key – YYYYQ, the year key – YYYY. Moreover, there must be a description for the hierarchy which “tells” the application what level is responsible for the day, what for the month and what for the year. For example: « [YMD=Day, YM=Month, YQ=Quarter, QW=Week, Y=Year] ». Day is the name of the day level, Month – of the month level, Year – of the year level, Week is the name of the week level, Quarter is the name of the Quarter level. It’s not necessary for all five level to be present in description. If the name of one of the levels contains spaces it should be enclosed in square brackets […].