Create hierarchy hour, minute, second, millisecond

[Syndicate_Admin]

Hello

I have a column with the name time that collects data year, month, day, hour, minute, second and millisecond.

In this format,

2022-10-24 10:07:19.174

2022-10-24 10:07:27.454
2022-10-24 10:07:29.95

2022-10-24 10:07:40.013

My intention is to create a hierarchy that I can link in a segmentation so that I can choose what time frame at those scales I want to show myself.

If any further specification is needed, please do not hesitate to ask,

Thank you very much,

Eneko

[Engineer_Spain]

I understand. And once I have them separated by the date on one side and hour minute second on the other, could I have a segmentation to control the hours minutes and seconds?

[lbendlin]

you can have your full hierarchy including the date components too if you want.  The question will be how useful that will be to your report users.  How do you expect them to interact with the report?

[Engineer_Spain]

It was not intended for user interaction. The problem goes beyond that. I'm only interested in strips of all the data information, and those strips are about a minute long.

[lbendlin]

giant red flag.  The granularity  (especially with milliseconds involved)  will be monstrous, and you will not be able to add any real data to that semantic model.

Recommendation is to have separate Date and Time dimension tables, and to separate these values in your fact table as well (into separate columns).  Ideally you would drop the milliseconds, but if you need to keep them the create a third dimension table just for them.