Mastering Time Intelligence for OLAP Data Sources

Seamlessly connect your OLAP time dimensions to an intuitive calendar picker or define dynamic filters relative to the current date. Because time is the backbone of every report, Kyubit provides advanced, user-friendly filtering that brings precision and clarity to your analysis, reports, and dashboards.

Easy OLAP Time Intelligence with Kyubit BI Tools

While native OLAP data sources often lack flexible, out-of-the-box time intelligence for complex relative period comparisons, they can be difficult for average users to navigate. Kyubit bridges this gap by providing intuitive, built-in features that simplify date-based analysis and trend tracking without requiring advanced technical expertise.
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.



  • Open the OLAP data source dialog form and click on the Time Intelligence button. All Time dimension levels in the OLAP cube will be listed.

    OLAP Time Intelligence Slicer 4 OLAP Data Source ...
  • The already resolved formats are displayed on the right side of the listed dimension levels. Click on the time dimension levels to define its member's unique name formatting.

    OLAP Time Intelligence Slicer 5 Time Dimension Levels ...
  • A list of sample members for selected dimension levels shows member unique name samples. Replace numbers in the member's unique name with the appropriate date units (Year, Semester, Quarter, Month, Week, Day). We could resolve the definition manually or with the help of the 'Auto Resolve' button, which should work in most cases.

    OLAP Time Intelligence Slicer 6 Resolve Formatting ...
  • After resolving the 'Member Unique Name' Format (Manually or Auto Resolved), click on the 'Test' button, which should validate the provided definition. Please, refer below samples for the manual definition. If validation is successful, click 'OK' and 'Save' on the list of dimension levels. That time dimension level is ready to use on any analysis or dashboard.

    OLAP Time Intelligence Slicer 7 Validate and Save

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

<Year>
Current year. Sample: 2017

<Semester>
A current semester. Sample: 2

<<Semester>>
A current semester with leading zero. Sample: 02

<Quarter>
A current quarter. Sample: 4

<<Quarter>>
A current quarter with leading zero. Sample: 04

<Month>
A current month. Sample: 9

<<Month>>
A current month with leading zero. Sample: 09

<Week>
A current week. Sample: 2

<<Week>>
A current week with leading zero. Sample: 02

<Day>
A current day within a month. Sample: 5

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


Examples

  • 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'.

More About SSAS Reporting with Kyubit...