topic Re: ABM - rule based driver treat of zero cost in SAS Visual Analytics

ABM - rule based driver treat of zero cost

MarkCorr — Fri, 22 Apr 2016 12:46:01 GMT

New to rule based drivers. Trying to eliminate driver assignment where Source cost =$0 (cost can be <>$0) that no forward assignment is created on calculation. I can not get this to work. Thanks

Re: ABM - rule based driver treat of zero cost

DonReid — Fri, 22 Apr 2016 14:36:31 GMT

I used this formula for my rule. Source.Cost<>0

The only caveat here is that this particular rule will also make assignment to accounts in the same module where there is no source cost. You would have to clean those assignments up if you have accounts with that state. If you would like me to dig deeper, please let me know. You can reach me at don.reid@sas.com

Re: ABM - rule based driver treat of zero cost

MarkCorr — Fri, 22 Apr 2016 14:53:40 GMT

Can you please investigate as I have tried this without success? Thanks

Re: ABM - rule based driver treat of zero cost

DonReid — Fri, 22 Apr 2016 14:57:29 GMT

What version of ABM are you running?

Re: ABM - rule based driver treat of zero cost

MarkCorr — Fri, 22 Apr 2016 14:59:40 GMT

7.2 but due to move to 8 next month

Re: ABM - rule based driver treat of zero cost

DonReid — Mon, 25 Apr 2016 12:58:34 GMT

One of my colleagues had this in response to your question. And remember source.cost<>0 would be the module the account making the assignment in. Here is what my colleague said.

Whether this works or not will depend on whether he is using sequenced drivers. To work this driver would have to be at least sequence 2 as there will be no cost for sequence 1 until after a calc. If the rule is being used in the Resource module then you may be able to use EnteredCost instead but expect you will get the same result.

To designate the rule as only applying to this module you could use SOURCE.Module.DimMemberRef = destination.Module.dimmemberref (or of course not equal if it mustn’t go the same module).

Re: ABM - rule based driver treat of zero cost

MarkCorr — Mon, 25 Apr 2016 17:34:40 GMT

Thanks I will try and revert with the result. Thx

Re: ABM - rule based driver treat of zero cost

DonReid — Mon, 25 Apr 2016 18:40:40 GMT

You are welcome. Feel free to email me with further questions.

Re: Long Calculation / Cube times

MarkCorr — Wed, 27 Apr 2016 11:29:40 GMT

Hi Don,

On a difference subjuct, I have just posted the query below. Are you in a position to assist or would it go to another grouop? Thanks again for your assistance so far.

Long Calculation / Cube times

9m ago

Recently calculation / cube processing times have increased 10 fold and I am trying to work towards a solution. I have sought out reported / unreported errors (e.g. circular account assignments , percentages exceeding / not equating to 100, invalid driver rules disabled / corrected / removed, OutputQtyUE not equal to 0, etc. I have also made reference values as short as possible to ensure intersections are as short as they can be. Can anyone suggest other actions that could be taken?

Re: ABM - rule based driver treat of zero cost

MarkCorr — Thu, 28 Apr 2016 13:36:13 GMT

Addition of change to sequence 2 solved it. Thx again to all.

topic Re: ABM - rule based driver treat of zero cost in SAS Visual Analytics

ABM - rule based driver treat of zero cost

Re: ABM - rule based driver treat of zero cost

Re: ABM - rule based driver treat of zero cost

Re: ABM - rule based driver treat of zero cost

Re: ABM - rule based driver treat of zero cost

Re: ABM - rule based driver treat of zero cost

Re: ABM - rule based driver treat of zero cost

Re: ABM - rule based driver treat of zero cost

Re: Long Calculatio​n / Cube times

Re: ABM - rule based driver treat of zero cost

Re: Long Calculation / Cube times