Skip to Content
0

Error reading data from S_NONE when running consolidation in BPC 10.1 MS

Nov 17, 2016 at 03:28 PM

82

avatar image

Hi All,

I have a question around how the consolidation program SPRUNCONSO works with the GROUP dimension.

My understanding of consolidation comes from working with BPC on NW, where all unconsolidated data gets posted against a member such as "S_NONE" which corresponds to "No scope" or "No consol group".

In NW, when running the consolidation program, the transaction data gets read from S_NONE, either translated or copied to the consolidation group selected (depending on FX translation config), and consolidated in that group.

However, when I try to do this in BPC on MS I get the error:

  • E, CSD-130 Nothing extract from the Fact with consolidation rules - check your souce account
  • E, CSD-135 Nothing extract from the Fact with entity defined in ownership hierachy
  • E, CSD-140 Nothing extract from the Fact with entity and interco calculation
  • E, CSD-150 Nothing extract from the Fact with account and entity/interco pair in the ownership and elimination rules
  • E, CSD-160 Nothing extracting Data : C_CONSO

My understanding is that this error essentially means "there is no data to read from the source %SCOPETABLE%".

When I manually run a Copy package to move data from S_NONE to one of the consolidation groups first, and then run consolidation, the program executes all eliminations as expected.

My question is: is this expected behaviour? Is it expected for BPC on MS to be configured such that data is read directly from each consolidation group?

Or have I missed a step to allow for the stored procedure to begin with S_NONE?

Other information:

  • All required data and properties are present and configured in the Consolidation Model and the Ownership Model, entities are assigned, rules and multipliers set up as standard etc.
  • I am loading data in reporting currency USD in S_NONE, and have USD set as the group currency for each consolidation group.
  • I have each audit trail configured IS_CONVERTED = G and the relevant members IS_CONSOL = Y.
  • This is on BPC MS 10.1 SP05.
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Pilsoon Jang
Nov 22, 2016 at 01:15 AM
0

Hello,

In BPC MS, if IS_CONVERTED=G, engine does not translate but just copy the data.
Therefore, if you want to translate the data, the value of IS_CONVERTED should be 'Y'.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks for your comment Pilsoon.

IS_CONVERTED = G is deliberate. Indeed, we do not require any FX conversion in this instance, as all figures are being loaded in the group currency already, as explained.

0
Pilsoon Jang
Nov 22, 2016 at 01:25 AM
0

For the screenshot of all our Ownership model packages failing, I think you need to check the log message
'Object reference not set to an instance of an object.' at the bottom of the message.

I think your installation is not successful and therfore some component was not registerd correctly.
I would like suggest you that reinstall the BPC MS or raise the ticket to check in detail.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Pilsoon,

We considered this possibility as well, but if the installation was not registered correctly I would expect *all* pacakges to be failing, not just those specific to one particular program or model.

We would like to know for sure if a component is not working before suggesting a reinstall, which would be more significant impact for the client. If there is anything which would rule out other problems or determine for certain the root cause, that would give us the required evidence to suggest this but so far this is not the case.

0
Pilsoon Jang
Nov 24, 2016 at 05:00 AM
0

Hello Elliott,

Only for the Consolidation, none of the 'S_NONE' data won't move to what your intention. Only Group scope data will be moved by the Consolidation business rule.

For the error message of 'Object reference not set to an instance of an object.' we could not say the general cases or reason because it is not normal. So I would like to ask you to take a step to request SAP OSS to verify your system with our SAP specialist

Thank you

Best Regards,

Share
10 |10000 characters needed characters left characters exceeded