I have a question around my date dimensions. Most ...
# gooddata-platform
t
I have a question around my date dimensions. Most of my date dimensions have the usual different granularity options, e.g. year/month/day of month/…, but one of them (apparently the oldest date dimension) doesn’t have any of them. How can I add them now?
1
m
Hi Thomas, as far as I remember, date dimensions had this structure for quite a long time so even a relatively old one should have these attributes. So you can only see one attribute “Date (Created At)” for your date? If yes, I have a few ideas: • is it really a date dimension and not a regular (string) attribute? i.e. can you see it as a separate blue box in your Logical Data Model? • If yes and you can still not see the other date attributes, then maybe someone has hidden/deprecated the other attributes in the past? ◦ to check that you might try this: ▪︎ go to
https://{HOSTNAME}/gdc/md/{WORKSPACE_ID}/query/datasets
gray page and locate the appropriate date dataset there and click it ▪︎ it should open another gray page with list of “attributes” in the top. Here it should list also potentially deprecated attributes. You will only see only the links (if you have the GoodData extension for Chrome, you can hover the link to get the title and identifier) ▪︎ You can click one attribute each time (just attributes, ignore the “data loading columns” below them) and check on its detail if it has value of property
"deprecated"
set to “1”. Make sure to check the “deprecated” property of the attribute - in the “meta” section at the very end (not any within the “displayForms” section). ▪︎ If there is deprecated=1, this attribute is hidden from the lists on the UI and API. To revert that, you can do these steps: • check that the URL is
https:/{HOSTNAME}/gdc/md/{WORKSPACE_ID}/obj/{SOME_NUMBER}
• add
?mode=edit
at the end of the URL and hit Enter • the contents of page will load in a simple text editor • scroll all the way down and change the
"deprecated" : "1"
to
"deprecated" : "0"
. Do not modify anything else. • hit “Submit” • your attribute should now be restored and visible in the UI • you can do this for any deprecated attribute
t
thanks, that worked!
1