BPC 10: DM - Time version of dimension XXXXX does not exist

[former_member591016]

Hi Experts,

I am trying to upload master data hierarchy through flat file.My Transformation file is  getting validated properly, While running the package to upload master data from flat file I am getting error TIME VERSION OF DIMENSION CUSTOMER DOES NOT EXIST.

Problem is coming in production server only, it was not coming in development server. Snap shots of my transformation file, flat file and error coming is attached.

Kindly Guide me through this.

Thanks and Regards

Rakhi

[former_member186338 · Accepted solution]

Hi Rakhi,

Have you enabled Time-dependent Hierarchy option for CUSTOMER dimension?

B.R. Vadim

[former_member591016 · Accepted solution]

Hi Vadim,

Thanks for reply.

I am not maintaining time dependent hierarchy, Do i still need to enable time dependent hierarchy option?

Thanks

Rakhi

[former_member186338 · Accepted solution]

No you don't! But may be it's already enabled?

[former_member591016 · Accepted solution]

How can I disable it?

[former_member591016 · Accepted solution]

Its not enabled. Hierachy not time dependent is enabled.

[former_member186338 · Accepted solution]

BPC SP version?

[former_member186338 · Accepted solution]

Look on the following notes:

http://service.sap.com/sap/support/notes/1817729

http://service.sap.com/sap/support/notes/1804957

Vadim

Message was edited by: Vadim Kalinin corrected second note!

[Former Member · Accepted solution]

The note is not applicable.

We are using Business Planning and Consolidation on NetWeaver 731(Component CPMBPC 801) on SP04

Regards,

Juan Antonio

[former_member186338 · Accepted solution]

Not sure that you have correct advanced DM script for import master data. I don't see KEYDATE in the selection part of your error.png

Please post it here!

The note is about this script.

Vadim

[former_member591016 · Accepted solution]

Hi Vadim,

We are using CPMBPC Release 800 SP=Level 4.

Thanks

Rakhi

[former_member186338 · Accepted solution]

On BW 7.30? The current is SP12...

Version of EPM?

[former_member591016 · Accepted solution]

NW VERSION 7.31 SP LEVEL 8

EPM VERSION 10.0 SP 8 .NET

[former_member186338 · Accepted solution]

If you are on NW 7.31 then "We are using CPMBPC Release 800 SP=Level 4" is incorrect, you are using CPMBPC Release 801. SP04 is OK!

Please, upgrade EPM version to the current SP 16.

And post the DM advanced script!!!!

[former_member591016 · Accepted solution]

Thanks Vadim for your support,

I upgraded my EPM SP LEVEL to 14 and applied following solution as suggested by SAP.

If your BPC version is upgraded to 801 SP04, not installed directly.

It's necessary to do the following.

1. Goto transaction SE38.

2. Run program UJS_ACTIVATE_CONTENT.

3. Only check 'Update Default DM Instructions' and leave all others

default.

4. Execute.

Now this issue is resolved.

But another error is coming now which was not coming earlier:

While running the package for master data upload from BW Info-object, now an option is coming-"CLEAR ALL MEMBERS FOR  OVERWRITE MODE BEFORE LOADING", this was not coming earlier.  My package is getting failed with details "can not configure CLEAR ALL MEMBERS task". Previously same master data was getting uploaded successfully.

Thanks

Rakhi

[former_member186338 · Accepted solution]

"and applied following solution as suggested by SAP ..." - that was clearly stated in the note 1804957 that I recommended you to read. Manual Post-Implement - means that the result is not coming automatically after note installation or upgrade to new SP.

What package are you exactly running? Provide the name and DM advanced script! Do you know how to view the script?

Vadim

[former_member591016 · Accepted solution]

Hi Vadim,

I am using Package /CPMB/IMPORT_IOBJ_MASTER

Advanced script is:

PROMPT(MASTERSELECTION, %INFOOBJECT%, %SELECTION%, "Please select the infoobject and the selection",,)

PROMPT(RADIOBUTTON,%WRITEMODE%,"Write Mode",2,{"Overwrite","Update"},{"1","2"})

PROMPT(RADIOBUTTON,%FORMAT%,"Choose format.",1,{"Internal Format","External Format"},{"1","0"})

PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

PROMPT(DIMENSIONNAME,%DIMNAME%,"Dimension name:",,,%DIMS%)

PROMPT(RADIOBUTTON,%CLEAR_ALL%,"Clear all members for overwrite mode before loading?",0,{"No","Yes"},{"0","1"})

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%TEMPNO2%,%INCREASENO%)

INFO(%TEMPNO3%,%INCREASENO%)

INFO(%TEMPNO4%,%INCREASENO%)

INFO(%TEMPNO5%,%INCREASENO%)

INFO(%TEMPNO6%,%INCREASENO%)

INFO(%TEMPNO7%,%INCREASENO%)

TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,MASTERDATA_SELECTION,%SELECTION%)

TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,INFOOBJECT,%INFOOBJECT%)

TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,MASTERDATA_FORMAT,%FORMAT%)

TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,OUTPUTNO,%TEMPNO2%)

TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,MASTERDATA_SELECTION,%SELECTION%)

TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,INFOOBJECT,%INFOOBJECT%)

TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,MASTERDATA_FORMAT,%FORMAT%)

TASK(/CPMB/MERGE_IOBJ_MD_DATA,INPUTNO,%TEMPNO1%)

TASK(/CPMB/MERGE_IOBJ_MD_DATA,INPUTNO2,%TEMPNO2%)

TASK(/CPMB/MERGE_IOBJ_MD_DATA,MASTERDATA_SELECTION,%SELECTION%)

TASK(/CPMB/MERGE_IOBJ_MD_DATA,INFOOBJECT,%INFOOBJECT%)

TASK(/CPMB/MERGE_IOBJ_MD_DATA,OUTPUTNO,%TEMPNO3%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,FORMULA_FILE_NO,%TEMPNO7%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,SUSER,%USER%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,SAPP,%APP%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,DIMNAME,%DIMNAME%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,OUTPUTNO,%TEMPNO4%)

TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,INPUTNO,%TEMPNO4%)

TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,OUTPUTNO,%TEMPNO5%)

TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,OUTPUTNO2,%TEMPNO6%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,INPUTNO,%TEMPNO3%)

TASK(/CPMB/BPC_MASTER_DATA_TARGET,INPUTNO,%TEMPNO5%)

TASK(/CPMB/BPC_MASTER_DATA_TARGET,DIMNAME,%DIMNAME%)

TASK(/CPMB/BPC_MASTER_DATA_TARGET,WRITEMODE,%WRITEMODE%)

TASK(/CPMB/BPC_MASTER_DATA_TARGET,FORMULA_FILE_NO,%TEMPNO7%)

TASK(/CPMB/BPC_MASTER_DATA_TARGET,CLEAR_ALL,%CLEAR_ALL%)

TASK(/CPMB/BPC_TXT_DATA_TARGET,INPUTNO,%TEMPNO6%)

TASK(/CPMB/BPC_TXT_DATA_TARGET,DIMNAME,%DIMNAME%)

It is showing- Package Status:Runnig

Thanks

Rakhi

[former_member186338 · Accepted solution]

Please read this note:

http://service.sap.com/sap/support/notes/1868007

Vadim

[former_member186338 · Accepted solution]

Here:

2. Run transaction RSPC.

3. Change process chain BPC: Import Master Data Attributes/Texts from BW InfoObject /CPMB/IMPORT_IOBJ_MASTER

4. Change step BPC: BPC master data target /CPMB/BPC_MASTER_DATA_TARGET

5. Add one field CLEAR_ALL

6. Save.

Vadim

[former_member591016 · Accepted solution]

Hi Vadim,

I deleted two lines from advanced Script of Package:

PROMPT(RADIOBUTTON,%CLEAR_ALL%,"Clear all members for overwrite mode before loading?",0,{"No","Yes"},{"0","1"})

TASK(/CPMB/BPC_MASTER_DATA_TARGET,CLEAR_ALL,%CLEAR_ALL%)

And now package is running successfully.

Thanks a Lot for your guidance

Rakhi

[former_member186338 · Accepted solution]

Incorrect! You will have issues with future upgrades!

The correct procedure is to add CLEAR_ALL to the BPC_MASTER_DATA_TARGET step.

Vadim

[former_member591016 · Accepted solution]

I followed the procedure described by you and added Field CLEAR_ALL to the BPC_MASTER_DATA_TARGET step.

And package is running successfully now.

Thanks again

Rakhi

[former_member186338 · Accepted solution]

Fine!

It looks like that some SP03/04 postimplentaion steps were not completed in time. Now you manually completed 2 steps: Update Default DM Instructions and add CLEAR_ALL.

You may close the topic.

[gorka_iborurea]

Hi,

please see this: http://scn.sap.com/thread/3300039

I have had this problem before and it was solve with that:

Hi,

This is error is due to a bug in the system.  apply the SAP Note # 1804957The basis team has to apply the note and then do post implementation steps as described in the note. Then you should be good.

The hierarchy loading is working for me now.

Prabhakar

[former_member591016]

Hi Prabhakar,

Thanks for reply.

This note is not applicable on patch level I am working on.

Thanks

Rakhi

[Former Member]

Hi Rakhi,

I have exactly the same problem. Does anyone find the solution to this issue ?

Regards,

Juan Antonio