Search found 97 matches

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

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

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

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

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

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

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

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

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

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 339 times
by HighKeys
Fri Mar 20, 2020 9:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Zero Suppression and Undef
Replies: 2
Views: 361

Zero Suppression and Undef

Hello Community, i'm woundering how to solve the issue that 0 values calculated in Rules are still get showed in a Zero suppressed View, i found in the docs i could assing the "Undef" Value (which means no data input and not a real 0 (it would be data input), if i understand it right). But now the V...
by HighKeys
Tue Mar 17, 2020 1:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX connection to TM1 server
Replies: 4
Views: 653

Re: PAX connection to TM1 server

If you follow the link you speak of it seems to relate specifically to the Ops Console (which is deprecated in v2.0.9). I think that if IBM had decided to deprecate CAM security for TM1 then would significant push back to say the least. It's a pretty significant component. Granted the link to the d...
by HighKeys
Tue Mar 17, 2020 11:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX connection to TM1 server
Replies: 4
Views: 653

Re: PAX connection to TM1 server

Hello, i checked the Link you posted, there is "Authentification over Cognos Security" and its deprecated in v 2.0.9, so is there no way to use the Cognos Security with PAX? Its just an additional question cause i want to create a list what changes we would need to do if we want to upgrade to PAW an...
by HighKeys
Tue Mar 17, 2020 9:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: A way to find used Views
Replies: 3
Views: 1367

Re: A way to find used Views

Hi, @ascheevel Thanks for your answer, nice way i will implement this for the tmp views i use in processes (sometimes they dont clean up correctly). But the question above was for Enduser Public Views. Edit: Also nice with rename the views! Actally i'm relative new to TM1 and also in the company, th...
by HighKeys
Thu Mar 05, 2020 10:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web Snapshot with Excel Formulas
Replies: 3
Views: 640

Re: TM1Web Snapshot with Excel Formulas

Hi dhims, its not for TM1 Web directly, but you could use (or deploy) the TM1 Tools Excel Plugin (you can find it here in the Forum). There is a Button which converts just TM1 formulas to Values. So you could download the sheet with the TM1 formulas and press the macro button in the Add-Ins tab in E...
by HighKeys
Thu Mar 05, 2020 10:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: A way to find used Views
Replies: 3
Views: 1367

A way to find used Views

Hello Community! i'm searching a way to see which View is in use and which is "dead". We have so many views saved for our very small model, so the requirement from the controlling department is that every view gets updated correctly (to the current year etc) even if its a old view which are never us...
by HighKeys
Thu Mar 05, 2020 10:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Updateing Model to Hierarchys
Replies: 4
Views: 860

Re: Updateing Model to Hierarchys

Hello paulsimon,

thank you sir! Very helpful, i will setup a Project for our dev enviroment, lets see :)


BR
by HighKeys
Thu Feb 27, 2020 1:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Updateing Model to Hierarchys
Replies: 4
Views: 860

Updateing Model to Hierarchys

Hello friends, i read much about the Hierachys which are added with PA 2.0.5, at the moment we dont use the new Hierarchy system, but i think its worth a try. I cant find any info according to the DBR(W) formula if there was added a support of hierarchys. So my question is, we are using some sheets ...
by HighKeys
Tue Feb 25, 2020 11:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web White Blank Page
Replies: 10
Views: 2193

Re: TM1 Web White Blank Page

Thank you worked perfect!

I know i'm one of the users here with less knowlage and many questions, so i just want so say thank you for your support!
by HighKeys
Tue Feb 25, 2020 7:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web White Blank Page
Replies: 10
Views: 2193

Re: TM1 Web White Blank Page

Hello friends, i found a solution, i deleted the whole TM1Web folder and installed TM1 again on the server, now it works. I have a additional Question, before i had this issue, we dont see the mask to select a server in tm1web, now i can switch between our dev and prod enviroment, is there a way to ...