Skip to Content
author's profile photo Former Member
Former Member

modelling question

Hello,

I load chars. 0CUST_SALES, 0CUSTOMER, 0DISTRCHANNEL, 0SALESORG and keyf. 0SALES into a cube.

0CUST_SALES contains of attribute 0DISTRCAHNNEL & 0SALESORG & 0PRICE_GROUP. I load this masterdata.

In the report I wish to navigate on the 0PRICE_GROUP which is dependant of 0DISTRCAHNNEL & 0SALESORG .

Will I be able to do this provided 0PRICE_GROUP is defined as nav attribute? Will the OLAP engine be able to sort out which price group that should be shown depeding on the input in the other fields?

Regards,

F C

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Feb 26, 2007 at 07:12 PM

    Hi FC:

    Based on your answer, I don't think your requirement is as complex as I thought it was.

    <i>As per now the three attributes only exist as attributes. Are you saying that in order to be able to use price group in the query I need to use distr channel and sales org as compounding objects of cust_sales?</i>

    Not unless you want to Drill-Down by a combination of ALL THE THREE. From you answer, I didn't think its the case.

    <i>Are they then needed as attribues also? Perhaps I should only have price group as attribute and the other two as compounding?</i>

    Don't do this, I simply asked if its the case, not recommending you to do that. By compunding, what you are saying is that as a Transaction, they MUST belong in a single record to make sense.

    e.g., 0012345, AREA1.

    Cost Center 00012345 and Controlling area AREA1.

    These may belong together becasue you may have the same Cost Center for another controllong area like

    00012345, AREA2.

    <i>I do still need sales org and distr channel in the cube (transaction data) don't I?</i>

    For this, to know the defference between having Characteristics in Cube and/or Navigationl Attr, read below:

    navigational-attribute

    then, let me know what you think.

    Chamarthy

    Message was edited by:

    Udayabhanu Pattabhi Ram Chamarthy

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 26, 2007 at 05:29 PM

    Hi FC:

    Yes, as long as they are Navigational Attributes, you can drill-down and have filters on them in Query.

    <i>In the report I wish to navigate on the 0PRICE_GROUP which is <b>dependant</b> of 0DISTRCAHNNEL & 0SALESORG .</i>

    What do you mean Dependent? are they COmpounded?

    <i>Will I be able to do this provided 0PRICE_GROUP is defined as nav attribute? Will the OLAP engine be able to sort out which price group that should be shown depeding on the input in the other fields?</i>

    Only if they are Compounded and in which case, they will automatically come in your Query when you drag 0PRICE_GROUP.

    Chamarthy

    Message was edited by:

    Udayabhanu Pattabhi Ram Chamarthy

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello,

      I mean dependant in the way that the 0PRICE_GROUP in the SID table for 0CUST_SALES is depending on the entry of the other attributes in the SID (distr channel & Sales org).

      As per now the three attributes only exist as attributes. Are you saying that in order to be able to use price group in the query I need to use distr channel and sales org as compounding objects of cust_sales? Are they then needed as attribues also? Perhaps I should only have price group as attribute and the other two as compounding?

      I do still need sales org and distr channel in the cube (transaction data) don't I?

      Regards,

      F C

      Message was edited by:

      F C

  • Posted on Feb 26, 2007 at 10:14 PM

    Hi FC:

    I was a little confused when you said

    <i>The SID (master data table) looks like this (example):

    0CUST_SALES 0DISTR_CHANNEL 0SALES_ORG 0PRICE_GROUP

    0001 2000 2100 A

    0001 3000 2200 B</i>

    For the InfoObject 0CUST_SALES, how can you have different Arrtibutes for the same Key 0001. It is only possible if:

    1) they are time-dependent

    OR

    2) 0DISTR_CHANNEL & 0SALES_ORG are compounded with 0CUST_SALES.

    I hope you solved your Query problem.

    Chamarthy

    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.