OLAP Time Dimension Filtering

Using Time slicers

Time Intelligence filters could be used within OLAP analysis, OLAP reporting or in Dashboard. Prior to be used as time intelligence filter, OLAP dimension hierarchy needs to be configured (only once) in Kyubit application (explained below). After initial configuration, same OLAP dimension hierarchy could be used for relative time period filtering anywhere in Kyubit application, by any user.

• Time Intelligence slicer applied Project Type

• Add Time dimension hierarchy that is configured for Time Intelligence filtering.
  
  
  Add time dimension Hierarchy ... Project Type
• Select available levels of dimension hierachy to be used as time intelligence slicer.
  
  
  Select hierarchy level ... Project Type
• Select 'Time Function' ('Last Periods' or 'Parallel Period') and 'Periods' number.
  
  
  Select function and periods ... Project Type

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.

• 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 Data Source ... Project Type
• 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.
  
  
  Time Dimension Levels ... Project Type
• 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.
  
  
  Resolve Formatting ... Project Type
• After resolving the 'Member Unique Name' Format (Manually or Auto Resolved), click on the 'Test' button, which should validate 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.
  
  
  Validate and Save Project Type

---

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

<Year>
Current year. Sample: 2017

<Semester>
Current semester. Sample: 2

<<Semester>>
Current semester with leading zero. Sample: 02

<Quarter>
Current quarter. Sample: 4

<<Quarter>>
Current quarter with leading zero. Sample: 04

<Month>
Current month. Sample: 9

<<Month>>
Current month with leading zero. Sample: 09

<Week>
Current week. Sample: 2

<<Week>>
Current week with leading zero. Sample: 02

<Day>
Current day within a month. Sample: 5

<<Day> >
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

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