Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Multiply Across Fact Tables with Measures

Hi all,   I have two Fact Tables, with a two measures that calculate values from each Fact Table. The Fact Tables share common Dimension Tables for the purposes of aggregation and filtering. As you...
Help Requested
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Good news, bad news... I realized I can't re-create the original statement. It was relying on a relationship that I shouldn't rely on which was exposed thanks to my cleaned up example model.

 

Thinking about it further, originally I was thinking that I needed to summarize the ProjectArea table, but I don't think that is appopriate. There is no data I need to summerize from that table. I need to leverage the data, but not summarize it. I'm generating new data for each Depdent Category by mutiplying the measures [Area by Care Setting Ratio] * [% of Benchmark Dependent Program by CareSetting].

 

I need to iteratate through each Depdent Category multiplying those values, but the values have to have the proper context as in the visual tables in the sample file.

 

Thoughts?

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

It's always good to question and review the data model. This also helps to better identify what you (or your users) are actually trying to achieve, and what they plan to do with the results.

 

It's a process, it may not be pretty but I am confident it will result in progress.

 

I'll chew on your last post for a bit and will let you know if I have meaningful input.