Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!