Skip to Content
0
Former Member
Jun 22, 2005 at 01:42 AM

Seeking Modelling Advice

17 Views

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..