Search found 97 matches

by HighKeys
Wed Aug 05, 2020 10:29 am
Forum: Useful code, tips and tricks
Topic: }Stats cubes tools
Replies: 4
Views: 1144

Re: }Stats cubes tools

Thats more then genuis! Got some time to try it, and love it! Thanks for sharing wim!
by HighKeys
Wed Aug 05, 2020 10:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel SumIF in TM1
Replies: 9
Views: 318

Re: Excel SumIF in TM1

Please post your TI code.
by HighKeys
Wed Aug 05, 2020 10:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel SumIF in TM1
Replies: 9
Views: 318

Re: Excel SumIF in TM1

MarenC wrote:
Wed Aug 05, 2020 9:42 am
....
But generally speaking wanting the total sum of an element in a cube for a given measure is what TM1 is designed for, at least in my mind it is!

Maren
Yea totally agree! :geek:
by HighKeys
Wed Aug 05, 2020 9:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel SumIF in TM1
Replies: 9
Views: 318

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.
by HighKeys
Wed Aug 05, 2020 8:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel SumIF in TM1
Replies: 9
Views: 318

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
by HighKeys
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: 345

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', ' '); This...
by HighKeys
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: 345

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...
by HighKeys
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: 1065

Re: Windows Server errors ERROR_NOT_ENOUGH_MEMORY ERROR_NO_SYSTEM_RESOURCES

Hi,

200gb space on Harddrive or in RAM? :D

I think the error is from the RAM not from the discspace.


BR
by HighKeys
Wed Jul 15, 2020 9:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Expand function with numbers
Replies: 13
Views: 1103

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...
by HighKeys
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: 238

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...
by HighKeys
Wed Jul 08, 2020 8:39 am
Forum: Enhancements
Topic: DBS should fail, hard!
Replies: 9
Views: 773

Re: DBS should fail, hard!

Wim Gielis wrote:
Mon Jul 06, 2020 10:21 am
Alan Kirk wrote:
Mon Jul 06, 2020 8:59 am
14 and counting. When does our bet money arrive in our accounts?
When IBM have implemented it 😉
So never :lol:
by HighKeys
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: 503

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 ...
by HighKeys
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: 186

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
by HighKeys
Tue Jul 07, 2020 11:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sending html email using TI
Replies: 1
Views: 213

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...
by HighKeys
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: 503

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 = '"'; Da...
by HighKeys
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: 503

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...
by HighKeys
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: 238

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
by HighKeys
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: 503

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... here is it....
by HighKeys
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: 503

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...
by HighKeys
Thu Jul 02, 2020 10:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query Length Limit for TI
Replies: 10
Views: 593

Re: SQL Query Length Limit for TI

why you dont create a SQL View and just import the View? Better yet, use a stored procedure. Each individual INSERT INTO statement is going to have to be compiled before execution. Depending on how often you call the query this can really add up. Stored procedures don't have to be compiled each tim...