Problem in consolidation: FX-280
In our BPC setup were are using multiple categories to book data on. For easy consolidation (for the end-users) I have created some logic which runs the conversion and actual consolidation for all categories marked with a specfic property. The problem is now that when a category does not contain a proper dataset the logic exits with the error show below. To create an if statement to check for data is quite difficult as all entities in the consolidation group will have to be checked... So,
1) Is there some way the logic can continue when a single conversion shows an error?
2) Which data is minimally required to make a conversion work properly, might it be a solution to create a dummy record (not preferable)?
++Executing SPRUNCONVERSIONOPE [FINANCE],[FCPART_NSP],[GM_BU_INT_PROP],[GLOBAL],[SPSCOPE_142386],[SPLOG_257606]++ ++SPRunConversion Version 2.05++ ++*ERROR* FX-280 Timeid=20080900 - Nothing Extract from Fact Tables++
My current logic is:
*SELECT(%CAT_SET%,"[ID]","CATEGORY","[RUN_CONSO]='P'") *FOR %CAT%=%CAT_SET% //Run the currency conversion *RUN_STORED_PROCEDURE = SPRUNCONVERSIONOPE([%APP%],[%CAT%],[% GROUPS_SET%], [GLOBAL],[%SCOPETABLE%],[%LOGTABLE%]) *commit //Run the Consolidation *RUN_STORED_PROCEDURE = SPRUNCONSO([%APP%],[%CAT%],[%GROUPS_SET%],[% SCOPETABLE%],[%logtable%]) *commit *NEXT