TM1 Forum

HighKeys

Thats more then genuis! Got some time to try it, and love it! Thanks for sharing wim!

HighKeys

Please post your TI code.

HighKeys

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!

HighKeys

As i know, it's more performant if you loop though a view rather then using CellPutN(CellGetN(.....)....);

But yes would also work.

HighKeys

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

HighKeys

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...

HighKeys

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...

HighKeys

Hi,

200gb space on Harddrive or in RAM?

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

BR

HighKeys

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...

HighKeys

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...

HighKeys

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

HighKeys

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 ...

HighKeys

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

HighKeys

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...

HighKeys

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...

HighKeys

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...

HighKeys

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

HighKeys

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....

HighKeys

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...

HighKeys

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...

TM1 Forum

Search found 97 matches

Re: }Stats cubes tools

Re: Excel SumIF in TM1

Re: Excel SumIF in TM1

Re: Excel SumIF in TM1

Re: Excel SumIF in TM1

Re: Turbo Integrator - Decativate Feeder evaluation while process runs

Turbo Integrator - Decativate Feeder evaluation while process runs

Re: Windows Server errors ERROR_NOT_ENOUGH_MEMORY ERROR_NO_SYSTEM_RESOURCES

Re: Expand function with numbers

Re: TM1 C# RestAPI - Recive Passport from BI Gateway?

Re: DBS should fail, hard!

Re: Turbo Integrator - Data tab dont run?

Re: Display multiple rows in email message

Re: Sending html email using TI

Re: Turbo Integrator - Data tab dont run?

Re: Turbo Integrator - Data tab dont run?

TM1 C# RestAPI - Recive Passport from BI Gateway?

Re: Turbo Integrator - Data tab dont run?

Turbo Integrator - Data tab dont run?

Re: SQL Query Length Limit for TI