Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.