TM1 Forum

hi, i dont need like concatenating h1h2h3 i need any one of the elemnts at a time i my data is like this h1,number,20 h2,number,21 for that i created two dimensions dim_house and dim_number dim_house should take either h1 or h2 or h3 at a time.... i need to hardcode this in the ti process variable t...

hi, in turbo process in variables tab i inserted a variable which tooks only three values which is supposed to be hard coded.How can i give that in formula? My variable takes only three values h1,h2,h3 i wrote like v1='H1'||'H2'||'H3'; but not working :( Can anyone tell me how to do that?? regards A...

hi,
Can any one tell me the Max limit of the records that can be handled by a turbointegrator process?
i have 8000,000+ records in acess db which has to be tranfered to the tm1 cube...
is it possible through turbo to transfer data to cube??

regards,
Angel

hi, iam extracting the date from text file in the format 12/2/2010 00:00:00 i need it in the format 12-2-10. in the variables tab i put a new variable for my required format and done like new_datevariable=date(olddatevariable,'dd-mm-yy'); IS this a correct format??i am getting olddatevariable is und...

hi wim,


now its getting populated thank you so much for your wonder ful suggestion :D

regards
angel

hi wim, i guess u didnt understand my problem. i will write what i have done in the process. my requirement is to read the username and password for an oracle datasource from a csv file , into a ti process.Using this username and password , the above mentioned process will connect to oracle db which...

hi wim , Thanku for ur detailed reply :).....(i manually created the logic in architect and understood what u have told to me :)) i am trying to load the params(like you said) cube from a csv file . what i have done isthat, in that file i created param column having elements username,password, then ...

hi wim,

i didnt get you.Can you please explain it what your trying to tell,i am a beginner in tm1.

regards,
angel

hi, this is my prolog coding in actual process. DataSourceType='ODBC'; DatasourceNameForServer='oracle'; DatasourceNameForClient='oracle'; executeprocess('user_pass_read'); DatasourceUserName=username1; DatasourcePassword=Password1; asciioutput('d:\t.txt',username1,',',password1); DatasourceQuery='s...

hi, i have a requirement like i need to take the username and password of the datasource from a file which has all these details. i have created a process which reads username and password from this file and i am trying to call those process in my actual process for reading database table i needed.....

hiiiiiiiiiiiiiii
got it workedddddddddd.thanks for alllllllllllllllllllllllllllllllllllllllllll


regards
angel

hi, i am using ms acess db.The datatype for the column field1 is 'number'. i modified the query like select * from table1 where str(Field1,1)='?P0?' (still sql is getting failed).... now i changed the default value to 1 and type of P0 to string. Can any one give any other suggestions ???? regards an...

hi,
still its not working

query is :
select * from table1 where field1=?P0?;
in advanced tab-->parameter tab
i have given parameter as P0
type as numeric
default value 1.0000
prompt question as P0

Kindly let me know any thing i have missed out


regards
Angel

hi, i cant store the data to the cube through dbs function the formula i have written is =DBS(A7,"local:Cube1","Expense","FY2009-P01","store1","Actual") the cell in which i ahve written this formula is showing a zero value... but the a7 cell i have a...

hi,
when i am using the following query

select
t1.account_category as account_category,
from
t1
where
t1.fiscal_year_number = ?Year_num?;

i am getting query failed error in tm1 while cilcking the preview .Can any suggest a solution for this?
thanks and regards,
angel

the query is working fine with the hard coded value for year_number=2010.but i have to implement it with a variable
which dynamically accepts the year

hi, i have created a parametrised query in ti process which is connecting to oracle . i defined a parameter called year_num in TI.my query is select t1.account_category as account_category, from t1 where t1.fiscal_year_number = @Year_num; but the query is not working it shows a failure status in ti ...

hi, Is there any function in turbo integrator which gives the slice of a particular cube on the excel perspective??? i know a dedicated tab is directly available in excel(explorer-->cube viewer-->slice).but i need to explore is there any function in turbo integrator which does the same function?? th...

hi, i have a requirement like i need to pull date from oracle db and display it as 'dd-mmm-yy-ddd' format.So i pulled date and day(using to_char(date,'dy')) in two separate variables from oracle and tried to concatenate in ti process .but i didnt find a function to concatenate it in the turbo integr...

hi, I am trying to create a calender dimension using excel perspective.(dim.xdi). in that my date format is like 1-mar-2010-thu. but when the dimension is getting saved , the elements (sample =1-mar-2010-thu) are displayed in the dimension editor as a numerical value(something like 45678) correspond...