Search found 6 matches

by samiamsz
Thu Sep 17, 2020 3:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copying data TM1
Replies: 1
Views: 107

Copying data TM1

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...
by samiamsz
Wed Sep 16, 2020 4:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Passing data from one cell to another
Replies: 2
Views: 143

Passing data from one cell to another

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 ...
by samiamsz
Mon Sep 14, 2020 12:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating a subset with a while loop
Replies: 2
Views: 165

Creating a subset with a while loop

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...
by samiamsz
Tue Sep 08, 2020 3:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using a loop to check an mdx
Replies: 1
Views: 123

Using a loop to check an mdx

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)...
by samiamsz
Fri Sep 04, 2020 11:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: create report filters that are cascading
Replies: 3
Views: 186

Re: create report filters that are cascading

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
by samiamsz
Fri Sep 04, 2020 10:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: create report filters that are cascading
Replies: 3
Views: 186

create report filters that are cascading

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...