on 01-27-2015 5:01 PM
Hi,
I have recently started using IDT to design universe and noticed the functions and operators are very limited as compared to older version of Universe Design tool. Appreciate if someone advise (or share) document or location to refer all the functions and operators supported by IDT universe with syntax and examples. Also, whenever using IF statement for any measure, getting error that FROM clause is missing etc.
Thanks,
Anurag
Hi,
Check the IDT user help guide for functions.
Chapter 18 SQL and MDX reference
http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41_info_design_tool_en.pdf
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Amit.
I get below errors when using expressions even syntax looks right. Is there any database setting in Universe I should take care of to work functions correctly? Usually I have seen applying any conditional operators on measure objects are giving below errors. Thanks for your help!
ORA-00907: missing right parenthesis
ORA-00923: FROM keyword not found where expected
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.