on 05-16-2011 7:16 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.