Attributes in SAP BPC Optimized for S/4 analysis for ofiice - Input Layout

How are you? I will tell you that I need help with an entrance design. In an input design, I need to automatically derive an attribute from an object, that is, if the user selects the cost center (1), the company is automatically derived (2). Try adding the company as an attribute in the query, but it did not work, Can you do this with some VBA code?

Thank you all

Nayadeth Jeldres