Help with a Load Question

[#1]

Our current process is we have created a chart that has 22 KPI's.  What we do in the chart dimension is we change our 7 markets to 4.  Here is how we do it:

Industry
=if(Industry= 'A', '1',
if(Industry = 'B', '1',
if(Industry = 'C,1',
if(Industry = 'D', '2',
if(Industry = 'E', '3',
if(Industry = 'F','3',
if(Industry = 'G', '4'))))))),

Then in the expression we have various calculations similar to the ones listed below:

1. Fractile(total <Industry> aggr(sum({<AssetName= {"Product Name"}>}EF1Value__c),AcctNum, Industry),.80)

2. median(Total <Industry>aggr(sum({<AssetName= {"Product Name"}>}EF1Value__c),AcctNum))

From there we export the data out to an excel file with a row that has:

AcctNum, Industry, KPI1, KPI2, etc. 

Then we send it over so our DB cant take it and do a process that loads the information into a sql db and then push that information up to a dashboard. 

I know this is Set Analysis cant be done in a load statement but is there any way to accomplish the expression above in a load statement so I can then store the results in a csv file so our sql database can read it. We want the script to perform the heavy lifting.. 

Any ideas would be good and if there is not a way that is ok as well. 

David

[#2]

What I am trying to accomplish is give an account a score from 1 to 5. I count all the work orders over a rolling 12 month period with a status of complete and closed.  Take that number and divide by the number of students for that account.  If they meet the criteria of .1 work orders per student they get 1 point, .3 they get two points, etc until they get to 4 points.  In order to get the last point they have to track hours on their work orders.  If they do and the calculation is .5 or higher they get the final point.  Does this make sense?