ࡱ>  0n0bjbj .n(IIIII]]]]D]'f(5'7'7'7'7'7'7'$)+p['I   ['IIp'!!!!!! II5'!! 5'!!!!!! rl=]!!!''0'!!.,T.,!!!!.,I&x!! S['['!'    ., :  VBA functions in AS2005 (By Irina Gorbach) Similarly to Analysis Services 2000, Analysis Services 2005 uses stored procedure technology to extend the number of built-in MDX functions. It automatically registers two libraries: the Visual Basic for Applications library and the Microsoft Excel worksheet library. Visual Basic for Applications library is registered as a CLR assembly and Excel library as COM assembly. MDX expressions can use any of supported VBA and Excel functions, as if there were native MDX functions. However there is an important difference between native MDX functions and VBA or Excel functions performance. In chapter 14 of our book  HYPERLINK "http://www.amazon.com/Microsoft-Server-2005-Analysis-Services/dp/0672327821/sr=8-1/qid=1169844967/ref=sr_1_1/104-9979424-6671948?ie=UTF8&s=books" Microsoft SQL Server 2005 Analysis Services I explained how CLR and COM assemblies are hosted inside of Analysis Services process. Basically CLR assemblies are hosted in a separate application domain and in addition to marshaling from native to managed code and back, all the calls are also marshaled across application domains. Therefore calling a VBA function is an expensive operation comparing to calling an MDX function. To make performance critical customer applications run faster, we have implemented some of the most often used functions as part of Analysis Services code base. Ill call this set of functions internal VBA. And even through, I personally dislike this direction our product took; internal VBA functions are much faster then regular VBA functions. You dont need to do anything special to enable internal functions - they are on by default. However, when developing MDX expressions it useful to know internal functions, so here is table that contains all VBA functions. Functions that have internal implementation today February 8, 2007 are marked as internal. FunctionIs internalHelpAbsYesReturns the absolute value of a specified number.AscNoReturns an Integer value representing the character code corresponding to a character.AscWNoReturns an Integer value representing the character code corresponding to a wide-character.AtnNoReturns a Double value containing the angle whose tangent is the specified number.CBoolNoConverts a value to BooleanCByteNoConverts a value to ByteCCurNoConverts a value to CurrencyCDateYesConverts a value to DateCDblNoConverts a value to DoubleCDecNoConverts a value to DecimalChooseNoSelects and returns a value from a list of arguments.ChrNoReturns the character associated with the specified character code.ChrWNoReturns the Unicode character associated with the specified character code.CIntYesConverts a value to IntegerCLngYesConverts a value to LongCosNoReturns a Double value containing the cosine of the specified angle.CSngNoConverts a value to SingleCStrYesConverts a value to stringCVarNoConverts a value to variantDateNoDateAddNoReturns a Date value containing a date and time value to which a specified time interval has been added.DateDiffNoReturns a Long value specifying the number of time intervals between two Date values.DatePartNoReturns an Integer value containing the specified component of a given Date value.DateSerialNoReturns a Date value representing a specified year, month, and day, with the time information set to midnight (00:00:00).DateValueNoReturns a Date value containing the date information represented by a string, with the time information set to midnight (00:00:00).DayNoReturns an Integer value from 1 through 31 representing the day of the month.DDBNoReturns a Double specifying the depreciation of an asset for a specific time period using the double-declining balance method or some other method you specify.ExpNoReturns a Double value containing e (the base of natural logarithms) raised to the specified power.FixNoReturn the integer portion of a number.FormatNoReturns a string formatted according to instructions contained in a format String expression.FVNoReturns a Double specifying the future value of an annuity based on periodic, fixed payments and a fixed interest rate.HexNoReturns a string representing the hexadecimal value of a number.HourNoReturns an Integer value from 0 through 23 representing the hour of the day.IIFNoReturns one of two objects, depending on the evaluation of an expression.InStrYes (SP2)Returns an integer specifying the start position of the first occurrence of one string within another.IntYesReturn the integer portion of a number.IPmtNoReturns a Double specifying the interest payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate.IRRNoReturns a Double specifying the internal rate of return for a series of periodic cash flows (payments and receipts).IsArrayYesReturns a Boolean value indicating whether a variable points to an array. IsDateNoReturns a Boolean value indicating whether a variable points to a date.IsEmptyNoReturns a Boolean value indicating whether a variable has been initialized.IsErrorYesReturns a Boolean value indicating whether an expression is an exception type.IsNullNoReturns a Boolean value that indicates whether an expression contains no valid data (Null).IsNumericNoReturns a Boolean value indicating whether an expression can be evaluated as a numberLCaseNoReturns a string or character converted to lowercase.LeftYesReturns a string containing a specified number of characters from the left side of a string.LenYesReturns an integer containing either the number of characters in a string or the number of bytes required to store a variable. LogNoReturns a Double value containing the logarithm of a specified number.LTrimNoReturns a string containing a copy of a specified string with no leading spaces (LTrim), no trailing spaces (RTrim), or no leading or trailing spaces (Trim).MidYesReturns a string containing a specified number of characters from a string.MinuteNoReturns a string containing a specified number of characters from a string.MIRRNoReturns a Double specifying the modified internal rate of return for a series of periodic cash flows (payments and receipts).MonthNoReturns an Integer value from 1 through 12 representing the month of the yearNowYesGets a  HYPERLINK "http://msdn.microsoft.com/library/en-us/cpref/html/frlrfsystemdatetimeclasstopic.asp" DateTime that is the current local date and time on this computer.NPerNoReturns a Double specifying the number of periods for an annuity based on periodic, fixed payments and a fixed interest rate.NPVNoReturns a Double specifying the net present value of an investment based on a series of periodic cash flows (payments and receipts) and a discount rate.OctNoReturns a string representing the octal value of a numberPartitionNoReturns a string representing the calculated range that contains a number.PmtNoReturns a Double specifying the payment for an annuity based on periodic, fixed payments and a fixed interest ratePPmtNoReturns a Double specifying the principal payment for a given period of an annuity based on periodic, fixed payments and a fixed interest ratePVNoReturns a Double specifying the present value of an annuity based on periodic, fixed payments to be paid in the future and a fixed interest rate.QBColorNoReturns an Integer value representing the RGB color code corresponding to the specified color number.RateNoReturns a Double specifying the interest rate per period for an annuityRGBNoReturns an Integer value representing an RGB color value from a set of red, green and blue color componentsRightYesReturns a string containing a specified number of characters from the right side of a stringRndNoReturns a random number of type SingleRoundYesReturns a Double value containing the number nearest the specified value.RTrimNoReturns a string containing a copy of a specified string with no leading spaces (LTrim), no trailing spaces (RTrim), or no leading or trailing spaces (Trim).SecondNoReturns an Integer value from 0 through 59 representing the second of the minuteSgnNoReturns an Integer value indicating the sign of a number.SinNoReturns a Double value specifying the sine of an angle.SLNNoReturns a Double specifying the straight-line depreciation of an asset for a single periodSpaceNoReturns a string consisting of the specified number of spacesSqrNoReturns a Double value specifying the square root of a number.StrNoReturns a string consisting of the specified number of spacesStrCompNoReturns -1, 0, or 1, based on the result of a string comparisonStrConvNoReturns a string converted as specified.StringNoInitializes a new instance of the String class to the value indicated by a specified Unicode character repeated a specified number of timesSwitchNoEvaluates a list of expressions and returns an Object value of an expression associated with the first expression in the list that is TrueSYDNoReturns a Double specifying the sum-of-years digits depreciation of an asset for a specified periodTanNoReturns a Double value containing the tangent of an angle.TimerNoReturns a Float value representing the number of seconds elapsed since midnight.TimeSerialNoReturns a Date value representing a specified hour, minute, and second, with the date information set relative to January 1 of the year 1.TimeValueNoReturns a Date value containing the time information represented by a string, with the date information set to January 1 of the year 1TrimNoReturns a string containing a copy of a specified string with no leading spaces (LTrim), no trailing spaces (RTrim), or no leading or trailing spaces (Trim).TypeNameNoReturns a String value containing data type information about a variable.UCaseNoReturns a string or character containing the specified string converted to uppercase.ValNoReturns the numbers contained in a string as a numeric value of appropriate typeWeekdayNoReturns an Integer value containing a number representing the day of the weekYearNoReturns an Integer value from 1 through 9999 representing the year +,9JQch7 8 ^ 5 6 7 d e 7 ; D E z Q S BCai!~ӻ۷۳۳۳۳ۧۧۧۧۧϧϧϣhihAXhi5hh83hn!h[|6hn!h>h>h>0JjhOwUh>jh>Uh[| hSh[| hSh9 h\Fh\Fh\Fh$h98+, C $$Ifa$gdAX $Ifgd9gd9gd\Fgd9 KB6B $$Ifa$gdAX $Ifgd9kd$$IflF ,"    t06    44 lapytAX3:<=HO!#$8<CEFZbdjmn\สўўўўўўhAXhpJ5CJaJhAXhpJ5CJ\aJhAXhpJCJaJhAXhpJ5CJ\aJhAXhpJCJaJhihhAXhiCJaJhAXhi5hAXh5>4qh\h $$Ifa$gdAX $Ifgd9kdk$$IflF ,"   t06    44 laytAX45:=qh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAXqh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAXqh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAX!$=qh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAX=>CFcqh\h $$Ifa$gdAX $Ifgd9kd,$$IflF ,"   t06    44 laytAXcdjnqh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAXqh\h $$Ifa$gdAX $Ifgd9kdF$$IflF ,"   t06    44 laytAXqh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAXqh\h $$Ifa$gdAX $Ifgd9kd`$$IflF ,"   t06    44 laytAX]qh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAX]^cfqh\h $$Ifa$gdAX $Ifgd9kdz$$IflF ,"   t06    44 laytAX\cef GIQekmv4BLPƸѴѬѴh>hAXhpJ5CJ\aJhAXhpJ5hpJhAXhpJ5CJ\aJhAXhpJCJaJhAXhpJ5CJaJhAXhi5hAXh5hAXhpJCJaJhih8qh\h $$Ifa$gdAX $Ifgd9kd $$IflF ,"   t06    44 laytAXqh\h $$Ifa$gdAX $Ifgd9kd $$IflF ,"   t06    44 laytAXHqh\h $$Ifa$gdAX $Ifgd9kd! $$IflF ,"   t06    44 laytAXHINQlqh\S $IfgdOw $$Ifa$gdAX $Ifgd9kd $$IflF ,"   t06    44 laytAXlmrvqh\h $$Ifa$gdAX $Ifgd9kd; $$IflF ,"   t06    44 laytAXqh\h $$Ifa$gdAX $Ifgd9kd $$IflF ,"   t06    44 laytAXqh\h $$Ifa$gdAX $Ifgd9kdU $$IflF ,"   t06    44 laytAX5qh\h $$Ifa$gdAX $Ifgd9kd $$IflF ,"   t06    44 laytAX56?Bqh\h $$Ifa$gdAX $Ifgd9kdo $$IflF ,"   t06    44 laytAXqh\h $$Ifa$gdAX $Ifgd9kd $$IflF ,"   t06    44 laytAXqh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAXqh\S $Ifgd> $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAX&-hq{#)| '-3<.8AHCEQ[bF߻ߥߥߥߚhAXh]ACJaJhAXhpJ5hAXhpJ5CJ\aJhAXhpJCJaJhAXh>5CJ\aJhAXh>CJaJhpJhAXhpJCJOJQJaJh>hAXh>5\<iqh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAXijnqqh\h $$Ifa$gdAX $Ifgd9kd0$$IflF ,"   t06    44 laytAX}qh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAX}~qh\h $$Ifa$gdAX $Ifgd9kdJ$$IflF ,"   t06    44 laytAXqh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAXqh\h $$Ifa$gdAX $Ifgd9kdd$$IflF ,"   t06    44 laytAXqh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAX4qh\h $$Ifa$gdAX $Ifgd9kd~$$IflF ,"   t06    44 laytAX459<qh\h $$Ifa$gdAX $Ifgd9kd $$IflF ,"   t06    44 laytAXqh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAX/qh\h $$Ifa$gdAX $Ifgd9kd%$$IflF ,"   t06    44 laytAX/058qh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAXDqh\h $$Ifa$gdAX $Ifgd9kd?$$IflF ,"   t06    44 laytAXDEMQqh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAXqh\h $$Ifa$gdAX $Ifgd9kdY$$IflF ,"   t06    44 laytAXGqh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAXFGHST^e  ")mxHMdi@ J T Z !!!(!)!0!1!񶨶jhAXhaaCJUaJhAXhaaCJaJhAXhpJ5CJ\aJhAXhpJCJaJh>hAXh]ACJaJhAXh>5CJ\aJhAXh>CJaJhAXhpJ5hpJhAXhpJCJaJ8GHPTqh\h $$Ifa$gdAX $Ifgd9kds$$IflF ,"   t06    44 laytAX qh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAX  nqh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAXnouxqh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAXqh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAXqh\h $$Ifa$gdAX $Ifgd9kd4$$IflF ,"   t06    44 laytAXqh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAXqh\h $$Ifa$gdAX $Ifgd9kdN$$IflF ,"   t06    44 laytAXqh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAXA qh\h $$Ifa$gdAX $Ifgd9kdh$$IflF ,"   t06    44 laytAXA B G J qh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAX !qh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAX !!!%!)!!qh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAX1!!!!!!!!!^"g"q"w""#A#P#####$$)$/$$$$$F%S%^%f%%%%% &&&$&}&&&&&&&'''' '*'ʼʼʼʼʼձձձ՛ձ՛ՐhAXhpJCJaJhAXhpJ5hAXhOw5CJ\aJhAXhOwCJaJhAXh>5CJ\aJhAXh>CJaJhpJhAXhaa0JCJaJjhAXhaaCJUaJhAXhaaCJaJ5!!!!_"qh\h $$Ifa$gdAX $Ifgd9kd$$IflF ,"   t06    44 laytAX_"`"d"g"#qh\h $$Ifa$gdAX $Ifgd9kd) $$IflF ,"   t06    44 laytAX####B#qh\h $$Ifa$gdAX $Ifgd9kd $$IflF ,"   t06    44 laytAXB#C#M#P##qh\h $$Ifa$gdAX $Ifgd9kdC!$$IflF ,"   t06    44 laytAX####$qh\h $$Ifa$gdAX $Ifgd9kd!$$IflF ,"   t06    44 laytAX$$$$$qh\h $$Ifa$gdAX $Ifgd9kd]"$$IflF ,"   t06    44 laytAX$$$$G%qh\h $$Ifa$gdAX $Ifgd9kd"$$IflF ,"   t06    44 laytAXG%H%P%S%%qh\h $$Ifa$gdAX $Ifgd9kdw#$$IflF ,"   t06    44 laytAX%%%% &qh\h $$Ifa$gdAX $Ifgd9kd$$$IflF ,"   t06    44 laytAX & &&&~&qh\h $$Ifa$gdAX $Ifgd9kd$$$IflF ,"   t06    44 laytAX~&&&&&qh\h $$Ifa$gdAX $Ifgd9kd%$$IflF ,"   t06    44 laytAX&&&&'qh\h $$Ifa$gdAX $Ifgd9kd%$$IflF ,"   t06    44 laytAX''' 'j'qh\h $$Ifa$gdAX $Ifgd9kd8&$$IflF ,"   t06    44 laytAX*'0'i't''''' ((((((/(m(v((((((((())R)])))))))'*4*s******?+@+K+z+++++++A,J,T,Z,,,,㿱hAXhaaCJaJhAXhpJCJaJhAXhB5CJ\aJhAXhBCJaJhAXhOw5CJ\aJhAXhOwCJaJhpJhAXhpJCJaJhAXhpJ5CJ\aJ:j'k'q't'(qh\h $$Ifa$gdAX $Ifgd9kd&$$IflF ,"   t06    44 laytAX((((n(qh\h $$Ifa$gdAX $Ifgd9kdR'$$IflF ,"   t06    44 laytAXn(o(s(v((qh\h $$Ifa$gdAX $Ifgd9kd'$$IflF ,"   t06    44 laytAX(((((qh\h $$Ifa$gdAX $Ifgd9kdl($$IflF ,"   t06    44 laytAX((((S)qh\h $$Ifa$gdAX $Ifgd9kd($$IflF ,"   t06    44 laytAXS)T)Z)]))qh\h $$Ifa$gdAX $Ifgd9kd)$$IflF ,"   t06    44 laytAX)))))qh\h $$Ifa$gdAX $Ifgd9kd*$$IflF ,"   t06    44 laytAX))))(*qh\h $$Ifa$gdAX $Ifgd9kd*$$IflF ,"   t06    44 laytAX(*)*1*4*t*qh\h $$Ifa$gdAX $Ifgd9kd-+$$IflF ,"   t06    44 laytAXt*u*}***qh\h $$Ifa$gdAX $Ifgd9kd+$$IflF ,"   t06    44 laytAX****@+qh\h $$Ifa$gdAX $Ifgd9kdG,$$IflF ,"   t06    44 laytAX@+A+H+K++qh\h $$Ifa$gdAX $Ifgd9kd,$$IflF ,"   t06    44 laytAX++++B,qh\h $$Ifa$gdAX $Ifgd9kda-$$IflF ,"   t06    44 laytAXB,C,G,J,,qh\h $$Ifa$gdAX $Ifgd9kd-$$IflF ,"   t06    44 laytAX,,,,,qh\h $$Ifa$gdAX $Ifgd9kd{.$$IflF ,"   t06    44 laytAX,,,,,,y----..i.n.......... //l/m/u/////0)040;0k0m0n0ƼƼƼƭƭh[|hAXhpJCJOJQJaJhAXhOw5\hOwhAXhOw5CJ\aJhAXhOwCJaJhpJhAXhaaCJaJhAXhaa5CJ\aJ&,,,,z-qh\h $$Ifa$gdAX $Ifgd9kd/$$IflF ,"   t06    44 laytAXz-{---.qh\h $$Ifa$gdAX $Ifgd9kd/$$IflF ,"   t06    44 laytAX.....qh\S $IfgdOw $$Ifa$gdAX $Ifgd9kd"0$$IflF ,"   t06    44 laytAX.... /qh\h $$Ifa$gdAX $Ifgd9kd0$$IflF ,"   t06    44 laytAX ////m/qh\S $IfgdOw $$Ifa$gdAX $Ifgd9kd<1$$IflF ,"   t06    44 laytAXm/n/r/u//qh\h $$Ifa$gdAX $Ifgd9kd1$$IflF ,"   t06    44 laytAX//// 0qh\h $$Ifa$gdAX $Ifgd9kdV2$$IflF ,"   t06    44 laytAX 0!0&0)0l0qh\h $$Ifa$gdAX $Ifgd9kd2$$IflF ,"   t06    44 laytAXl0m0n0qlgd9kdp3$$IflF ,"   t06    44 laytAX,1h/ =!"#$% DyK yK "http://www.amazon.com/Microsoft-Server-2005-Analysis-Services/dp/0672327821/sr=8-1/qid=1169844967/ref=sr_1_1/104-9979424-6671948?ie=UTF8&s=books$$If!vh5 5 5 #v :V l  t065 pytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX$$If!vh5 5 5 #v :V l t065 ytAX^ 2 0@P`p2( 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p8XV~_H mH nH sH tH @`@ NormalCJ_HaJmH sH tH Z@Z 9 Heading 1$<@&5CJ KH OJQJ\^JaJ DA`D Default Paragraph FontRi@R  Table Normal4 l4a (k (No List ZYZ 9 Document Map-D M CJOJQJ^JaJ:O: 9FT dxCJOJQJaJBB 9FT CharCJOJQJ_HmH sH tH `"` 9 Char1 Char Char Char dCJOJQJaJ6U@16 > Hyperlink >*B*phjCj > Table Grid7:V0L^@RL pJ Normal (Web)dhxx B*phPK![Content_Types].xmlj0Eжr(΢Iw},-j4 wP-t#bΙ{UTU^hd}㨫)*1P' ^W0)T9<l#$yi};~@(Hu* Dנz/0ǰ $ X3aZ,D0j~3߶b~i>3\`?/[G\!-Rk.sԻ..a濭?PK!֧6 _rels/.relsj0 }Q%v/C/}(h"O = C?hv=Ʌ%[xp{۵_Pѣ<1H0ORBdJE4b$q_6LR7`0̞O,En7Lib/SeеPK!kytheme/theme/themeManager.xml M @}w7c(EbˮCAǠҟ7՛K Y, e.|,H,lxɴIsQ}#Ր ֵ+!,^$j=GW)E+& 8PK!Ptheme/theme/theme1.xmlYOo6w toc'vuر-MniP@I}úama[إ4:lЯGRX^6؊>$ !)O^rC$y@/yH*񄴽)޵߻UDb`}"qۋJחX^)I`nEp)liV[]1M<OP6r=zgbIguSebORD۫qu gZo~ٺlAplxpT0+[}`jzAV2Fi@qv֬5\|ʜ̭NleXdsjcs7f W+Ն7`g ȘJj|h(KD- dXiJ؇(x$( :;˹! I_TS 1?E??ZBΪmU/?~xY'y5g&΋/ɋ>GMGeD3Vq%'#q$8K)fw9:ĵ x}rxwr:\TZaG*y8IjbRc|XŻǿI u3KGnD1NIBs RuK>V.EL+M2#'fi ~V vl{u8zH *:(W☕ ~JTe\O*tHGHY}KNP*ݾ˦TѼ9/#A7qZ$*c?qUnwN%Oi4 =3ڗP 1Pm \\9Mؓ2aD];Yt\[x]}Wr|]g- eW )6-rCSj id DЇAΜIqbJ#x꺃 6k#ASh&ʌt(Q%p%m&]caSl=X\P1Mh9MVdDAaVB[݈fJíP|8 քAV^f Hn- "d>znNJ ة>b&2vKyϼD:,AGm\nziÙ.uχYC6OMf3or$5NHT[XF64T,ќM0E)`#5XY`פ;%1U٥m;R>QD DcpU'&LE/pm%]8firS4d 7y\`JnίI R3U~7+׸#m qBiDi*L69mY&iHE=(K&N!V.KeLDĕ{D vEꦚdeNƟe(MN9ߜR6&3(a/DUz<{ˊYȳV)9Z[4^n5!J?Q3eBoCM m<.vpIYfZY_p[=al-Y}Nc͙ŋ4vfavl'SA8|*u{-ߟ0%M07%<ҍPK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 +_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!Ptheme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK] n( \F1!*',n0)6GUcs4=c]Hl5i}4/DG nA !!_"#B##$$G%% &~&&'j'(n(((S)))(*t**@++B,,,z-.. /m// 0l0n0 !"#$%&'(*+,-./012345789:;<=>?@ABCDEFHIJKLMNOPQRSTVWXYZ[\]^_`abdefghijklmnopqrtuvwxyz{|6d0n(XX8@0(  B S  ?{<$ p( p(9*urn:schemas-microsoft-com:office:smarttagsplace ,$e59 > B d i   ^ b I M m q 6 >  04ELHO otHMdiHOkpo r !!!!)"0"u"|"$${%%i&n&&&&&''p(|p(,e5= $ > F d n   ^ f  I Q m v 6 B  jq~5<08EQHT oxBJ!)`gCPHS  kt  o v T!]!!!!!)"4"u""""A#K###C$J$$$$${%%&&&&''n'u'''!()(p(ep(Xm,<nIx +x)2 g` >@?* {,,,,13> e,y{<>7@?* g-'xbfhl!Y"s3"5JDhBr#'>46).`iQV)f* !,<9t@/]:IXK/fh04|l<1m,o1V)!2Wtw;4Y"(l5L$9/5r7#8)CzL$9Wtw;,|< fFJ* =j Z><>s3" [?r7@tg@? yABL0HHk+C fFJG:|@HwdL0HHz[LI QPtr>@Qk+C.`iQC_(S kuSom8sDW]:IXY)XC_(StZbj Zw\Br##]l!X+_DWg`wdeh4koMff*5JDhh4k4|lPm/5xp:;$qJGAtrnom8sPttSv!3wxpxLwSv+x? ye,y4:z)Cz7 }xF; 4:zj $n!]A\FjWAXaagWg [|>IpJB>i>6983OwY)n(p(@ m(`@@{n(`@UnknownG* Times New Roman5Symbol3. * Arial7.  Verdana5. *aTahomaA BCambria Math"1h=妩=!G!G!4dZ(Z(2qHP ?92!xxVBA functions in AS2005irinageldadhOh+'0  < H T`hpxVBA functions in AS2005irinag Normal.dotmeldadh2Microsoft Office Word@Ik@nT8@nT8!՜.+,D՜.+,L hp   MicrosoftGZ( VBA functions in AS2005 Title 8@ _PID_HLINKSA< VQUhttp://msdn.microsoft.com/library/en-us/cpref/html/frlrfsystemdatetimeclasstopic.aspd^Ahttp://www.amazon.com/Microsoft-Server-2005-Analysis-Services/dp/0672327821/sr=8-1/qid=1169844967/ref=sr_1_1/104-9979424-6671948?ie=UTF8&s=booksd  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}Root Entry Fx=Data ~31Table.,WordDocument.SummaryInformation(DocumentSummaryInformation8CompObjy  F'Microsoft Office Word 97-2003 Document MSWordDocWord.Document.89q