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

Modified on Thu, 14 Mar at 12:09 PM

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.

time dimension time column real-time cache cube cast datatype associate cube Business Intelligence Support Business Intelligence Articles Business Intelligence Training

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article