cancel
Showing results for 
Search instead for 
Did you mean: 

IDT Universe functions/operators syntax and examples

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

amitrathi239
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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