Date entity as String

Fethi ZERARA
Fethi ZERARA Active Partner, Community Captain
Fourth Anniversary 100 Comments 5 Answers 25 Likes
in Platform

Hello everyone , i'd like to know if there is a way to add an entity in date hierarchy that accepts String , i wanna do that beacuse i'm trying to upload a table that possesses  a column which contains "YTD or TYG" so when i try to load it i get "0"  and that because i have to put a date format  -_- 

Thank you for your help !

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary
    edited March 2020

    Hi Fethi Zerara,

     

    you could add a custom time dimension to the date time-herarchy but, I don't think that will solve your problem since you would have to build up appropriate relationships for this new entity in your time-hierarchy and to which date would you want to connect "YTD" (define a relation)?

    BOARD already gives you the opportunity to calculate with YTD values using the appropriate funktion in the DataView configuration as shown here:

    image

    If you want to load already accumulated values (which I suppose, you want to do) you would have to load those values to the last day of the period (e.g. the last day of the year), probably using ETL to achieve this.

     

    Hope, this helps!

    Regards,

    Helmut

Categories