Forum Discussion

Hawkwing's avatar
Hawkwing
New Member
5 years ago
Solved

Time dim table incorrectly recognized by CALENDARAUTO()

Hey everyone, first-time poster here. I have separate date and time dimension tables I've picked up from posts in this forum and elsewhere. My problem is that my date dim table, which uses CALENDARAU...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    CALENDARAUTO doesn't know which tables and columns to look at so it looks at all of them. In my particular use cases, I don't typically need to look at more than a couple of columns to make sure I've captured the date range for all other columns I want to. You can have a bunch of date columns, but it's often predictable which ones will be dictating your maximum and minimum.

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
5 years ago

CALENDARAUTO doesn't know which tables and columns to look at so it looks at all of them. In my particular use cases, I don't typically need to look at more than a couple of columns to make sure I've captured the date range for all other columns I want to. You can have a bunch of date columns, but it's often predictable which ones will be dictating your maximum and minimum.

Hawkwing's avatar
Hawkwing
New Member
5 years ago

Thanks for your help!