Time dimension unavailable when associating from Cache to Real-time cube

Issue: When we create an object from cache cube and associate cache cube to real time cube, time dimension hierarchy columns will not match.

Resolution:

Year, quarter and month column has data type int in cache cube. In real time cube, we add year, quarter and month in query which is in character data type, so we need to cast it to int type.

1.  Create a cube using cube type cache and create time dimension hierarchy (Year, Quarter, Month).

2.  Create an analysis using Year, Quarter, Month and one measure. Save the cross tab in Repository folder.

3.  Now to associate with a real-time cube, create one (use the cast to convert datatype to integer)

4. Now associate the earlier created crosstab from cache cube to real time cube

• Administration 
• Repository
• Tick Object which needs to be associated from cache to real-time cube
• Associate Cube icon (toolbar)

5. In Associate cube, select the real time cube. All columns will matched accordingly

If the data type of any column is not same in both the cubes then it would not match.

Note: This article is based on Smarten Version 5.x. This may or may not be relevant to the Smarten version you may be using.

Tags: time dimension, time column, real-time, cache, cube, cast, datatype, associate cube, Business Intelligence Support, Business Intelligence Articles, Business Intelligence Training, Time dimension unavailable, Time dimension hierarchy, Data type mismatch, Integer data type, Character data type, Cast to int, Cube creation, Analysis creation, Repository folder, Crosstab association, Real-time cube association, Administration panel, Associate Cube icon, Data type conversion, Column matching, Year, Quarter, Month columns,