TM1 Forum

Hey, so i have an interface whcih allows users to input items which will be added to a dimension, I have in my control cube an element called "Sequence" with a numeric value of 1. I have an attribute in the dimension called "ID" now when the TI runs I want to take that 1 and make...

So I created an entry template In the rows I have the entire item hierarchy. I need to add a filter at the top which allows the user to filter by 2 different attributes (program, selling type) I know I can use an max so that is creates a dynamic subset based on the attribute filtered...but in the fi...

I have to write a process that basically gets a month from a user and copies data into a new book from that date and twelve months onward. Im using a cellgets to get the month I need, But in the cellputN for the period, Im not sure how to do it. Im assuming i need a variable that takes the user ente...

So I am writting a TI process for my finance cube. it is pulling the acqusition or dispostion month from another cube. IF the date is within the last 365 days. meaning the acqusition date for company x is april 2020, then I want data to be loaded into the Acqusition book from april 2020 - april 2021...

Hey , so I need to create a rolling average for the past 3 months. I am trying to get the current month (In dimension as 'mmm YYYY' for example 'Jan 2021' I Am Using this sCurrentMonth = ATTRS(sDim, (TIMST('\M') | (SUBST(TODAY(1), 1, 4))), 'PriorPeriod'); The (TIMST('\M') | (SUBST(TODAY(1), 1, 4))) ...

thank you

Hey guys, I have the following code for creating zip folders(data,applogs,etc) in the zip folder I want it to create zip folders with the timestamp The commented line #ExecuteCommand( strBATCall, 1 ); creates the zip folder succesfully the uncommented executecommand runs but does not create anything...

Hey guys, I am new to coding and even newer to tm1. I am trying to achieve this in the ti process and i knwo how to in excel so bascally in excel if i have a list of cells that have "... : ..." and i want all the characters to the right of the ':' character i would do a right and find. I a...

Hey, New to tm1 here. So i wrote a ti process that allows me to cpy data from one scenario to the other. I could copy from one year in the source to another in the target. And like that copy from different months/accounts whatever . But I am only able to copy into a leaf level element (copy from 201...

Hey, again im very new to tm1 and coding in general so my quesiton may be very simple. I need to basically copy data from onoe scenario (exampl: actual) to another scenario (budget) what i did was decalre two parameters (pSourceScenario, pTargetScenario) I am confused as to how to actually use them ...

Hey guys, I have created filtered subsets using the code below (i am new to tm1 so it may be somehwat sloppy) I was wondering if there is a way i could do this using a while loop? IF(vCatDir @= 'Filter by Category' % Scan ('*',vCatDIR) =1); ITEMSKIP; ENDIF; sSub ='zzzCD-CAT'| vCatDIR; #=====Create S...

I wrote an mdx statement sMDX= '{ DRILLDOWNMEMBER( { DRILLDOWNMEMBER( { DRILLDOWNMEMBER( {TM1FILTERBYLEVEL( {TM1Subsetall()}, 2)}, {[Category_Test].[category director]} ) }, {[Category_Test].[category 2]} ) }, {[Category_Test].[category 3]} ) }'; if(SUBSETEXIST(sDim,sMDX)=1; subsetdestroy(sDim,sMDX)...

I appreciate the response,
I am pretty new to this so i apologize for the ignorance
however, I did make progress with it and i think i was able to complete what i wanted

can someone help me I have to create a subset using an mdx i have to write a TI process that creates subsets for each level I am new to this so sorry for the basic question Basically i have three drop downs, 1 is a category director, 1 is category, and the last is category use. I have to create a dy...