TM1 Forum

here is my small code..... Get it my vLOB from source ,and compare with my attribute ,if two are matches then,get that element associated attribute and finally i am using that element as my LOB while doing data....i think it might be understandable .....Thanks again everyone ...the forum is awesome ...

I really appreciated your help on this,i have got an answer and i impletemented ...thanks again your all suggestions.

Thank you so much alan,but my existed text attribute element used for dfifferent purpose ...so i cannot change that to alias..so is there any another solution that i can use for it.....

Really appreciated your support if anyone can help me on this with your past experience. I have a text file source that has all the account numbers in numeric, and all these numeric numbers are part of my dimension as text attribute, so I while I load the data with respect of my account numbers amon...

How many such different ID's do you have ? Because you could use a temporary dimension, do a DIMENSIONELEMENTINSERT, and then check (DIMIX = 0 or not ) if the element (ID) in the temporary dimension or not. In the Epilog you remove the temporary dimension again. A temporary dimension is a good way ...

Thanks a lot for your prompt reply Wim Gielis and TrevorGoss .

My source is my transaction logs converting into text file and using that a source.
from my transaction logs (.txt) i need to get users ids...so still i can create temp dim.....Please help on this.Thanks in advance

Hi All Gentle mans ,its pleasure to write an email bcz i see, well prompt responses each others...really i say thank to this forum.... I have a problem in TI Process: I have users data want to store into text file,so ,i am writing TI Process script using asciioutput function into text file,but the i...

Thanks Edwart,
How to incorporate can you please help by altering the line that i shared

SubsetCreatebyMDX(vSubName,'{EXCEPT({ TM1SUBSETALL( ['|vDimName|'] )},{ [Tata], [Ticky]) })} ; While i am excuting my TI process with above line of code i am getting the below error can someone help me as its urgent error: Error: Prolog procedure line (22): Could not create dynamic subset: Level or ...

IE8 browser and yes admin host and server name are settuped sir.

EvgenyT wrote:1. What is the browser being used?

2. Did you set up OpsConfig.xml with admin host and server name?

Thank you

Evgeny

yes i did sir

Hello Sirs,

i am getting the following attached error and i have done the following ways though i am not able to resolve the issue,pls help as its burning for me to resolve.

i done this :http://www-01.ibm.com/support/docview.w ... wg21585781
and also i restarted my system not working

Hello lotsaram, i clearly understood what Alan's posted, BUT the problem is the following: I am getting the data with combination of the following ex: $100.00 $2,10,120.00 1000.10 2000.00 so if i choose the data type of the variable as numeric only i am able to load the numeric data BUT my business ...

Does any one has any idea? can it be done in TI?

Hi Alan Sorry i just had the attached screen from my example as i was not able to share the original data BUT what i mean to say is i am using oracle datasource and and the data is coming in the attached formats and i used the variable type is string for quantity,quantity1 and also contents i used a...

Hi Alan, Thanks per the quick reply As this data is coming from oracle like below format only.there i can't change so is there any way to do changes in TI in data tab??? please suggest Hello: My data is coming in the following format Quatity = 2,10,000.00 Quatity1 = 3,33,000.00 BUT as per my require...

Hello:
My data is coming in the following format
Quatity = 2,10,000.00
Quatity1 = 3,33,000.00
BUT as per my requirement I have to have minus
Amount= Quatity 1-Quatity
So If I use the above formula in the data tab (attached screen)
I am getting the attached error. Can you any help really appreciated.

hello declanr:
Thanks for your reply .i think your not got my query.
when iam starting after recreated the "Tm1 server instance" from IBM cognos configuration ia m getting the that attached error.
Pls let me know if your still didnot understand.

Hi All,
Please find the attached issue and really appriciated if anyone can help me?
tm1 version is 10.1.1

Thanks lot david ur valuable reply BUT
As we are getting the some zero values for that i want to ommit the zero values and only non zero values i plan to load it as this process is talking 10 hours to load completly as table is having 1+ crores records.so this is approach correct?