Forum Discussion
parent with multiple children
We have fulfillment schema with multiple tables each having their own measures. For example
A service call have have 1+ appointments to fulfill the call with measures like: how many days to fulfill the service call, # of appointments for each call, days between appointments
Once a service call is complete we record the details (e.g. replaced part, cost of the part and labor)
So far I have the service call in the the middle of the schema with links to appointments and details with some snowflaking
Basically, I have a hierarchy of measures and was thinking there's a way to get all of them in a central table
I'll try to post sketch of the dimensional model but anyone else run into this design issue ?
2 Replies
Hi Anonymous,
You can refer to the following steps to create a central measure table and move all your measure fields to it.
1, Enter data to create a new table(with single value column) as 'measure' table
2, Navigation to 'modeling' tab(top menu bar) and choose measures and modify their 'home table' properties to change measure host table to 'measure' table.
3, After finish moves all measures by changing their 'home table' properties, remove 'measure' table column field.
4, Click twice on '>' icon(top right corner of fields panel) to collapse/expand panel to update the icon of 'measure' table.Best Regards,
Jack Chen