Microsoft® SQL Server™ OLAP Services supports many functions in the Microsoft Visual Basic® for Applications Expression Services library. This library is included with OLAP Services and automatically registered. Functions not supported in this release are marked by an asterisk in the table below.
| Abs | *Add | *AppActivate | *Array |
| Asc | AscB | AscW | Atn |
| *Beep | *Calendar | *CallByName | CBool |
| CByte | CCur | CDate | CDbl |
| *CDec | *ChDir | *ChDrive | *Choose |
| Chr | *ChrB | ChrW | CInt |
| *Clear | CLng | *Command | Cos |
| *Count | *CreateObject | CSng | CStr |
| CurDir | CVar | CVDate | *CVErr |
| Date | DateAdd | DateDiff | DatePart |
| DateSerial | DateValue | Day | DDB |
| *DeleteSetting | *Description | *Dir | *DoEvents |
| Environ | *EOF | *Err | *Error |
| Exp | *FileAttr | *FileCopy | FileDateTime |
| FileLen | *Filter | Fix | Format |
| *FormatCurrency | *FormatDateTime | *FormatNumber | *FormatPercent |
| *FreeFile | FV | *GetAllSettings | *GetAttr |
| *GetObject | *GetSetting | *HelpContext | *HelpFile |
| Hex | Hour | IIf | *IMEStatus |
| *Input | *InputB | *InputBox | InStr |
| InStrB | *InStrRev | Int | IPmt |
| *IRR | *IsArray | IsDate | *IsEmpty |
| IsError | *IsMissing | IsNull | IsNumeric |
| *IsObject | *Item | *Join | *Kill |
| *LastDllError | LCase | Left | LeftB |
| Len | LenB | *Loc | *LOF |
| Log | LTrim | Mid | MidB |
| Minute | *MIRR | *MkDir | Month |
| *MonthName | *MsgBox | Now | NPer |
| *NPV | *Number | Oct | *Partition |
| Pmt | PPmt | PV | QBColor |
| *Raise | *Randomize | Rate | *Remove |
| *Replace | *Reset | RGB | Right |
| RightB | *RmDir | Rnd | Round |
| RTrim | *SaveSetting | Second | *Seek |
| *SendKeys | *SetAttr | Sgn | Shell |
| Sin | SLN | *Source | Space |
| *Split | Sqr | Str | StrComp |
| String | *StrReverse | *Switch | SYD |
| Tan | Time | Timer | TimeSerial |
| TimeValue | Trim | TypeName | UCase |
| Val | *VarType | Weekday | *WeekdayName |
| *Width | Year |