<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-NCX94J4" height="0" width="0" style="display:none;visibility:hidden"></iframe>
Cubewise EDU
ConsultingEducationSoftwareKnowledge HubSupportCompany
GB
    global-search

    Who is it for

    Developers

    Duration

    8 hours

    Difficulty

    Advanced

    Prerequisite

    Developer Fundamentals

    Product

    IBM Planning Analytics WorkspaceTM1 Perspectives

    Next Course

    Advanced TurboIntegrator

    Advanced Rules

    This course is a deep dive into writing Rules, a formula-driven language that applies business logic to Cubes. By the end of this course, you will gain more confidence in writing arithmetic formulas to formulas with multi-cube logic. You will also learn why the TM1 Server is appreciated for its ability to handle data sparsity and how to manage this powerful feature. Here is a breakdown of thelessons covered in this course:

    • 1. The fundamentals for writing Rules
    • 2. How to use logic operators
    • 3. How to feed to and from consolidations
    • 4. How to write a formula requiring data from other Cubes
    • 5. How to write a currency translation rule
    • 6. How to write a moving balance rule
    • 7. How to polish the TI process for productionHow to use handle data sparsity

    Interested in learning this course? Choose the enrolment option that suits you

    Single CoursePower User MembershipEnterprise Membership
    Training CourseChoose the course(s) you want to learnUpskill your knowledge with access to ALL of our available coursesUsing our training framework, training content and expertise, build your own bespoke course that matches your environment.
    Training Course AccessReceive 12 months of training course updates and post-training insights, continuing your knowledge on the subjectReceive 12 months of training course updates and post-training insights, continuing your knowledge on the subjectEnsure your staff’s upskilling can be achieved seamlessly
    Training Server Access *4 hour course = 5 hours of server access
    8 hour course = 10 hours of server access    		4 hour course = 5 hours of server access
    8 hour course = 10 hours of server access    		Your content will be stored on our secure training platform, trusted by leading software companies worldwide.
    Training OptionsChoose one of these options:
    – Self-Paced #
    – Online Classroom (schedule) ##
    – In-person Classroom ###    		Choose one of these options:
    – Self-Paced #
    – Online Classroom (schedule) ##
    – In-person Classroom ###    		Lock in regular training sessions with our consultants throughout the year.
    Digital badgeAchieve a digital badge that endorses the knowledge learnt for the course undertakenAchieve a digital badge that endorses the knowledge learnt for the course undertakenAchieve a digital badge that endorses the knowledge learnt for the course undertaken
    Community HubStay up to date with the latest news dedicated to IBM Planning AnalyticsStay up to date with the latest news dedicated to IBM Planning AnalyticsStay up to date with the latest news dedicated to IBM Planning Analytics
    Video HubNot includedAccess to hundreds of presentations with tips from consultants, models built by customers and insights from IBMChoose to include
    Enrol today

    * A server is not required for the ‘Understanding the Value of IBM Planning Analytics’ course. A server for Apliqo UX and Apliqo FPM are organised by Apliqo.

    # Start any time and date with server access for 7 consecutive days, including 1 hour of mentoring (excludes Apliqo UX and Apliqo FPM). For Apliqo UX and Apliqo FPM, the Apliqo team will help set up the environment and training.

    ## There are no scheduled online classes for Apliqo UX and Apliqo FPM courses. Exclusive classes can be organised, for an additional cost.

    ### Exclusive classes for the customer where the local office organises the classroom, catering and trainer.