TM1 Forum

Hi gtonkin, Thanks for the help !!! I Used the method suggested by you just a tweak instead of using Sales Measure as a Dimension I Created a Variable Dimension in which i have Element from V1 to V57 and there in Attribute i am storing the Header Value with this it Makes my Code more Dynamic so that...

Hi gtonkin, That part is okay but how i need vElement and VData side by side is a problem i achieved this by hardcoding for the title record. but don't want to hard the title record as well. Expected output which i need which i got after hardcoding the title like IF(Count=1); vElement1=v1; Endif; th...

ExpandFunctionTesting4.txt Now the issue is that 1 Row is My Element Name in Dimension and from 2 Row it is data to be uploaded in specific Element which is in 1row taking example of one element only so now in my dump it is 1 "Pipeline Project Description" 2 "DFADFA" I want it t...

Attached Files of Dump by TextOutPut :

Hi Team, I have a CSV in which I have 20 Columns and this can change in future that is the reason I want to make a dynamic TI. So that in future if some added more columns then it should directly pick no need to add more hardcoded rows. CSV as Source.png Data source Tab screenshot in TI. TI Data Sou...

If there is 1000 in combination of 1101 in debit side it should cellputn the 1000 in % wise in 9111. Credit side eg.(250).9112. Credit side eg.(250).9113. Credit side eg.(500). In this 3 combination how should i proceed further.


Thank you all

Hi All, I have two cube 1 Profit&loss cube (pl) second allocation or mapping cube. Pl i have 8 dimensions Mapping cube 4 dimensions In pl cube debit side is rule calculated and i have employees who occur this cost and a corporate to whom i will allocate the cost in credit side. Now suppose there...

thank you tomok and wim,

I used while for my problem it's working fine speed is also good as the data set is in thousands only.
If further, I do the same without a loop I while post the solution here.

Thank you.

Hey wim, i want to do a cellputn it has more than 10 lakh records but to load data i have a condition. condition is if my column b which is a country name in the data source is equal to h_region attribute which contains the country name To fetch all the attribute names i can use while as i have 100 ...

ncounter=1; vDimsiz=DIMSIZ('h_region'); While(ncounter<=vDimsiz); velement=DIMNM('h_region',ncounter); vCountryAttrs=Attrs('h_region',velement,'ABC'); ncounter=ncounter+1; Asciioutput('E:\Test.csv',vCountryAttrs,numbertostring(vDimsiz),velement); End; this gives me proper result but if i write the A...

Hey Wim,

I used a loop it works fine to fetch data against attribute but is it a good practice to write the condition and cellputn in the same loop to load the data at the same time.

I have made an Attribute named ABC in my dimension and when running the ti it gives the following error.
Error: MetaData/Data procedure line (5): Attribute "ABC" not found.

Thank You.

i think i have not properly explained the scenario data source is odbc which has 3 columns in which there is a country column also which i have to match with an attribute of a dimension named region which has codes as elements for every code a country is defined using text attribute. now before cell...

This a new function has anyone used it I wanted to use this to directly fetch the data stored in the attribute against elements. my scenario is like in data source I am fetching data from odbc which has 3 columns e.g sr.no country(vcountry) rate so I have 1 brazil 30. I have dimension Region which h...

Hi Declanr

I want to take unique elements only if it's blank or repeated I want to skip it you are making all the 12 unique your code is perfect if someone wants to insert all the 12 hierarchies.

Thank you

There are 12 columns group 1, group 2, ... group 12.which will make hierarchy. Twist is I also have to write a 2 conditions that If group 1 is equal to group 2 than only take group 2 skip the group 1. And also one more condition that If group 1 is blank then skip it and jump to group 2. And this com...

Hiii team, I have a urgent requirement for this. I have flat file in which there are 10-15 columns To update the dimension 1column = N level elements. And remaining are 12 columns in which the parent info is given. Fir example consider the heading of other columns from group 1 to group 2. A hierarch...

hey bunchukokoy,

Did you solved this problem i am also facing the same problem.

if you have solved this can you please share the solution.

thank you.

Hey PlanningDev,

Can you please elaborate the TM1RunTI.exe part i didn't understand it clearly.

I Have never used TM1RunTI.exe i only know the concept of it that with the help of it i can run my TI in multiple Threads.

Thanks
Manpreet

Hey Team, the Logic I am applying to get the user the remaining time *****last time the process took this much time****** i have start time === 1 pm i have end time ==== 1.10 pm time taken ==== 10 mins now when i will run the Ti again i know a estimated time of 10 mins now what i want actually is th...