Search found 26 matches

by Emixam
Tue Aug 13, 2019 3:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy cub files
Replies: 4
Views: 364

Re: Copy cub files

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". ...
by Emixam
Wed Aug 07, 2019 5:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder Issue Help Needed
Replies: 7
Views: 256

Re: Feeder Issue Help Needed

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.

Code: Select all

['Full Revenue'] => DB('AR cube',...,...,...,'Last 3 Month Sales');
by Emixam
Wed Aug 07, 2019 2:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder Issue Help Needed
Replies: 7
Views: 256

Re: Feeder Issue Help Needed

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 :

Code: Select all

['Full Revenue'] => DB( sCube, ..., ..., 'Last 3 Month Sales');  
But like I said, there will be overfeed .
by Emixam
Fri Aug 02, 2019 8:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic query argument in TI...
Replies: 9
Views: 2968

Re: Dynamic query argument in TI...

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...
by Emixam
Thu Aug 01, 2019 2:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic query argument in TI...
Replies: 9
Views: 2968

Re: Dynamic query argument in TI...

I didn't know that. But even if I remove the '', I still get the error message.
by Emixam
Thu Aug 01, 2019 1:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic query argument in TI...
Replies: 9
Views: 2968

Re: Dynamic query argument in TI...

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...
by Emixam
Tue Jul 30, 2019 12:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: how to map dimension between unknow cube?
Replies: 2
Views: 187

Re: how to map dimension between unknow cube?

Hi,

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

Cheers !
by Emixam
Mon Jul 29, 2019 7:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: moving data from any cube to any cube by TI process
Replies: 9
Views: 465

Re: moving data from any cube to any cube by TI process

I didn't know !

Kudos to the guy who built that process !

Thanks Lotsaram !
by Emixam
Mon Jul 29, 2019 1:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: moving data from any cube to any cube by TI process
Replies: 9
Views: 465

Re: moving data from any cube to any cube by TI process

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...
by Emixam
Wed Jul 24, 2019 6:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Overwriting Browser Language for TM1Web
Replies: 1
Views: 237

Re: Overwriting Browser Language for TM1Web

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
by Emixam
Sun Jul 07, 2019 11:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to configure TM1WEB to access from other network
Replies: 5
Views: 973

Re: How to configure TM1WEB to access from other network

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...
by Emixam
Thu Jul 04, 2019 1:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: forecasting
Replies: 2
Views: 207

Re: forecasting

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...
by Emixam
Wed Jul 03, 2019 1:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: difference between prolog, metadata, data, epilog
Replies: 13
Views: 9354

Re: difference between prolog, metadata, data, epilog

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...
by Emixam
Tue Jul 02, 2019 4:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Day of Week in TI
Replies: 13
Views: 3574

Re: Day of Week in TI

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...
by Emixam
Thu Jun 27, 2019 4:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Operators in TI : SQL IN equivalent
Replies: 7
Views: 228

Re: Operators in TI : SQL IN equivalent

You are right !! I really need to sleep!

Thanks guys !
by Emixam
Thu Jun 27, 2019 2:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Operators in TI : SQL IN equivalent
Replies: 7
Views: 228

Re: Operators in TI : SQL IN equivalent

I always neglect this function !!

You reversed the parameter ..

SCAN( sFindMe, sScanMe );

Code: Select all

IF(nAmount > 0 & SCAN( 'ABC', sCode ) > 0 );
	#Do Something
ENDIF;
Thanks Ty !

EDIT: Here's the correct code:

Code: Select all

IF(nAmount > 0 & SCAN( sCode, 'ABC' ) > 0 );
	#Do Something
ENDIF;
by Emixam
Thu Jun 27, 2019 1:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Operators in TI : SQL IN equivalent
Replies: 7
Views: 228

Operators in TI : SQL IN equivalent

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...
by Emixam
Wed Jun 26, 2019 12:17 pm
Forum: Commercial and Events
Topic: TM1 coding extension for VSCode
Replies: 9
Views: 1331

Re: TM1 coding extension for VSCode

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!