OLAP/Tabular Time Dimension Filtering

Quickly set up your OLAP/Tabular time dimension to be filtered by the date calendar picker or set various time filtering periods relative to the current date time. The time dimension is almost always related to your reports. Use advanced and user-friendly time dimension filtering on analysis, reports, and dashboards with the Kyubit BI tools.

Easy OLAP Time Dimension Filtering with Kyubit BI Tools

Common OLAP reporting scenario includes filtering of data based on date period relative to the current time, such as 'Last Week', 'Last 3 Months', 'Parallel Period', etc. There are different approaches to this filtering requirement and Kyubit BI tools now include additional options to make it easy for any analyst to filter any data based on relative time periods from the current date.
OLAP time dimension filtering
The most intuitive and user-friendly OLAP date picker end-users will appreciate using while analyzing OLAP data.

SSAS OLAP Analysis tools

Configure 'Time Intelligence'

Time Dimension hierarchy could be used as Time Intelligence Slicer once we have defined its level member unique name format. This configuration action has to be done only once, after which all users can benefit from this configuration. The basis for this feature is on the application to find appropriate dimension members based on the current date, after which it is no problem to use any time functions to find any scope of periods relative to the current date/time. For that reason, we have to define member unique name formatting for each dimension level we want to use as a Time Intelligence Slicer.

Time 'Member Unique Name' Format Examples...

Numbers in the member's unique name should be replaced by certain date parts (Year, Semester, Quarter, Month, Week, Day), that would describe to the application which date parts are needed to construct a member's unique name. It is easy to manually interpret a member's unique name format and replace with the appropriate date part Placeholders. Placeholders are not case-sensitive.

Available date part Placeholders

Current year. Sample: 2017

A current semester. Sample: 2

A current semester with leading zero. Sample: 02

A current quarter. Sample: 4

A current quarter with leading zero. Sample: 04

A current month. Sample: 9

A current month with leading zero. Sample: 09

A current week. Sample: 2

A current week with leading zero. Sample: 02

A current day within a month. Sample: 5

<<Day> >
A current day within a month with leading zero. Sample: 05


  • Member Unique Name: [Date].[Calendar].[Month].&[2017]&[10]
    Resolves as ...
    Member Unique Name Format: [Date].[Calendar].[Month].&[<Year>]&[<Month>]

  • Member Unique Name: [Date].[Calendar].[Date].&[20141112]
    Resolves as ...
    Member Unique Name Format: [Date].[Calendar].[Date].&[<Year><<Month>><<Day>>]

  • Member Unique Name: [Date].[Fiscal Weeks].[Fiscal Week].&[32]&[2013]
    Resolves as ...
    Member Unique Name Format: [Date].[Fiscal Weeks].[Fiscal Week].&[<Week>]&[<Year>]

Get started with Kyubit BI tools

BI tools download Download the Kyubit BI platform 30-day evaluation and see OLAP tools and features in action.
It is a simple and quick installation that will bring all features unlocked in the evaluation version. We will be happy to receive your feedback and inquiries. Download 'Self-service Analytics - User Manual' which covers all aspects of OLAP analysis with 'Kyubit Business Intelligence'.