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

Data flow from ODS to Infocube

Dear All,

in the ODS object I have a certain number of records. Each record represent a repair made on a specified vehicle. For example:

Vehicle | Repair ID | Repair Date

XYZ 1 01/01/2005

FGH 4 05/01/2005

...

XYZ 6 06/01/2005

What I need is to create an infocube that can provide me the information about how many DISTINCT vehicle have been repaired.

In other words what I need is to put the data into the infocube according to a "SELECT DISTINCT" from the ODS object.

I kindly ask you which is the best way to do that job.

Thank you in advance.

Regards,

R.C.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2005 at 06:43 PM

    My strategy will be, as you suggested, the following:

    ODS 1^ LEVEL -> "Select DISTINCT" -> ODS 2^ LEVEL

    What is not so clear to me is where/how define the "group by" statement between the ODS 1 and ODS 2.

    Must I write a routine or it is possible to specify the group by parameters in other ways?

    Thanks,

    R.C.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I agree with Roberto. You should probably have an additional ODS with dealer and Vehicle as your key. I believe they refer to this as "Stove Pipe", but sometimes it unavoidable. I have had to do this before to be able to meet specific reporting requirements and don't see it as a problem

      Good Luck.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2005 at 04:45 PM

    Roberto,

    if I right understood, to obtain what you want it's enough to put into your query only 'Vehicle' as dimension analysis (on the rows) and a Counter KF (on the column) always equal to '1'.

    In this way you will have a list of all repaired vehicle (one row for every vehicle even if there are a lot of repairs on it) and, as overall result, your desired 'how many vehicle have been repaired'...

    Let me know if this is your need or if you want some more info...

    Hope it helps (and please don't forget to assign some points by clickin'on the yellow star to the contributors that help you !!!)

    Bye,

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      This topic is often a constraint in developing a data model (as for SORT and other similar statements...)

      In update rules you could execute your GROUP BY, but you should have to know for certain that only ONE packet arrives on your provider (you could change default seeting parameter in transferring data, but it's not a good practice and this might lead other performance problems)...

      on the other hand you can create a second-level ODS in which you can put your group by fields as key combination...

      or feed your cube with a special infosource linked to a datasource for which a pgm (FM, ABAP query) calculates what you need, avoiding OLAP aggregation...

      but you have to choose a work-around !

      Bye,

      Roberto

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.