Forum Discussion
Perfomance Questions
In this video, they talked about having an aggregated table on the live connection. Check if this can help
Hi Macwin ,
“Should I create the hidden aggregated table in bi querie editor or should I create a aggregated table in my SQL server.”
It's better to create the hidden aggregated table in Edit Queries.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
In this video, they talked about having an aggregated table on the live connection. Check if this can help
I think this composite feature is perfect for my use case. But im not sure how to correctly setup this up on my project.
This is how I tried to setup up the compositie model.
"AGG Table" and "Hourly updated Tablet" are connected through the time/date column.
Masterdata contains static infos about the gathered items in the direct query table.