Skip to main content
Porto
  • ‌ About Us
  • ‌ Contact Us
  • ‌
  • ‌

Main navigation

  • TM1
    • Users
    • Admins
    • Developers
    • TM1 MDX Primer
  • Contact

Breadcrumb

  1. Home
  2. The TM1 cookbook
  3. Developers

TM1 operators

browse by topic

admins(25) alias(2) attributes (1)backup(3) chores(5) cube viewer(2) debug(2) developers(27) Documentation (1)email(3) excel(8) format(2) hierarchies(2) iSeries (1)locking(2) MDX(32) monitor(2) perspectives(3) RTFM FAIL(2) rules(5) security (1)shell(13) SQL (1)subset editor(4) subsets(3) tm1web (1)tools(4) turbo integrator(12) users(7) VBA(8) versioning (1)

TM1

  • The TM1 cookbook
    • Users
    • Developers
      • A closer look at dynamic slices
      • Attributes
      • Bulk reporting
      • Commenting out portions of code in TI
      • Creating temporary views
      • Debugging
      • Dynamic SQL queries with TI parameters
      • Dynamic formatting
      • Padding zeroes
      • Renaming elements
      • Rules
      • Scheduling chores on calendar events
      • Send email/attachments
      • Silent failures
      • TM1 lint
      • TM1 operators
      • Creating Dynamic Subsets in Applix TM1 with MDX - A Primer
      • The fallacy of blb files
      • Turbo Integrator highlighters
      • VBA
      • Zero out portions
    • Admins

TM1 operators

Submitted by admin on Tue, 2019-11-19 08:23

Logical operators


& AND
% OR
~ NOT

Strings operators


| concatenate
@= string1 equals string2
@<> string1 differs from string2

inserting '&' in strings:
ItemReject('This & That'); will return 'This _That'
ItemReject('This && That'); will return 'This & That'

Book traversal links for TM1 operators

  • ‹ TM1 lint
  • Up
  • Creating Dynamic Subsets in Applix TM1 with MDX - A Primer ›
  • Printer-friendly version
Categories
developers
turbo integrator
  • FAQ
  • Sitemap
  • Contact