Hi Samiasz!
you should post how your time dimension is structured in both cubes.
TM1 has time and date functions in TI.
https://www.ibm.com/support/knowledgece ... tions.html
BR
Search found 118 matches
- Fri Jan 22, 2021 12:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: loading data into 12 months
- Replies: 1
- Views: 1937
- Wed Aug 05, 2020 10:29 am
- Forum: Free And Open Source Tools
- Topic: }Stats cubes tools
- Replies: 4
- Views: 35650
Re: }Stats cubes tools
Thats more then genuis! Got some time to try it, and love it! Thanks for sharing wim!
- Wed Aug 05, 2020 10:28 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel SumIF in TM1
- Replies: 9
- Views: 4080
Re: Excel SumIF in TM1
Please post your TI code.
- Wed Aug 05, 2020 10:05 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel SumIF in TM1
- Replies: 9
- Views: 4080
- Wed Aug 05, 2020 9:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel SumIF in TM1
- Replies: 9
- Views: 4080
Re: Excel SumIF in TM1
As i know, it's more performant if you loop though a view rather then using CellPutN(CellGetN(.....)....);
But yes would also work.
But yes would also work.
- Wed Aug 05, 2020 8:06 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel SumIF in TM1
- Replies: 9
- Views: 4080
Re: Excel SumIF in TM1
Hi,
first you have to create a view then subsets for all dim's, after this you can loop though the view and calculate what you want.
For sum if just is an If, like
If(vDimforColA @='India);
nSumIf = nSumIf + 'India';
EndIf;
best Regards
first you have to create a view then subsets for all dim's, after this you can loop though the view and calculate what you want.
For sum if just is an If, like
If(vDimforColA @='India);
nSumIf = nSumIf + 'India';
EndIf;
best Regards
- Thu Jul 30, 2020 8:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Turbo Integrator - Decativate Feeder evaluation while process runs
- Replies: 5
- Views: 3120
Re: Turbo Integrator - Decativate Feeder evaluation while process runs
Hi Elessar! Thanks for your fast answer!, So i have to create a empty Rule file in the datadirectory, then i load this empty file, start the transfer, after complete the transfer i add " RuleLoadFromFile (cCube, '');" to load the original Rule? The IBM Docs says: RuleLoadFromFile('Sales', ...
- Thu Jul 30, 2020 7:27 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Turbo Integrator - Decativate Feeder evaluation while process runs
- Replies: 5
- Views: 3120
Turbo Integrator - Decativate Feeder evaluation while process runs
Hello Community, i try to transfer many data in a process, one of the cubes feeds many others, so the transfer runs endless cause the feeder evaluation starts after adding one value into it (thats was i think), The process runs fine before i changed my feeder model (reduces heavy overfeeding -8 GB R...
- Wed Jul 15, 2020 1:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Windows Server errors ERROR_NOT_ENOUGH_MEMORY ERROR_NO_SYSTEM_RESOURCES
- Replies: 9
- Views: 8180
Re: Windows Server errors ERROR_NOT_ENOUGH_MEMORY ERROR_NO_SYSTEM_RESOURCES
Hi,
200gb space on Harddrive or in RAM?
I think the error is from the RAM not from the discspace.
BR
200gb space on Harddrive or in RAM?
I think the error is from the RAM not from the discspace.
BR
- Wed Jul 15, 2020 9:26 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Expand function with numbers
- Replies: 13
- Views: 9746
Re: Expand function with numbers
Hi, Its a lil bit advanced here, but may i find the tree in the forest :lol: Why you dont just do it like that: nStart = NOW(); Sleep(2000); #your code here... nRunTime = FormatDate( NOW() - nStart, 'ss', 0 ) ; ASCIIOutput('C:\Datetime.txt', nRunTime ); nRunTime Output is 02. So you could calulate M...
- Fri Jul 10, 2020 8:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 C# RestAPI - Recive Passport from BI Gateway?
- Replies: 2
- Views: 1609
Re: TM1 C# RestAPI - Recive Passport from BI Gateway?
Hi ascheevel! Thanks for your response, thanks for the hint with TM1py, i will check them out, as i know its open source so may i can port the part to my C# project. And i found i can trigger python in C# so may i can combine them :) Looking at your post history, it looks like you have experience ge...
- Wed Jul 08, 2020 8:39 am
- Forum: Enhancements
- Topic: DBS should fail, hard!
- Replies: 9
- Views: 55177
Re: DBS should fail, hard!
So never
- Tue Jul 07, 2020 1:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Turbo Integrator - Data tab dont run?
- Replies: 9
- Views: 3987
Re: Turbo Integrator - Data tab dont run?
zeroSuppression is turned on - so the Wert<>1 gives you only the values that are eg 0.1 or 2 ...... you will not see the zero values Thats correct! I just want to see Cells thats not 100 % and not 0% so something between (Its a matchtable and in Sum it should reach the 100%) For sure i think i can ...
- Tue Jul 07, 2020 11:32 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Display multiple rows in email message
- Replies: 1
- Views: 1125
Re: Display multiple rows in email message
As i wrote in your other thread, you can build the HTML Table in the TI with ASCIIOutput.
https://www.tm1forum.com/viewtopic.php?f=3&t=15399
BR
https://www.tm1forum.com/viewtopic.php?f=3&t=15399
BR
- Tue Jul 07, 2020 11:31 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Sending html email using TI
- Replies: 1
- Views: 2065
Re: Sending html email using TI
Hi, somwhere from the Forum here.. You have to edit the HTML code inside the TI, the E-mail was sent over SMTP via VBS. Prolog: # set empty string as quote char DatasourceASCIIQuoteCharacter = ''; # set filename sFileName = 'D:\Planning_Analytics\Extra_Scripts\send.txt'; # header sHtml = '<html><hea...
- Tue Jul 07, 2020 11:16 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Turbo Integrator - Data tab dont run?
- Replies: 9
- Views: 3987
Re: Turbo Integrator - Data tab dont run?
Hi Orlando, sure i can post the original process, the DataCount is for counting the not 100% Values, but i think i should use a boolen or just 1 or 0, cause its just for the E-mail Output (Errors found or not) Prolog: #Output Setup sRunID = STR( NOW(), 8, 5 ); DataSourceAsciiQuoteCharacter = '"...
- Tue Jul 07, 2020 9:36 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Turbo Integrator - Data tab dont run?
- Replies: 9
- Views: 3987
Re: Turbo Integrator - Data tab dont run?
Hey, i got some more details, i made the check manually and compared it to the csv output from the TI Process. Seems to be ok, but the output Value thats get logged is '1'. I think this is very weird but it worked for me sValue = NUMBERTOSTRINGEX(Wert,'#.##############', ',','.'); nValue = StringToN...
- Tue Jul 07, 2020 5:56 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 C# RestAPI - Recive Passport from BI Gateway?
- Replies: 2
- Views: 1609
TM1 C# RestAPI - Recive Passport from BI Gateway?
Hello Community, i have a question which i can't find online, so i will open up a new topic. Does anybody already tried to Login the TM1 via SSO BI Gateway per RestAPI? Or anybody has an idea how to do that? May open a browser, use the autologin and check the cookies for the passport? Thanks and BR
- Fri Jul 03, 2020 1:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Turbo Integrator - Data tab dont run?
- Replies: 9
- Views: 3987
Re: Turbo Integrator - Data tab dont run?
Hi! thanks for the fast replay, sounds genuis! How can i deactivate "SkipConsolidatedElements" in a TI Process when i create the view there? Edit: Found it.. Sorry! ViewExtractSkipRuleValuesSet (Cube, ViewName, Flag); Edit 2: nvm its for rule values, didnt read right... Edit 3: ok..ok... h...
- Fri Jul 03, 2020 1:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Turbo Integrator - Data tab dont run?
- Replies: 9
- Views: 3987
Turbo Integrator - Data tab dont run?
Hello Community, i have a issue with a TI that i created yet, first i create a View and some subsets and assign them to the view, works pretty well. The View looks like what i need, now i used this view as Datasource and want to create a ASCIIOutput log if the Value is not 0 or 1. But the Datatab ne...