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 fulf...
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
How is this a solution ? This is related to an accumulated fact table and not about a calculated measure table.