Skip to Content
author's profile photo
Former Member

Virtual characteristics or planing function to build report

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Oct 04, 2005 at 02:30 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded