Aramar
  • About Aramar
    • Meet The Team
    • Working at Aramar
    • News, Blogs and Events
  • How can we help?
  • IBM Analytics
    • IBM Cognos Controller
    • IBM Planning Analytics with Watson
    • IBM Cognos Analytics with Watson
    • IBM Legacy Software Support
    • Supporting Software
  • Services
    • Product Specialists
    • IBM Software Licencing
    • IBM Cloud Migrations
    • Training Courses
    • IFRS 16
  • Support
  • Fast Financials
  • Knowledge Share
Get in touch

Aramar Knowledge Share Documentatation

IBM Planning Analytics

  • Configuring display data row limit in Planning Analytics for Excel
  • Mapping the CSV data source directory in Planning Analytics on Cloud
  • DimensionExists (TI)
  • Increase maximum login attempts in Planning Analytics on Cloud
  • Mapping a Network Drive between Live and Development in Planning Analytics on Cloud
  • Moving Databases in Planning Analytics
  • Overriding Element Weights from a TI process
  • Home
  • knowledge-share
  • IBM Planning Analytics
  • Overriding Element Weights from a TI process

Overriding Element Weights from a TI process

I did some work this afternoon to override the weights on elements by loading them in from a csv file. Thought you might find the code useful. You can set the weights manually in the dimension editor but I find that rerunning the associated TI process sometimes wipes what I did. So wanted to do from the process instead. 

  

Basically, I added a column to the csv file that built the chart of accounts dimension. This column was called ‘Weight Override’. I filled it in with -1 where I wanted the subtotal to subtract the number.  I set it to ‘String’ and ‘Other’. On the metadata tab below autogenerated section, I wrote the code as follows…. 

  

#For those which have the weight override column populated, delete it from its parent and re-insert it with the override column weight. 

IF(vWeightOverride@<>”); 

  #Convert the weight override column to a numeric value as its currently set as a string 

  vWeightNumeric=Numbr(vWeightOverride); 

  DimensionElementComponentDelete(‘CoA PLC’,vPArent,vChildConv); 

  DIMENSIONELEMENTCOMPONENTADD(‘CoA PLC’,vPArent,vChildConv,vWeightNumeric); 

Share This Article :
  • Facebook
  • Twitter
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on June 21, 2022
Moving Databases in Planning Analytics

Powered by BetterDocs

Aramar

We deliver expert consultancy services, supply software licences on behalf of IBM and offer training and technical support across the complete IBM Analytics suite.

Contact us today

Useful Links

  • About Aramar
  • How can we help?
  • IBM Analytics Suite
  • Services
  • Training Courses
  • Case Studies

Contact Us

0330 1242797
contactus@aramar.co.uk

Registered Address:

124 City Road,

London,

EC1V 2NX

Stay Connected

Keep up to date with industry insights and latest news

© Aramar 2022.

Terms of use Privacy Policy

Marketing by Unity Online