running a bpc package from a custom bw chain

[michele_medaglia5]

Hi BPC Friends

I have a custom process chain that run the standard bpc package for loading master data by a abap variant specifying the parameter for selection (in particular the two hierarchies for 0COSTELMNT) that we load to run in BPC

Because now I want to load two new hierarchies I thought to change this variant

The new hierarchies are 27fr00fr and 27fr001xnbs

%INFOOBJECT% = 0COSTELMNT

%SELECTION% = <?xml version="1.0" encoding="utf-16"?><Selections xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Selection Type="Hierarchy" ImportText="0"><Hierarchy><ID>4JSEYX8HNLU7KW5WQ0F4B6ZB7</ID><MemberID /><Level /><HierName>27FR00IT1</HierName><Version /><DateTo>9999-12-31</DateTo></Hierarchy><Hierarchy><ID>4P3A03XMVKY4JUJ5GPNL1DIDD</ID><MemberID /><Level /><HierName>27FR00IMR_COSTE</HierName><Version /><DateTo>9999-12-31</DateTo></Hierarchy><Hierarchy><ID>4JSE18003T1QK61H85LAB23WG</ID><MemberID /><Level /><HierName>27FR00FR</HierName><Version /><DateTo>9999-12-31</DateTo></Hierarchy><Hierarchy><ID>PCINW2A61W8M7GR6NDG4MZC66</ID><MemberID /><Level /><HierName>27FR001XNBS</HierName><Version /><DateTo>9999-12-31</DateTo></Hierarchy></Selection><KeyDate>20141023</KeyDate></Selections>

but I got this error in BPC

Task name MASTER DATA SOURCE:

An exception with the type CX_XSLT_RUNTIME_ERROR occurred, but was neither handled locally, nor declared in a RAISING clause

No valid source context supplied

model: COSTS. Package status: ERROR

Could you please help me to understand what I should do?

Thanks

Michele

[michele_medaglia5 · Accepted solution]

these are the additional images

[Former Member · Accepted solution]

Have you tried to execute the package from EPM Add-In for the new hierarchy? If it does not fail then take the answered prompt from the log file in UJFS t-code. Hope this helps, Jorge.

[michele_medaglia5 · Accepted solution]

HI BPC Friend

I found the solution to load the new hierarchies:

I have prepared a txt file with the following code

%INFOOBJECT%

0COSTELMNT

%SELECTION%

<?xml version="1.0" encoding="utf-16"?><Selections xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Selection Type="Hierarchy" ImportText="0"><Hierarchy><ID>4P3A03XMVKY4JUJ5GPNL1DIDD</ID><MemberID>27FR00IMR_COSTE</MemberID><Level /><HierName>27FR00IMR_COSTE</HierName><Version /><DateTo>9999-12-31</DateTo></Hierarchy><Hierarchy><ID>4JSEYX8HNLU7KW5WQ0F4B6ZB7</ID><MemberID>27FR00IT1</MemberID><Level /><HierName>27FR00IT1</HierName><Version /><DateTo>9999-12-31</DateTo></Hierarchy><Hierarchy><ID>4JSE18003T1QK61H85LAB23WG</ID><MemberID>27FR00FR</MemberID><Level /><HierName>27FR00FR</HierName><Version /><DateTo>9999-12-31</DateTo></Hierarchy><Hierarchy><ID>PCINW2A61W8M7GR6NDG4MZC66</ID><MemberID>27FR001XNBS</MemberID><Level /><HierName>27FR001XNBS</HierName><Version /><DateTo>9999-12-31</DateTo></Hierarchy></Selection><KeyDate>20140513</KeyDate></Selections>

[Former Member · Accepted solution]

Hi Michele,

You could also manually execute the first hierarchy upload - then once that is successful go back into the STATUS view of the DM package, cut/paste the selection string from that view - you would get the same as your text file but to your point, that looks great.

Thanks, Pete

[michele_medaglia5 · Accepted solution]

Hi Pete

I thought the same and I lost a lot of time because the code isn't exactly the same

[Former Member · Accepted solution]

Hi Michele,

Agreed that it's not exactly the same - in my BPC v10.0 book I show you exactly what additional symbols (# and %) you need to add to this or adjust (such as using a TAB versus an = ) in the sript. then cut/paste that final version of the code into your answer prompt - I'm using it now at my current project.

If you would like I can send you the word document with all of the minor tweaks you need to do for that approach to work.

Thanks, Pete

[michele_medaglia5 · Accepted solution]

yes please send me the document