Cannot copy the plan data in BEx Analyzer

[Former Member]

HiAll

I have actual data in one infocube and created a real time info cube. On top of these i have a multi provider. I have created a planning function to copy the actual data to plan data.....(did use from change and To change and defined my requirements for copying)

Now i would like to create a interface using BEx Analyzer..... I created a button for Copy and when i excute it it says

"Planning function ZSL_P_COP executed without errors"

"0 records read, 0 generated, 0 changed, 0 deleted".

Please let me know what is the problem. This is the first time i am using planning. What i am thinking is once this planning funciton gets executed i would see the data in the Analysis Grid... Please let me know if i am wrong..

Regards

Aditya

[Former Member]

Thats ok. But the cubes have different chars and hence of different level of granularity. Can you correct that and reexecute the function.

Ravi Thothadri

[Former Member]

Hi ravi

I am sorry... I did type the actual cube characteristics wrong... Now i have edited... the responsible person is the only extra characteristic in the real time info cube

Aditya

[former_member210321]

Hi Naga,

May i know the solution of the problem as how you have solved.

Regards,

[former_member210321]

My problem have been solved, the error was in my FOX code which has been corrected. Now the cube is getting the records from the Bex.

Regards,

[Former Member]

Your cubes are of different level of detail. This may have caused your function to run with xero records. Pl check that.

Ravi Thothadri

[Former Member]

Hi ravi

This is the data i have in my actual cube. Only 22 records

CCODE CCENTER CALMONTH YEAR BAREA SORG SOFF DIV PRODUCT PRDGRP CUSTOMER CTRY SALESAMT CURRCY CAMT QTY UOM

20 CC1 Jan-06 2006 BA1 20 SO1 D1 CK2000 CK C1 US 10000 USD 6000 4 EA

20 CC1 Feb-06 2006 BA1 20 SO2 D1 CK2001 CK C1 US 15000 USD 12000 5 EA

20 CC1 Feb-06 2006 BA1 20 SO3 D1 CK2002 CK C1 US 20000 USD 18000 2 EA

20 CC2 Apr-06 2006 BA2 20 SO4 D2 CK7000 CK C1 US 25000 USD 24000 10 EA

20 CC2 Dec-06 2006 BA2 20 SO5 D2 CK7000 CK C1 US 30000 USD 30000 5 EA

20 CC2 Mar-06 2006 BA2 20 SO6 D2 CK7000 CK C1 US 35000 USD 36000 3 EA

20 CC1 Mar-06 2006 BA1 20 SO7 D1 CK2000 CK C2 US 40000 USD 42000 6 EA

20 CC1 Jan-06 2006 BA1 20 SO8 D1 CK2001 CK C2 US 45000 USD 48000 10 EA

20 CC1 Feb-06 2006 BA1 20 SO9 D1 CK2002 CK C2 US 50000 USD 54000 4 EA

20 CC2 Feb-06 2006 BA2 20 SO10 D2 CK7000 CK C2 US 55000 USD 60000 5 EA

20 CC2 Apr-06 2006 BA2 20 SO11 D2 CK7000 CK C2 US 60000 USD 66000 10 EA

20 CC2 Dec-06 2006 BA2 20 SO12 D2 CK7000 CK C2 US 65000 USD 72000 4 EA

20 CC1 Mar-06 2006 BA1 20 SO13 D1 CK2000 CK C1 US 70000 USD 78000 5 EA

20 CC1 Mar-06 2006 BA1 20 SO14 D1 CK2001 CK C1 US 75000 USD 84000 2 EA

20 CC1 Jan-06 2006 BA1 20 SO15 D1 CK2002 CK C1 US 80000 USD 90000 10 EA

20 CC2 Feb-06 2006 BA2 20 SO16 D2 CK7000 CK C1 US 85000 USD 96000 5 EA

20 CC2 Feb-06 2006 BA2 20 SO17 D2 CK7000 CK C1 US 90000 USD 102000 3 EA

20 CC2 Apr-06 2006 BA2 20 SO18 D2 CK7000 CK C1 US 95000 USD 108000 6 EA

20 CC1 Dec-06 2006 BA1 20 SO19 D1 CK2000 CK C2 US 100000 USD 114000 10 EA

20 CC1 Mar-06 2006 BA1 20 SO20 D1 CK2001 CK C2 US 105000 USD 120000 4 EA

20 CC1 Mar-06 2006 BA1 20 SO21 D1 CK2002 CK C2 US 110000 USD 126000 5 EA

20 CC2 Jan-06 2006 BA2 20 SO22 D2 CK7000 CK C2 US 115000 USD 132000 10 EA

[Former Member]

If you copy function got executed, then you will see the data .

In your case, there may be issues with your aggregation levels and also the function and the parameter set.

May I know what you have in them?

Ravi Thothadri

[Former Member]

These are the Characteristics and Key Figures i am using in Cube....

Actual Cube

Company code 0COMP_CODE

Controlling area 0CO_AREA

Cost Center 0COSTCENTER

Business area 0BUS_AREA

Sales Organization 0SALESORG

Sales Office 0SALES_OFF

Distribution Channel 0DISTR_CHAN

Division 0DIVISION

Value Type for Reporting 0VTYPE

Version 0VERSION

Material 0MATERIAL

Material group 0MATL_GROUP

Customer number 0customer

Country key 0COUNTRY

KeyFigures:

Cost Amt-GC ZCTAMT_GC

Sales amt - GC ZSLAMT_GC

Sales quantity (SAP DEMO) 0D_QTY QUAN

Realtime Cube

Company code 0COMP_CODE

Controlling area 0CO_AREA

Cost Center 0COSTCENTER

Business area 0BUS_AREA

Sales Organization 0SALESORG

Sales Office 0SALES_OFF

Distribution Channel 0DISTR_CHAN

Division 0DIVISION

Value Type for Reporting 0VTYPE

Version 0VERSION

Material 0MATERIAL

Material group 0MATL_GROUP

Customer number 0customer

Responsible Person ZRES_PERS

Country key 0COUNTRY

KeyFigures:

Cost Amt-GC ZCTAMT_GC

Sales amt - GC ZSLAMT_GC

Sales quantity (SAP DEMO) 0D_QTY QUAN

I have a multiprovider on top of these cubes....

In the Aggreagation Level i have all the Characteristics and Key Figures in the multiprovider.

In Filter i have included...

Company Code= 20, Calender Year = 2007, Value Type =20, Plan Version = 1, InfoProvider = SalesPlan

Created Copy Planning Function:

From change: Version = 0, Calender Year = 2006, Calender Year/ Month = January 2006, Infoprovider = sales actual, and value type for reporting = 10

To Change:

Version = 1, Calender Year = 2007, Calender Year/ Month = January 2007, Infoprovider = sales plan, and value type for reporting = 20

In my Input enable query :

Filter:

Company Code = 20

Sales Office = SO1

Country = US

Controlling Area = 1000

Distribution Channel = 70

Infoprovider = Sales Plan

Value Type = 20

Version = Plan Version

Currency= USD

Sales Unit = EA

Sales Organization = 20

Rows

Material Group

Calender Year / Month

material

Division

Business Area

Cost Center

Customer

Columns

Quantity

Sales amt - GC

Cost amt - GC

Please suggest me the mistake or let me know if you need more info

Edited by: Aditya on Dec 21, 2007 9:47 AM

[Former Member]

I have created a COPY button in my work book

Name Ind Value

CMD 0 Execute_Planning_function

Data_provider_filter 0 data_provider_1

Planning_function_name 0 <Planning_Function> (here i selected my copy planning funciton)

So when i click this copy button do i see the result? How does the users enter the plan data.....?

If i remove Data_provider_filter 0 data_provider_1 from the button static parameters then

22 records read, 0 generated, 0 changed, 0 deleted

If my button has that data_provider_1 then it reads 0 records?

Edited by: Aditya on Dec 21, 2007 9:13 AM

[former_member183777]

The query needs to include all the characteristics of Aggregate/filter and meet the filter criteria. Also create key figure selections using InfoProvider as a restriction.

Thanks

Vineet