TM1 Forum

Hi, There's no issue of copying (CTRL-C) a .cub file but there's a risk for sure if you cut (CTRL-X) or delete a cube. Also, don't forget to CubeSaveData(sCube) if you want to most recent data. That being said, I always ask to my collegue to "NEVER TOUCH THE DATA FOLDER WHEN THE SERVER IS RUNNING". ...

Feeders can be very confusing. I suggest you to read some documentation and also take a look at this previous thread.

https://www.tm1forum.com/viewtopic.php?t=274

In your case, the feeders should be in the Sales Detail cube.

Hi,

I didn't really look at your rules but quickly, if you don't mind about "overfeeding" your model, you should at least do something like that :
But like I said, there will be overfeed .

My preference is to set the whole query up in the local variable DataSourceQuery and then write it out to a file for debugging purposes eg: datasourcequery = 'SELECT * From A_TABLE WHERE NUMERIC_DATE <= ' | nDate ; asciioutput(test.csv',datasourcequery); Thanks David, that's what I did and it works...

I didn't know that. But even if I remove the '', I still get the error message.

Hey guys, I have a question for you ! How can I create a dynamic query based on a numeric parameter ? The following code works but I always have a "SQL STATEMENT FAIL" error message (even if i'm able to run my TI successfully). Any Idea how to bypass the error message ? SELECT * From A_TABLE WHERE N...

Hi,

Please read the Resquest for assistance guideline. You'll get a more useful answer.

Cheers !

I didn't know !

Kudos to the guy who built that process !

Thanks Lotsaram !

Hello everyone, I am new to tm1 and i want to write advance TI (a generic process) You must learn to walk before you can run. TM1 is a powerful tool but you must master basic skills before you are able to learn more complex things. You should take a look at this white paper. https://static1.squares...

Hi,

No you can't. The language settings in your web browser determine which language is used in the TM1Web interface.

https://www.ibm.com/support/knowledgece ... ation.html

Hi,

I suggest you to take a look at this previous thread :

https://www.tm1forum.com/viewtopic.php?t=12582

Enjoy !

Hi,

You should take a look at this one:

https://www.ibm.com/support/knowledgece ... users.html

Cheers !

I tried with the IP address I use to login to the VM. You know the address that appears on the top blue floating bar once you login to the VM. http://IPaddress:9510/tm1web/ Are you using SSL/TSL ? Http vs https Here's some doc: Configure the Web Tier to use custom TLS https://www.ibm.com/support/kn...

I don't know where to begin... What's the requirement ? How do they currently do their budget ? There's multiple way to create a forecast or create a budget. You basically ask how to be a TM1 consultant. If it can help you, here's the 3 main responsibilities of a TM1 consultant (I assume you are con...

Hi, Splitting processes is more a "design technique" instead of a necessity. I suggest you this white paper on the best practice to develop TM1 Turbo Integrator processes https://static1.squarespace.com/static/5268c662e4b0269256614e9a/t/5908076f725e250c6123856e/1493698418433/White_Paper_Best_Practic...

Hi, Take a look at this link for tm1s.cfg : https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_locationofthetm1s.cfgfile_n15038e.html And this one for more explanation on the UseExcelSerialDate parameter: https://www.ibm.com/support/knowledgecenter...

You are right !! I really need to sleep!

Thanks guys !

I always neglect this function !!

You reversed the parameter ..

SCAN( sFindMe, sScanMe );
Thanks Ty !

EDIT: Here's the correct code:

Hello, What's the best way to do this SQL code in a TI ? WHERE nAmount > 0 AND sCode IN ('A', 'B', 'C') I was thinking about something like this : IF(nAmount > 0 & (sCode @= 'A' % sCode @= 'B' % sCode @= 'C') ); #Do Something ENDIF; But i'm not sure how TM1 handle the parenthesis. This next code wor...

There's an issue with the CarpeDatum Dark color theme on the new VS Code version (1.35). Simply change the color theme (File-­>Preference->Color Theme -> Dark+) and you'll see the syntax highlighting.

Cheers!