worldofchandran
Technical User
Hi,
I wanted to know whats the best strategy to have mulitple date fields in a cube?
Should we go for a date dimension for each date field or store it as only a category? The input data source is not a data warehouse so there is no date dimension in the input feed as well, it just exists as a date field in tables.
The current model that i need to build has 7 date fields like begin date, end date, effective date and so on. How do i arranage these 7 fields in my cube?
I wanted to know whats the best strategy to have mulitple date fields in a cube?
Should we go for a date dimension for each date field or store it as only a category? The input data source is not a data warehouse so there is no date dimension in the input feed as well, it just exists as a date field in tables.
The current model that i need to build has 7 date fields like begin date, end date, effective date and so on. How do i arranage these 7 fields in my cube?