Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dual storage table in aggregation model

Hi all,   I've been trying to get my head around this problem for ages.   I have a simple model set up where I am testing composite model and aggregations features. I have a sales fact table in d...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks venal 

 

I am still having the same problem when the dataset is much smaller.

 

The direct query fact table is now 8m rows and the imported aggregate fact table is now 50,000 rows. The product dimension table is still 500k rows. My simple model is shown below. Both fact tables join to the product table using the article_no field.

 

Regards

 

Mike

venal's avatar
venal
Memorable Member
6 years ago

Anonymous 

If you have any error message, please share it with us.

If no error message and thinking that there was a data discrepency, please submit a support ticket to investigate.

Please share the support ticket here for reference.

If you have any other queries, please let us know.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?