Search found 88 matches

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: 83

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: 6
Views: 174

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: 172

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: 63

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: 86

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: 172

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: 172

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: 83

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: 172

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: 172

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: 221

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

Re: SQL Query Length Limit for TI

Hi,

why you dont create a SQL View and just import the View?

You can also build 2-6 or more views and combine them to one view for the import.

Thats how we handle big SQL Statements to bring it into a Importable format for TM1.

BR
by HighKeys
Wed Jun 03, 2020 6:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Different calculation for same Elements
Replies: 3
Views: 215

Re: Different calculation for same Elements

Hi declanr,

thanks for the fast answer, thats very bad :( we don't use the hierachy system at the moment (Its a point on my todo list), so if i understand you right my only opinion at the moment is to create a smiliar "Abwesenheiten" element for the ""Calculation B" correct?


Thanks!
by HighKeys
Wed Jun 03, 2020 6:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Different calculation for same Elements
Replies: 3
Views: 215

Different calculation for same Elements

Hi there! i'm stucking with a simple thing, but can't find the answer since 2 days... Hopefully you can help me. I'm using a C Element called "Abwesenheiten" in 2 different consolidations, so i would need 2 different calculations behind, the calculation is not the problem but whats the right IF to c...
by HighKeys
Mon Apr 27, 2020 11:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ConsolidatedMax
Replies: 10
Views: 1633

Re: ConsolidatedMax

Hi Markus, thanks for your reply. Yes, my "solution" is a mix of both, consolidatedmax & consolidate children. Definitely very ugly, but it seems to work. It's going something like this: IF(DTYPE( 'WS_POS', !WS_POS) @= 'C' & DTYPE('WS_Marke', !WS_Marke) @= 'N' & DTYPE('WS_Warengruppe', !WS_Warengru...
by HighKeys
Thu Apr 23, 2020 10:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException
Replies: 16
Views: 815

Re: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

Do you got some infos in the browser console?

Which browser are you using?

Whats happen if you try it in the browser at the server directly?

If everything working just the Database Tree not?
by HighKeys
Thu Apr 23, 2020 9:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException
Replies: 16
Views: 815

Re: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

Hi,

is it a fresh installation on this machine?

Try to clear your cookies and browser cache.

BR
by HighKeys
Thu Apr 23, 2020 9:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Element Security - Hide Element in Dimension in a specific Cube
Replies: 3
Views: 252

Element Security - Hide Element in Dimension in a specific Cube

Hello TM1 Heads, i searching since a while a way to hide specific elements in a Dimension for just some specific cubes. As an example: We use different Cubes for Forecasting and History and merge them in a reporting cube for the total view. In each cube we use the same "Version" Dimension but i dont...
by HighKeys
Thu Apr 23, 2020 9:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Single Sign On problem
Replies: 4
Views: 1931

Re: Single Sign On problem

Hello svar229,

some more information would be useful. Is your TM1 Adminhost and Cognos Analytics at the same server/machine ?


If not can you telnet the ip and port of the CA from the Tm1 Server?

Which LDAP u use?

BR
HighKeys
by HighKeys
Fri Mar 20, 2020 12:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Zero Suppression and Undef
Replies: 2
Views: 258

Re: Zero Suppression and Undef

In the same Cube, i tried to get an AVG in a C Element but it also count the 0 values.

Code: Select all

C:ConsolidatedAVG(2, 'Personaleinsatz-Reporting', !Tag, 'HR', !MA-Pool, !Kennzahlen Personaleinsatz-Reporting);
Flag is Set to 2
consolidatedAVG.PNG
consolidatedAVG.PNG (2.85 KiB) Viewed 236 times