How to expose Temporal Table to BI tools which doesn't speak Temporal

Data Modeling
Teradata Employee

How to expose Temporal Table to BI tools which doesn't speak Temporal

Does anyone has experience in exposing Temporal Table to BI tools which doesn't speak Temporal?

For example, I have temporal table below:

CREATE MULTISET TABLE DimModel.Stores_ST_Temp ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      Store_ID INTEGER NOT NULL,

      Store_Name VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

      District_ID INTEGER NULL,

      Store_Manager VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

      Tel_Number CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

      District_Name VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

      District_Manager VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

      EffectivePeriod PERIOD(DATE) AS VALIDTIME NOT NULL

      )

PRIMARY INDEX (Store_ID)

And I can create the sequenced validtime, 

CREATE VIEW DimModel.Stores_ST_TempV AS

SEQUENCED VALIDTIME SELECT * FROM DimModel.Stores_ST_Temp;

And when I select from this view, the column VALIDTIME will be in the result set, if I use EQUENCED VALIDTIME again.

But I wan't able to use BEGIN(VALIDTIME) as Effective_Date, END(VALIDTIME) as Effective_End_Date to expose it as the traditional SCD type 2 columns. So that if a BI tool doesn't speak Temporal would still be able to access it.


Lastly, do the major BI tools such as Microstratgy, Cognos, OBIEE, Qlikview, Tableau etc support Temporal?

Either ISO or Teradata style?