Hi Robert, I understand, the attributes that happen to be on physical facts must be logically normalized into 3NF in the Business layer. This is what we are doing. The issue arises when a user attempts to add a filter to an analysis and either clicks the drop down to select a value to filter on. This action pushes a count…

Hi Christian, Logically the attributes are in dimensions only physically are they in facts. These attributes are de-normalized and do not exist in any physical dimension. While I wish I could control the modeling, indexing, partitioning etc. of of our sources, this is not within scope. I am looking for a way to make the…