cancel
Showing results for 
Search instead for 
Did you mean: 

Deriving attribute Currency using Char relationship

0 Kudos

I have a scenario of deriving attribute from Company code using Char relationship and query is input ready only if I place Currency in rows/columns pane of the query. In case if I remove Currency from query, cells are not input ready for the query.

Company code and Currency is included in aggregation level and in real time info cube.

Could you please let me know why we need to place Currency in query when we are deriving the attribute using Char relationship ?

Thanks in advance..

Edited by: peppy on May 16, 2011 11:47 AM

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi,

most probably you are using a key figure that need the same currency characteristic you want to derive. All currency characteristics of the key figures included in the aggregation level have to be also in the aggregation level. This is check when you create the aggregation level.

If this is the case, the system cannot derive the currency since it is used in the aggregation level. But the system can check the consistency of company code and currency.

Regards,

Gregor

Answers (0)