Forum Discussion

ghutchins's avatar
ghutchins
Icon for Helper II rankHelper II
3 years ago

Create a Calculated Table to use as a dimension table

I have been told that I need to create a table dimension table.  What I need to do is to create relationships to this table from ~10 other tables.  The ~10 tables have various names for our locations.  The Dimension table would hold the common name for the location that I want to present in a data visualization and therefore allow the data from the ~10 tables to be displayed in one visualizaton.  How is this done?  Any help is appreciated

 

 

Common NameT1- NameT2 - NameT3 - NameT4 - Name
F1Fac1Facility11 - FacFac - 1
F2Fac2Facility22 - FacFac - 2
F3Fac3Facility33 - FacFac - 3
F4Fac4Facility44 - FacFac - 4
No RepliesBe the first to reply