while Running Data Manager package getting package status is Warning

[former_member307359]

Hi Expert,

While I'm running data manager package in excel I'm getting an warning message. How to avoid this warning message. Or is this an standard warning message if dimension take All base members.

Data Region:

[WARNING!] NO MEMBER SPECIFIED FOR DIMENSION:TEST_ACCOUNT WILL QUERY ON ALL BASE MEMBERS.

[WARNING!] NO MEMBER SPECIFIED FOR DIMENSION:TEST_CURRENCY WILL QUERY ON ALL BASE MEMBERS.

[WARNING!] NO MEMBER SPECIFIED FOR DIMENSION:TEST_DATASOURCE WILL QUERY ON ALL BASE MEMBERS.

[WARNING!] NO MEMBER SPECIFIED FOR DIMENSION:TEST_MATERIAL WILL QUERY ON ALL BASE MEMBERS.

[WARNING!] NO MEMBER SPECIFIED FOR DIMENSION:TEST_PRODUCT WILL QUERY ON ALL BASE MEMBERS.

[WARNING!] NO MEMBER SPECIFIED FOR DIMENSION:TEST_SUPPLIER WILL QUERY ON ALL BASE MEMBERS.

[WARNING!] NO MEMBER SPECIFIED FOR DIMENSION:TEST_UNIT WILL QUERY ON ALL BASE MEMBERS.

[WARNING!] MEASURES IS NOT SPECIFIED!

TEST_CATEGORY:ANNUAL_2015_16

TEST_DESTINATION:10_N

TEST_TIME:2015.01,2015.02,2015.03,2015.04,2015.05,2015.06,2015.07,2015.08,2015.09,2015.10,2015.11,2015.12

TEST_ACCOUNT:[All base members]

TEST_CURRENCY:[All base members]

TEST_DATASOURCE:[All base members]

TEST_MATERIAL:[All base members]

TEST_PRODUCT:[All base members]

TEST_SUPPLIER:[All base members]

TEST_UNIT:[All base members]

kindly help me to resolve this issue.

Regards

Vimal Raj

[bhagyesh_ravange · Accepted solution]

Hello Vimal,

This is just the warning and occurs wherein you have not selected members for the above Dimension while executing the Data manager Package. Hence while executing package it selects all the base members where you have not given any selection.

Regards

Bhagyesh Ravange

[former_member307359 · Accepted solution]

Hi Bhagyesh Ravange,

My package status is showing as Warning

[former_member307359 · Accepted solution]

[bhagyesh_ravange · Accepted solution]

Hello Vimal,

Can you share the log of same..

Regards

Bhagyesh Ravange

[former_member307359 · Accepted solution]

Hi Bhagyesh Ravange,

Here i attach my log file

[bhagyesh_ravange · Accepted solution]

Hello Vimal,

Does your TEST_CATEGORY Dimension contains ANNUAL_2015_16 member? Please check the same and let me know.

Regards

Bhagyesh Ravange

[former_member307359 · Accepted solution]

YES ITS THERE

[bhagyesh_ravange · Accepted solution]

Hello Vimal,

If you look at your LOG of 10 Rejected records then you will find that, your last rejected record doesn't contain member for TEST_CATEGORY, TEST_CURRENCY, TEST_DATASOURCE, TEST_SUPPLIER, TEST_TIME, TEST_UNIT & TEST_VERSION. Hence, it is throwing INVALID MEMBER ERROR

Also your first 9 rejected records are DUPLICATE and hence while executing BADI it is throwing as Duplicate records error.

Further can you tell me whether you have run Light optimizion package or you have done Light optimizion.

Regards

Bhagyesh Ravange

[former_member307359 · Accepted solution]

Hi Bhagyesh Ravange,

How to identity the package, Whether its an Run Light Optimization or Done Light Optimization, Please help me, I'm new to this module

regards

Vimal Raj

[bhagyesh_ravange · Accepted solution]

Hello Vimal,

In package status you are getting warning message because your 10 records are rejected as shown in the LOG.

Also PFA screenshot where from where you can do optimization. Have you done this ever.

Regards

Bhagyesh Ravange

[bhagyesh_ravange · Accepted solution]

Hello Vimal,

Please Debug your BADI and see what is the source of error for this 10 rejected records.

Regards

Bhagyesh Ravange

[former_member307359 · Accepted solution]

Hi Bhagyesh Ravange,

Here the Optimization type is Light Optimization, Now going to debug on it, once i complete my debugging, i will inform to you.

Regards

Vimal Raj

[former_member307359 · Accepted solution]

Hi,

While I'm debugging in UJKT getting an dump error.

*START_BADI ZBOT_EST_01

WRITE = ON

TEST_TIME = 2015.08,2015.09,2015.10,2015.11,2015.12

TEST_CATEGORY = ANNUAL_2015_16

TEST_VERSION = VD

TEST_DESTINATION = 10_N

*END_BADI

[bhagyesh_ravange · Accepted solution]

Hello Vimal,

Check with your ABAP consultant, Your BADI is throwing error because your result is exceeding the maximum character limit.

Regards

Bhagyesh Ravange

[former_member307359]

Thanks for your valuable guidance and inputs, this issue has been closed.

[former_member186498]

Hi Vimal,

maybe you need to check your CT DATA or badi, see please note 1743731.

Regards

     Roberto

[Former Member]

Hi Vimal,

For script logic look at below link

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e025fa8d-1c22-2e10-cd9f-c488c7eea...

Regards,

Sushant

[former_member307359]

Hi Sushant Patil,

This is my script logic, here i didn't face any problem, please check it

*XDIM_MEMBERSET TEST_TIME AS %TIM% = %TEST_TIME_SET%

*XDIM_MEMBERSET TEST_CATEGORY AS %CAT% = %TEST_CATEGORY_SET%

*XDIM_MEMBERSET TEST_VERSION AS %VER% = %TEST_VERSION_SET%

*XDIM_MEMBERSET TEST_DESTINATION AS %DEST% = %TEST_DESTINATION_SET%

*START_BADI ZBOT_EST_01

WRITE = ON

TEST_TIME = %TIM%

TEST_CATEGORY = %CAT%

TEST_VERSION = %VER%

TEST_DESTINATION = %DEST%

*END_BADI

[Former Member]

Hi Vimal,

I don't know too much about ABAP why you getting error in the UJKT you can consult with your ABAP team, but you are getting warning messages while running Data Manager Package due to your BAdi is working on the all members of the dimension.You have to pass the scope to BAdi so it will work on the specified members not on the all members. In my last project i was facing same warning message. In my last project we had done something like this.

*SELECT (%Q%,[ID],TIME,[QTR_INPUT]=X)

*XDIM_MEMBERSET ACCOUNT= ACCT002,ACCT003,ACCT004

*XDIM_MEMBERSET AUDITTRAIL= Input

*XDIM_MEMBERSET TIME =%TIME_SET%,%Q%

*XDIM_ADDMEMBERSET TIME = TMVL(1,%TIME_SET%),TMVL(2,%TIME_SET%),TMVL(3,%TIME_SET%),TMVL(4,%TIME_SET%)

*START_BADI ZABC

WRITE = ON

QUERY = ON

CATEGORY = %CATEGORY_SET%

TIME= %TIME_SET%

*END BADI

Regards,

Sushant.

[Former Member]

Hi Vimal Raj,

You can do scoping as shown below

*XDIM_MEMBERSET Category= ACTUAL

*XDIM_MEMBERSET C_CONSOLVIEW= LC

*XDIM_MEMBERSET C_DATASOURCE= Input

*XDIM_MEMBERSET Entity = Japan

*XDIM_MEMBERSET Movement= F_LOAD

*XDIM_MEMBERSET Scopes= S_None

*XDIM_MEMBERSET Intco= ThirdParty

*XDIM_MEMBERSET ProdLine= C100

Regards,

Sushant

[Former Member]

Hi Vimal Raj,

Please confirm which package you are running? Is it standard package or custom package?

[WARNING!] NO MEMBER SPECIFIED FOR DIMENSION:TEST_ACCOUNT WILL QUERY ON ALL BASE MEMBERS.

If you are trying to run script logic through Data Manager packages then warning message are due to the error in the script(not exactly error)  problem is in the your script.

your Script is running on all members of the dimension.If you want to avoid warning then do scoping in the script.

You can do scoping using *XDIM_MEMBERSET.

*XDIM_MEMBERSET TEST_DATASOURCE = Input

Then script will run only for the Input datasource. So likewise restrict your script, 

Regards,

Sushant