Hi. I tried to do the example in "Combined closure and aggregate tables" documentation, but its not working.

In other post i found this about documentation:

  • No fact_count column is used in there although in the Rules chapter of the aggregate tables documentation it is said that "the candidate aggregate table must have a column called fact_count"



  • The name of the table in the example (agg_salary_Employee$Closure_Time_Year) not to match the default table name rule agg_.+_${fact_table_name}.


my questions are: 1. ¿ actually this example should work? , ¿this function exist? . 2. if the answer is "yes" ¿how documentation example works with
default table name rule and fact_count column?

Please i need some help i dont understand aggregation tables at all

Thank you