Forum Discussion
need to understand
hey,
its a good practice and performance topic here, for little model and simple models you wont see much of a impact but as the tablas, data, complexity growth you can end up with some ugle babies data model, making refresh slow, visuals slow, ineficient, and impact user experience for the reports, also its better for building datasets with several tablas using dates,
1) basically you turn off the in build date model for each table from the report option
2) configure a dimensianal table for managing dates
3) relantionship between them
this will make making report easier, and over time will keep your model simplier and with better performance
doing this its something the diferrence between a 1GB or 10GB dataset convert it down to 1MB dataset, and isnt exagerating the case !!!
guys in a cube show a greate video about these and overral experience and creating this type of tables: https://www.youtube.com/channel/UCFp1vaKzpfvoGai0vE5VJ0w
if this helped give some kudos and mark as solution for others to find.