- 数据类型
- 操作符
- 数学
- 字符串
- 日期时间
- 序列
- 序表
- 循环函数
- 关联运算
- 文件
- 数据库
- 游标
- 程序语句
- 系统与接口
- 集群
- 图形
- 财务
- 外部库
- 组表
-
Function
- #c
- $(db)sql;…
- ${macroExp}
- =expression
- >statement
- [a:b]
- @
- A()
- A. (x)
- [a1,…,an]
- abs()
- acos()
- acosh()
- age()
- align()
- ali_client ()
- ali_close()
- ali_query()
- alter()
- and()
- append()
- argpost
- arguments ()
- array()
- asc ()
- asin()
- asinh()
- atan()
- atanh()
- attach()
- avg()
- base64 ()
- between()
- bits()
- blob()
- bool ()
- break {a}
- C
- Cr()
- calc()
- call()
- call path/dfx( … )
- callx()
- cand()
- canvas()
- case()
- ceil()
- cellname()
- cgroups()
- ch. ()
- channel()
- char()
- chn()
- clear()
- clipboard ()
- close()
- cmp()
- cor ()
- combin()
- commit()
- concat()
- conj()
- conjx()
- connect()
- contain()
- cos()
- cosh()
- count()
- cov()
- covm()
- create()
- cs.()
- cuboid()
- cum()
- cursor()
- date()
- datetime()
- day()
- days()
- decimal()
- delete()
- deq()
- derive()
- det()
- dfx (...)
- diff()
- digits()
- directory()
- dis()
- dism()
- dup()
- elapse()
- end s
- enum()
- env()
- eq()
- error()
- eval()
- es_close ()
- es_delete()
- es_head()
- es_open()
- es_get()
- es_post()
- es_put()
- execute()
- exists()
- exp()
- export()
- f@o(…)
- Faccrint()
- Faccrintm()
- fact()
- false
- Fcoupcd()
- Fcoups()
- Fdb()
- Fddb()
- Fdisc()
- Fduration()
- fetch()
- field()
- file()
- filename ()
- fill()
- find()
- Fintrate()
- Firr()
- float()
- floor()
- Fmirr()
- fname()
- fno()
- Fnper()
- Fnpv()
- for
- fork
- format()
- Fpmt()
- Fprice()
- Frate()
- Freceived()
- Fsln()
- Fsyd()
- ftp_cd()
- ftp_client()
- ftp_close()
- ftp_dir()
- ftp_get()
- ftp_mget()
- ftp_mput()
- ftp_put()
- func()
- Fv()
- Fvdb()
- Fyield()
- gcd()
- goto C
- group()
- groupi()
- groupn()
- groups()
- groupx()
- hash ()
- hbase_close()
- hbase_cmp()
- hbase_filter()
- hbase_filterlist()
- hbase_get()
- hbase_open()
- hbase_scan()
- hdfs_client()
- hdfs_close()
- hdfs_dir()
- hdfs_file()
- hive_client()
- hive_close()
- hive_cursor()
- hive_execute ()
- hive_query()
- hosts()
- hour()
- htmlparse ()
- httpfile()
- httpupload()
- I ()
- icursor()
- icount()
- id()
- if
- if()
- ifa()
- ifdate()
- ifn()
- ifnumber()
- ifr()
- ifstring()
- ift()
- iftime()
- ifv()
- ifx_close()
- ifx_conn()
- ifx_cursor()
- ifx_listfrag()
- ifx_savefrag()
- ifx_setfrag()
- ifx_takefrag()
- import()
- index()
- inf()
- influx_close ()
- influx_insert ()
- influx_open ()
- influx_query ()
- insert()
- int()
- interval()
- inv()
- inverse()
- invoke()
- isalpha ()
- isdigit()
- isect()
- iselect()
- islower()
- isolate()
- isupper()
- iterate()
- join()
- joinx()
- json()
- k()
- k{}
- kafka_close()
- kafka_commit()
- kafka_poll()
- kafka_subscribe()
- key()
- keys()
- lcm()
- left()
- len()
- lg()
- like()
- linefit()
- ln()
- lock()
- long()
- lower()
- m()
- mae()
- max()
- maxp()
- mcursor()
- md5()
- median()
- memory()
- merge()
- mergex()
- mid()
- millisecond()
- min()
- minp()
- minute()
- mode()
- modify()
- mongo_close ()
- mongo_insert ()
- mongo_open ()
- mongo_shell()
- month()
- movefile()
- mul()
- mse()
- n.f(x)
- name()
- new()
- news()
- next {a}
- nodes()
- norm()
- not ()
- now()
- null
- number()
- nvl()
- olap_close ()
- olap_open ()
- olap_query ()
- open()
- or()
- output()
- p()
- pad()
- parse()
- paste ()
- pca ()
- pdate ()
- pearson ()
- penum()
- periods()
- permut()
- pfind()
- pi()
- pivot()
- pls ()
- pmax()
- pmin()
- polyfit()
- pos()
- power()
- prior()
- proc()
- product()
- property()
- pseg()
- pselect()
- psort()
- ptop()
- push()
- query()
- r(T,F)
- r.(x)
- r.F
- r.F=x
- rand()
- rands()
- range()
- rank()
- ranki()
- rankm ()
- ranks()
- read()
- record()
- redis_close ()
- redis_exists()
- redis_expire ()
- redis_get ()
- redis_getbit()
- redis_getrange ()
- redis_hexists()
- redis_hkeys ()
- redis_hmget()
- redis_hscan ()
- redis_hsize()
- redis_hvals ()
- redis_increment ()
- redis_keys ()
- redis_lindex()
- redis_lrange()
- redis_lsize ()
- redis_ltrim ()
- redis_open ()
- redis_persist ()
- redis_randomkey ()
- redis_sdiff()
- redis_sinter()
- redis_sismember()
- redis_size ()
- redis_smembers()
- redis_sscan ()
- redis_srandmember()
- redis_sunion()
- redis_type()
- redis_zcard()
- redis_zcount()
- redis_zrange()
- redis_zrangebyscore()
- redis_zrank()
- redis_zscan ()
- redis_zscore()
- redis_zsize ()
- regex()
- register()
- rename()
- replace ()
- report_config()
- report_exportHtml()
- report_exportPdf()
- report_exportXls()
- report_open()
- report_run()
- reset()
- result
- return xi
- rgb()
- right()
- rollback()
- round()
- row()
- run()
- rvs()
- sap_ open ()
- sap_close ()
- sap_cursor ()
- sap_excute ()
- sap_getparam ()
- sap_table ()
- savepoint()
- second()
- segp()
- select()
- seq()
- sf_close ()
- sf_open ()
- sf_query ()
- sf_wsdlclose ()
- sf_wsdlopen ()
- sf_wsdlquery ()
- sf_wsdlview ()
- sg ()
- shift()
- sign()
- sin()
- sinh()
- size()
- sizeof()
- skip()
- sleep()
- sort()
- sortx()
- spark_client ()
- spark_close()
- spark_cursor()
- spark_query()
- spearman ()
- split()
- sqlparse()
- sqltranslate ()
- substr ()
- stax_close()
- stax_connect ()
- stax_query()
- sqrt()
- step()
- string()
- sum()
- swap()
- switch()
- sync()
- system
- T()
- tan ()
- tanh()
- time()
- to()
- top()
- total()
- transpose()
- trim()
- true
- try
- union()
- update()
- upper()
- urlencode()
- v()
- var()
- words()
- workday()
- workdays()
- write()
- ws_call()
- ws_client()
- xjoin()
- xjoinx()
- xlscell()
- xlsclose()
- xlsexport ()
- xlsimport ()
- xlsopen()
- xlswrite()
- xml()
- xor()
- xunion()
- year()
- ym_build_model()
- ym_close()
- ym_env()
- ym_exec()
- ym_importance ()
- ym_json()
- ym_load_pcf()
- ym_model ()
- ym_performance()
- ym_predict()
- ym_present ()
- ym_result()
- ym_save_pcf()
- ym_setparam()
- ym_server_quit()
- ym_statistics ()
- ym_target ()
- z()
- zip()
- zip_add()
- zip_close ()
- zip_compress()
- zip_del()
- zip_encrypt()
- zip_extract()
- zip_open ()
- zone()
- 交列
- 比较运算
- 十六进制长整数
- 取余求整
- 和列
- 四则运算
- 复合赋值
- 字符串
- 字符串拼接
- 排号连接
- 对位运算
- 差列
- 并列
- 序列乘
- 序表常数
- 异或列
- 循环函数
- 循环函数中的表达式书写规则
- 批运算
- 标识符
- 相反数
- 空列
- 赋值
- 赋值计算
- 转义符
- 逻辑运算
- 长整数
- 单元格类型
- 代码块类型
- 图元
olap_query ()
描述：
查询多维数据库，返回结果值
语法：
olap_query(conn,mdx)
备注：
外部库函数，查询多维数据库，返回结果值
选项：
|
@c |
返回游标 |
参数：
|
conn |
连接对象 |
|
mdx |
多维数据库查询语句，支持一个或两个轴 |
返回值：
序表或游标
示例：
|
|
A |
|
|
1 |
=olap_open("http://192.168.0.178:8088/msmdpump.dll","CubeTest","Administrator","admin") |
连接CubeTest多维数据库 |
|
2 |
=olap_query(A1," select {[Measures].[ OrderAmount]} on columns from [DataSourceMulti]") |
查询全部订货量 |
|
3 |
=olap_query@c(A1," with member [Measures].[ AnnualInterestRate] as '[Measures].[ SalesAmount]/[Measures].[ StandardCost]-1' select {[Measures].[ SalesAmount],[Measures].[ StandardCost],[Measures].[ AnnualInterestRate]} on columns, {[Order Date].[Calendar Year].[Calendar Year]} on rows from [DataSourceMulti]") |
查询每年的销售额、产品标准成本，并计算年利率，返回游标 |
|
4 |
=A4.fetch(5) |
|
|
5 |
>olap_close(A1) |
关闭数据库连接 |
相关概念：