BPC Data Package Link error "Time Version of dimension does not exist"

[former_member201314]

Hi guys,

interesting phenomenon we are experiencing:

Maybe anyone has a clue in respect to the root cause?

Many thanks in advance!

Upfront:

We are running BPC 10.0 for Netweaver, SP03; on BW 7.3 SP 9

EPM Addin for Microsoft Office Version 10.0, SP 20 Patch 1 .NET 4 (build 9042)

Running a Data Manager Package for a Flat File Upload into a dimension type E (ENTITY) finished successfully,

whereas running a Data Package Link with exactly the same DMP and identical parameters (File, Transformation File, Target Dimension) fails with the error "Time Version of Dimension <xyz> does not exist" (note that <xyz> is the place holder for the Target Dimension to be loaded).

Does anyone have an idea what the problem might be?

With kind regards

Claus

[former_member229290 · Accepted solution]

Hi Claus,

The cause of your issue may be related to the fact that the DM package 'Import Master Data Attrib and Hier Flat File' which triggers the process chain '/CPMB/IMPORT_MASTER' is missing some

parameters (package instructions).

Please have a look at SAP Note 2157451 - Time version of dimension <Dimension_Name> does not
exist .

Best Regards,

Noura

[former_member201314]

Thanks Vadim!

[former_member182709]

Claus, It's a known issue. It's solved by applying note 1804957.

However, it looks like you are on BPC 801 SP03. And this note should included on your system.

If this is the case, please do the steps below.

You should be able to solve this issue.

1. Go to transaction SE38.

2. Run program UJS_ACTIVATE_CONTENT.. Only check 'Update Default DM Instructions' and leave all others default.

4. Execute

Charlie

[former_member182709]

This message was moderated.

[Former Member]

Hi Claus,

List all the DMP you linked in your package link?

Maybe one of the other package gives the error.

Not the entity one.

Andy

[former_member186338]

Hi Claus,

Unfortunately: BPC 10.0 for Netweaver, SP03; on BW 7.3 SP 9 is too old!

Can't help you...

Vadim

[former_member201314]

Thanks anyway, Vadim!

BTW - it is BW 7.31 SP 9, but I guess it won't make a dfifference...

[former_member186338]

Not a big difference... I suspect that EPM SP20 may be incompatible with this old core BPC...

Anyway, upgrade is required!

[former_member186338]

Try (from http://service.sap.com/sap/support/notes/1804957😞

1. Goto transaction SE38.

2. Run program UJS_ACTIVATE_CONTENT.

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

4. Execute.

[former_member201314]

Hi Vadim,

I've raised the issue with SAP since the problem persisted even after upgrading to BW 7.4 / BPC 10.0 Release 801 SP 12.

The guys from SAP suggested tio add the two INFO commands in RED to our initial DMP script below.

That resolved the issue.

Cheers

Claus

PROMPT(HIERARCHYSELECTION, %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%,0)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%TEMPNO2%,%INCREASENO%)

INFO(%TEMPNO3%,%INCREASENO%)

INFO(%DIMNAME_DATEFROM%,)

INFO(%DIMNAME_KEYDATE%,)

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

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

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

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

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,FORMULA_FILE_NO,%TEMPNO2%)

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

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

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

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

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

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

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

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,KEYDATE,%DIMNAME_KEYDATE%)

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

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

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

TASK(/CPMB/BPC_HIER_DATA_TARGET,FORMULA_FILE_NO,%TEMPNO2%)

TASK(/CPMB/BPC_HIER_DATA_TARGET,DATEFROM,%DIMNAME_DATEFROM%)

TASK(/CPMB/BPC_HIER_DATA_TARGET,KEYDATE,%DIMNAME_KEYDATE%)

[former_member201314]

fyi - we've tried that, too. However, the two info commands were not added. Hence must be buggy...

[former_member186338]

Hi Claus,

The correct script has to look like:

PROMPT(HIERARCHYSELECTION, %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%,0)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%TEMPNO2%,%INCREASENO%)

INFO(%TEMPNO3%,%INCREASENO%)

INFO(%DIMNAME_DATEFROM%,)

INFO(%DIMNAME_KEYDATE%,)

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

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

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

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

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,FORMULA_FILE_NO,%TEMPNO2%)

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

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

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

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

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

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

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

TASK(/CPMB/IOBJ_SOURCE_HD_CONVERT,KEYDATE,%DIMNAME_KEYDATE%)

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

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

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

TASK(/CPMB/BPC_HIER_DATA_TARGET,FORMULA_FILE_NO,%TEMPNO2%)

TASK(/CPMB/BPC_HIER_DATA_TARGET,DATEFROM,%DIMNAME_DATEFROM%)

TASK(/CPMB/BPC_HIER_DATA_TARGET,KEYDATE,%DIMNAME_KEYDATE%)

Try to create a new DM package with /CPMB/IMPORT_IOBJ_HIER chain! Look on the default script generated! After "Update Default DM Instructions" the "INFO(%DIMNAME_DATEFROM%,)" etc... has to be present in the script.

Vadim

[former_member186338]

P.S. Also use UJS_ACTIVATE_CONTENT with Activate BI Business Content or simply manually add:

In transaction RSPC

Vadim