on 06-25-2010 11:16 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
What are the filter conditions based on which you are reading the data from cube for distribution ?
Pratyush
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.