Hi, folk
I have a transactional cube with the following characteristics :
1. CHAR1 with HIER1.
2. CHAR2
3. CHAR3
During planning process, just a values for CHAR2 and CHAR3 can be filled. Correspondence between value of CHAR1 and combination of the values of chars CHAR2 and CHAR3 is stored in the separated tuning data slice.
Combination of the CHAR2 and the CHAR3 determines value of the CHAR1.
Now I have to build report where data will be presented as hierarchy HIER1.
Of course, I can create a planning function, which determines value of CHAR1 based on values CHAR2+CHAR3 and write one in the corresp. row. But I think, that more sophisticated way is existed.
For example, can I use a virtual characteristics to determine value of CHAR1?
Any advices are appreciated!
Thanks in advance,
Dmitry
Message was edited by: Dmitry Kasabutsky