Skip to Content
avatar image
Former Member

How to eliminate # and not assigned from report level

hi team,

i have a data flow like this

DS1(data source)->DSO1-> cube1

DS2(data source)->DSO2-> cube1

ds1 structure is:

sdocno.  Netwr.  erdat.             Cuky

1567.       250.00 15.12.2015.   Inr

ds2 structure

matno.    Qty.      unit

m3145.   25.      Kg

after loading to infocube...

in the report level I'm getting data Like this

Sdocno.            Netwr.  erdat.                   Cuky.                   Matno.        Qty.    unit.

1567.                 250.00 15.12.2015.           inr                    Notassigned.  #.     Not assigned

Notassigned.     #.        Notassigned.         Notassigned.   M3145.          25.     Kg.

actually  requirements is to be displayed both in one record...

Please help me on this issue...

THanks & Regards

P Sriram.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Sep 27, 2015 at 11:59 PM

    Hi,

    That's what happens when not all InfoCubes's dimensions are loaded in the same transformation. Two  entries are created in the cube, one coming from each flow, the non-loaded characteristics from DSO1 produce some Not Assigned characteristics and the non-loaded ones from DSO2 produce the other ones.

    The solution is to load all the cube's characteristics on a single transformation.  You could choose DSO1 --> cube1 or DSO2 --> cube2 indistinctly.  The important thing is that some ABAP coding inside this transformation will be necessary to join DSO1's characteristics with DSO2's ones.  This way the cube will end up with a single entries with all their dimensions filled.  No more Not Assigned values will be there provided they aren't present from the DSO's.

    Best regards,

    Fernando

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 28, 2015 at 08:17 AM

    Unfortunately I think your requirement could not be reached.

    There is no same field name between DSO1 and DSO2.

    So system is not able to combine the records.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 29, 2015 at 06:58 AM

    I agree with Song Wang, You have to have some common characteristic in both the DSO to combine the data. Or else there is possibility you get wrong result. You should find some common field in both DSO, map to IC and then load the data. You will get desired result.

    Thanks,

    Manali Patel

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 27, 2015 at 11:24 AM

    Hi,

    This works as designed. There are limited work-arounds like diplaying a text of the Characteristic; make the text for # (unassigned) blank. Suppress 0 (zero) in the BEx Query Designer.

    If this is not sufficient, then you will have to prepare your data during data staging. Some ABAP coding could be necessary in this case.

    Best regards,

    Sander

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 28, 2015 at 05:57 AM

    IS THERE ANY PSEUDO CODE THAT HELPS TO THESE KIND OF SITUATION..

    😊

    Add comment
    10|10000 characters needed characters exceeded

    • Hello PAMARTHI wrote:

      please provide solution for that..

      please provide necessary info so i can prepare my invoice...

      there are a billion threads on start routine with the necessary coding... you could try to search before asking copy/paste ready code...