cancel
Showing results for 
Search instead for 
Did you mean: 

no reference data found by using BI IP function distribution by refernce

Former Member
0 Kudos

Hello Experts

i try to distribute plan data with the BI IP planning function " distribute by reference." from a Cube A ( ZVPCSPLA ) by using reference data from the Cube B ( ZVPCRIRP ).

but unfortunately no reference data will be found.

In the fileds to be changes are the two characteristics ZVSPSTR and ZVSPSTRE.

The date should be distributed from ZVSPSTR ( K226 ) on level SPKN ( ZVSPSTRE )

to ZVSPSTR ( 1700 ) on level SPS (ZVSPSTRE).

The data in the Cube A are the following data :

ZVFSKM ZVFSE ZVVTWS ZVVTWSE ZVSPSTR ZVSPSTRE ZVKENNGR 0FISCPER 0TYPE

0FISCPER3 0FISCVARNT0FISCYEAR

Edited by: Masfa500 on Jun 25, 2010 12:16 PM

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

The data in the Cube A are :

ZVFSKM = 1001000000

ZVFSE = 2FUEHR

ZVVTWS = 11001

ZVVTWSE = VTWEG

ZVSPSTR = K226

ZVSPSTRE = SPKN

ZVKENNGR = 5103

0FISCPER = 2010012

0TYPE = 20

0FISCPER3 = 12

0FISCVARNT0 = VM

FISCYEAR = 2010

0CURRENCY = EUR

ZVFSTAT = S

ZVPLEVEL = PCR_2FUEHR

ZVPVERS = VORSCHLAG

ZVVERS = PC1

ZVVIEW = PCR-FAKTEN

0COMP-CODE = 0000

Keyfigure = 91500

The data in the reference Cube B are :

ZVFSKM = 1001000000

ZVFSE = 2FUERH

ZVVTWS = 11001

ZVVTWSE = VTWEG

ZVSPSTR = 1700

ZVSPSTRE = SPS

ZVKENNGR = 5108

0FISCPER = 2010012

0TYPE = 10

0FISCPER3 = 12

0FISCVARNT0 = VM

FISCYEAR = 2010

0CURRENCY = EUR

ZVVERS = empty

ZVVIEW = PCR-FAKTEN

0COMP-CODE = 0000

Keyfigure = 1250

and a second record on ZVSPSTR 1701 with keyfigure = 2750

Edited by: Masfa500 on Jun 25, 2010 2:36 PM

Former Member
0 Kudos

Do you have solved this problem? We have a similar problem.

Thanks!

former_member5472
Active Contributor
0 Kudos

Hi,

What are the filter conditions based on which you are reading the data from cube for distribution ?

Pratyush

Former Member
0 Kudos

Hello Pratyush,

the filter is set to both ( from and to values ) ZVSPSTRE ( SPKN ; SPS) ZVSPSTR is not in the filter.

Data will already read from the Cube.

the settings in "Reference Values to Any Block Characteristics" are :

ZVVERS = empty ( becuse it is not filled in the refernce cube )

ZVVTWS = variable ZVPCVTW1 which contains 11001

ZVKENNGR = 5108

ZVFSKM = 1001000000

ZVGESELL = # because it does not exist in the Cubes ( neighter in A or in B )

0COMP_CODE = 0000

ZVFSTAT = # because it does not exist in the reference Cube

0FISCYEAR = variable ZVPCCE02 which contains 2010

ZVVTWSE = VTWEG

ZVPVERS = # because it does not exist in the reference Cube

0FISCPER3 = variable ZVPCPBP which contains the value 12

0VTYPE =10

ZVPLEVEL # because it does not exist in the reference Cube

0FISCVARNT = VM

ZVVIEW = PCR-FAKTEN

ZVFSE = 2FUEHR

0CURRENCY = EUR

0FISCPER = variable ZVPCFPER which contains 2010012

0INFOPROV = ZVPCRIRP ( Reference Cube )

regards Michael