I have two master data infoObjects, for example sake lets call them CONDITION and AGREEMENT. They have 1:N (agreement : condition) relationship and are not compounded. Each AGREEMENT has CONDITION(s) whereas there are CONDITIONS without AGREEMENTS.
..
Details of InfoObject
CONDITION have attributes, customer group, brand, agreement
AGREEMENT have attributes sales group, sales office and recipient
..
Reporting Requirement : Get agreement amounts with details like recipient name and number, sales office etc. ( catch is first to get the conditions related to Agreement )
.
Issue: Currently it just gets the facts (amount) for Agreements in infocubes whereas I want it to first to find the conditions related to the Agreement then grab the facts (amount).
..
How do I achieve this, I need your help to model this requirement
Current Model
AGREEMENT and CONDITIONS are characteristics in separate dimensions.
I can probably build a query using CONDITIONS navigational attribute AGREEMENT but then how do I display attributes of AGREEMENTS.
Thanks so much for your help..