Skip to Content
author's profile photo Former Member
Former Member

Error running SPRUNCALCACCOUNT

Hi,

We have recently received an error on an account-based calculation that used to work. Our problem is, we cannot identifiy the change happened that may have caused the error.

We're running an SPRUNCALCACCOUNT, where we use properties to extract accounts, flow and datasource and we use the parameter Apply YTD.

If we run the package its running with success, but do not aggregate a specific data source.

If I the try to hardcode the datasource in the account-based calcultaions to the datasource not aggregating, the package return an error:

Execute formulasError

SPRunCalcAccount Version 10.0.12.0

*ERROR* CALC-030 No TIME Extract

I haven't been able to sort this out. Theres a thread saying I need to add %TIME_SET% to SPRUNCALCACCOUNT, but then the calculation is not running.

Any ideas?

BR,

Lars

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jun 11, 2014 at 07:42 AM

    Hi Lars,

    can you please share also the Time dimension?

    Thanks

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 11, 2014 at 07:08 AM

    Hi Lars,

    could you please post the script you use to run the SPRUNCALCACCOUNT and the details of the business rule itself. Have you made any changes to the time dimension recently?

    Also, if you are sayin the package runs but does not aggregate data on a specific datasource, does it work for other datasources? If yes, in the dimension member sheet, what is the difference between a datasource for which it works and the one for which it does not?

    BR,
    Arnold

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.