Virtual characteristics or planing function to build report

[Former Member]

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

[Former Member]

Dmirty,

It all depends on your need to deal with CHAR1 in the planning.

If you don't need CHAR1 for planning & If you don't want to store CHAR1 into the cube, just derive it using virtual characteristic.

yes. you can derive CHAR1 from CHAR2 & CHAR3.

There is a How-To-Document "Identify Comparable Results within a query" that best describes in detail step-by-step on deriving a "virtual characteristic" value from other "basic characteristic" values.

hope it helps.

[Former Member]

Hi, hari79

Thanks a lot!

Seems, it should help me!

[Former Member]

Dmitry,

glad that it was of helpful.

you can award the points for useful answers.