nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Remove (DateTime) tag on column from cube builder

sriram4133

Hi, one of my users requested me to remove the (DateTime) tag on column from cube builder.
I attached screenshots.
So in the screenshot attached, column 'Year(DateTime)' should just display as 'Year'.
When I right click on (DateTime), I don't see a option to delete.
Also I tried clicking on Edit and tried choosing other formats other than 'None' but no luck.
The date column 'Drop Date' in data set is of type 'Date'.
Please provide your suggestions if you are familier with this issue.

Find more posts tagged with

Comments

sriram4133

I was able to resolve my issue using 3 calculated columns on dataset. I used these columns in Groups under the cube builder.
Now I don't see the tag '(DateTime)'. I attached screenshot.
BirtDateTime.year( row["DropDate"] )
BirtDateTime.month( row["DropDate"] )
BirtDateTime.week( row["DropDate"] )

sriram4133

I have some data mismatch issue when I tried the above solution.
I'm looking for other options.
Please let me know if anyone has any suggestions.