TM1 Forum

nice parameter...

Alan,
love your story...

Hi,
Just wondering if there's any Malaysian in this forum?
Would love to form a group and have some nice Teh Tarik sessions!
Cheers!

Tell me about it... Currently i'm no longer in development.. I'm doing support for their TM1 application... Yes, the above mentioned bank..

Currently in my new project they insisted on having tm1 workflow.. the tm1 server is 9.5.2... can i install workflow 10.1? and i dont really understand how to make this workflow works... *dumbfounded*
HELP!!!!!

Hi Alan, Appreciate your post replies! the thing is now the SQL is none of my business... (haha! its from the client side) i tried If ( ~LONG (sChild) =0); in order to eliminate any nulls.. so far so good.. as i blank the cell in the csv for testing purposes... what say you? would it apply the same ...

Bravo Alan Kirk!

actually the .csv files is for testing purposes.. :( i just discover that the real procedure is DIRECTLY from SQL server... with a void, null value (neither string or numeric and yeah as what u explained earlier...).. from what i understand the SQL server will show 'NULL' for void when doing query i...

Thanks Alan!
Great Help!!!

btw.. just wondering, what if the 'NULL' (a string NULL) is a real null value (real blank)... scan doesnt work anymore right?

yup.. i already did and manage to solve it... Love the helps this forum provides.. Superb!

http://www.tm1forum.com/viewtopic.php?f=3&t=7094

I really appreciate all the helps above. This topic can be closed.
SOLVED!!! WoooHooo!!!

Thanks!
btw, i just discover on the ~Scan code..
can someone elaborate more on this?

hai,
tried the code.. the error occurs only on the last loop on on the last relationship. happens before. not sure why.
attached is the output of the coding... it stills pickup the 'NULL's as element.

Wow.. thank you so much!
I will try it soon!!!

sorry for the miscommunication. Yes, its a dimension called 'CostElement' within the dimension, there'll be two consolidation Operating Cost and Non-Operating Cost. The rest will continuously become consolidation until it reaches the last column whereby it will become element. Please help me with th...

Refer to the image below (data received in.csv file) Can somebody help me on how to create a subset called ' CostElement ' and later insert 2 subsets ( Operating Cost and Non-Operating Cost ). For Operating Cost , the should be 4 subsets ( Internal Gas Consumption , Plant Utilities , Repair & Ma...

& = AND eg (Value1 > 5) & (Value1 < 10) Returns TRUE if the value is greater than 5 and less than 10. % = OR eg (Value1 > 10) % (Value1 < 5) Returns TRUE if the value is greater than 10 or less than 5. ~ = NOT eg ~(Value1 > 5) Equivalent to (Value1 <= 5) Gee Thanks.. i know i'm bit outdated...