OLAP Time Dimension Filtering

Quickly set up your OLAP 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 most user-friendly OLAP time dimension filtering on analysis, reports, and dashboards with the Kyubit BI.

Easy OLAP Time Dimension Filtering with Kyubit BI Tools

Common OLAP reporting scenario includes filtering of data based on date period relative to current time, such is 'Last Week', 'Last 3 Months', 'Parallel Period', etc. There are different approaches to this filtering requirement and Kyubit BI tools now include additional option 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 Time Intelligence Slicer.

Time 'Member Unique Name' Format Examples...

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

Available date part Placeholders

Current year. Sample: 2017

Current semester. Sample: 2

Current semester with leading zero. Sample: 02

Current quarter. Sample: 4

Current quarter with leading zero. Sample: 04

Current month. Sample: 9

Current month with leading zero. Sample: 09

Current week. Sample: 2

Current week with leading zero. Sample: 02

Current day within a month. Sample: 5

<<Day> >
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 30 days evaluation of 'Kyubit Business Intelligence' and see OLAP tools and features in action.
It is a simple and quick installation that will bring all features unlocked in evaluation version. We will be happy to receive your feedback and inquiries.
Download 'Kyubit Business Intelligence OLAP analysis - User Manual' which covers all aspects of OLAP tools with 'Kyubit Business Intelligence'.