If you don’t know what it is then have a look at Glenn’s and Cameron’s blog posts.
This post is about a big surprise with FIXPARALLEL!!!!! (Oh FIXPARALLEL is not available in Calc Manager 11.1.2.3.500)
3 new members added to Measures as Children of Ratios
- MajorRatio
- SmallRatio
- NewRatio
2 new UDAs added to Market
- Direct – to all members under East
- New Market – to all members under Central
- NoMarket
What just happened there, well every member in Market dimension got multiplied with NewRatio.
No pun intended
Oh don’t wonder WhyÂ
The answer is right there in the log.
[Thu Oct 02 10:48:22 2014]Local/Sample/BasicM/admin@Native Directory/5932/Warning(1012055) Expression [@UDA("Market","Direct") AND @UDA("Market","New Market")] evaluates to an empty set. [FIX STATEMENT] is ignored [Thu Oct 02 10:48:22 2014]Local/Sample/BasicM/admin@Native Directory/6804/Info(1012675) Commit Blocks Interval for the calculation is [3000] [Thu Oct 02 10:48:22 2014]Local/Sample/BasicM/admin@Native Directory/6804/Info(1012717) Remote bitmap cache is [Disabled] [Thu Oct 02 10:48:22 2014]Local/Sample/BasicM/admin@Native Directory/6804/Info(1012668) Calculating [ Scenario(Budget)] with fixed members [Year(Jan); Measures(Sales); Product(100-10, 100-20, 100-30); Market(New York, Massachusetts, Florida)] [Thu Oct 02 10:48:22 2014]Local/Sample/BasicM/admin@Native Directory/6804/Info(1012675) Commit Blocks Interval for the calculation is [3000] [Thu Oct 02 10:48:22 2014]Local/Sample/BasicM/admin@Native Directory/6804/Info(1012717) Remote bitmap cache is [Disabled] [Thu Oct 02 10:48:22 2014]Local/Sample/BasicM/admin@Native Directory/6804/Info(1012668) Calculating [ Scenario(Budget)] with fixed members [Year(Jan); Measures(Sales); Product(100-10, 100-20, 100-30); Market(Connecticut, New Hampshire)] [Thu Oct 02 10:48:23 2014]Local/Sample/BasicM/admin@Native Directory/6804/Info(1012675) Commit Blocks Interval for the calculation is [3000] [Thu Oct 02 10:48:23 2014]Local/Sample/BasicM/admin@Native Directory/6804/Info(1012717) Remote bitmap cache is [Disabled] [Thu Oct 02 10:48:23 2014]Local/Sample/BasicM/admin@Native Directory/6804/Info(1012668) Calculating [ Scenario(Budget)] with fixed members [Year(Jan); Measures(Sales); Product(100-10, 100-20, 100-30)] [Thu Oct 02 10:48:23 2014]Local/Sample/BasicM/admin@Native Directory/6640/Info(1012890) Calculating in FIXPARALLEL with [3] threads. Task dimension = [Product]. Task size = [1]. Total tasks = [3] [Thu Oct 02 10:48:23 2014]Local/Sample/BasicM/admin@Native Directory/6640/Info(1012579) Total Calc Elapsed Time for [fxpar.csc] : [0.328] seconds
Then you’ll see three statements which says “Calculating [ Scenario(Budget)] with fixed members”. Why 3? It should have only done 2.
Look at the 3rd statement (there is no Market information there and that is our EMPTYSET.
Now you know what happened here. Now what if NewRatio was missing, (this is what happened earlier in realworld – where you’ll think that it is a block creation or what not) yes you guessed it right all Budget data will be gone. pufffff!!!!!!
Now that I know that I’ve an EMPTYSET I wrote a different calc to prove that it can still work.
I hope that it get fixed soon.