Forum Discussion

ct_tm's avatar
ct_tm
Helper I
1 year ago

Query Resource Issues - SCD Type 2 Design on a Pro License

I am implenting an SCD Type 2 model for a housing company. I am rebuilding the data model from the original Type 0 design, but at a very early stage I am running into query resource limits and I just...
Need Help
ct_tm's avatar
ct_tm
Helper I
1 year ago

Thanks FarhanJeelani for your reply, it helps serve as a checkdown for optimization.

 

My issue is that I have stripped this model down to barebones already. And it does need to keep that daily granularity for everything except finances because those are being aggregated Month level.

 

In this scenario I am using a measure that itself is pretty stripped down. It just sums point-in-time column values and is running out of resources when filtered by another table that itself is already stripped down to 3 columns (listID, listName, propID) with less than 20k rows. There are no bi-directional relationships (there is the 1:1 between Occupancy and Historical Attributes but it failed the same when forced to be 1:N Attributes filtering Occupancy.

 

I'm just struggling to see how this is using over a gig of memory to compute since it seems so basic. If I am running out of resources with such a basic measure, how will I possibly be able to perform the more complex analytics without upgrading this license?

  • ct_tm's avatar
    ct_tm
    Helper I
    1 year ago

    FarhanJeelani 

    I removed pretty much everything that would be company identifyable. Of course, doing this helped some things work that were running out of resources before. Most of what I removed were text fields from dimension tables. But, I can still generate a few resource errors if I filter enough things.

    stripped out PBIX file: Operations Sample