Use of Attributes in Consolidation & Close
Hi All, we have in our FCCS entity dimension members which are physical buildings tha are reported on in Monthly Management Reporting. There is a requirement to be able to classify these buildings as having a categorisation of other buildings in their locality (e.g. school, hospital, retail site etc...) for analysis (e.g. show me all my buildings that are close to a hospital or close to a hospital and a school).
We can do this on a one to one basis by setting up an attribute dimension which has all the different buildings (school, hospital etc...) but this will not satisfy where we have a one to many scenario(e.g. a building that is close to a school and a hospital). I don't want to create all combinations of buildings in the one dimension as this will be a major maintenance overhead as well as confusing to the end users. I also don't want to create individual attribute dimensions for each categorisation(e.g. one for hospitals, one for schools etc...) as this could