Search found 70 matches

by orlando
Wed Apr 17, 2019 2:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Days360 Tm1
Replies: 12
Views: 1053

Re: Days360 Tm1

How do you workout the number of full months between jan 10 2016 to jan 9 2021 . hi, something like that should work. Date1 = jan 10 2016 Date2 = jan 9 2021 1: full month of the first year 12-Month(Date1) = 11 2: month of the full years: (Year(Date2)- (Year(Date1)+1) * 12 = 48 3: Full moth of last ...
by orlando
Mon Apr 15, 2019 1:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web Slice issue on Windows 10
Replies: 1
Views: 156

Re: TM1Web Slice issue on Windows 10

Hi davide, i would say, that this is a total normal behavior, beause you're exporting an xlsx file and not an extra file for perspectives. what you could do is: Add perspectives (tm1p.xla) to the add-ins that start with excel. then your user can use the sheet (after login to tm1, of course). best re...
by orlando
Wed Apr 03, 2019 10:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Storing a user session details in tm1
Replies: 15
Views: 505

Re: Storing a user session details in tm1

The exact scenario is like, in workbook1 i have Year field which has subnm function and it opens all the years(2017,2018,2019) in the dimension. Now if i select a year 2019 in this year field. If i go to workbook2 now i want 2019 value to load automatically in the year field of workbook2. And in wo...
by orlando
Wed Apr 03, 2019 9:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Storing a user session details in tm1
Replies: 15
Views: 505

Re: Storing a user session details in tm1

spartan wrote:
Wed Apr 03, 2019 9:54 am

Although its working in excel it is not working in tm1 web.
how to you do it in excel and where do you store the figures in tm1?
by orlando
Wed Apr 03, 2019 7:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Storing work session of a logged in user till logout
Replies: 3
Views: 149

Re: Storing work session of a logged in user till logout

Hi, if you use the Web-Cube-Viewer, the answer is: no, you can't store these informations. If you use Exce websheets, you got the answers how to store the data https://www.tm1forum.com/viewtopic.php?f=3&t=14572&p=72091#p72091 if you only want this inoformation available during one session, and forge...
by orlando
Wed Mar 27, 2019 7:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Text formatting
Replies: 2
Views: 233

Re: Text formatting

Hi spartan,

for TM1Web you are using Excel - so you can use "conditional formatting" for the red letters

regards
orlando
by orlando
Thu Mar 21, 2019 11:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Storing a user session details in tm1
Replies: 15
Views: 505

Re: Storing a user session details in tm1

Hi spartan,

then store this information (eg. via DBS) in a special cube and read the information from this cube on the other pages.

best regards,
orlando

p.s.: no reply till monday - gone for a long weekend
by orlando
Thu Mar 21, 2019 11:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Storing a user session details in tm1
Replies: 15
Views: 505

Re: Storing a user session details in tm1

Hi sparten,

what do mean with

"every user has a service attached to his name and each service has many models associated with different versions"?

Regards,
orlando
by orlando
Thu Mar 21, 2019 10:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Storing a user session details in tm1
Replies: 15
Views: 505

Re: Storing a user session details in tm1

Hi,

a quick idea.

Why don't you store the information in a special cube?

With one dim "}Clients" and a rule, that checks, if the status of the user in the "}ClientProperties" cube is "active"

if active= write the info, if not write a rule liek []= S:=0;

Regards,
orlando
by orlando
Thu Mar 21, 2019 8:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Closing all opened tm1 web tabs once
Replies: 1
Views: 108

Re: Closing all opened tm1 web tabs once

Hi,

are two clicks also ok?

Best regards,
orlando
by orlando
Wed Mar 20, 2019 7:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 CubeUnload
Replies: 5
Views: 229

Re: TM1 CubeUnload

Hi, i use CubeUnload if it is necessary to restore just one cube and i don't want to restart the hole tm1 db. If you want to save RAM, I don't think this will help. Therefor you have to check your rules and feeders - maybe they consume to much RAM. Check your sturctures - maybe you can reduce them e...
by orlando
Fri Mar 15, 2019 12:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 report bursting
Replies: 12
Views: 1171

Re: TM1 report bursting

Hi Wim,

i did the same for a customer with TM1 10.2.2, but i startet the excelsheet (with the macor) directly via the scheduler (without startet by TI)
there wasn't someone logged on - it worked fine

maybe you should try it with task scheduler only

regards
orlando
by orlando
Thu Jan 31, 2019 8:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA: Multiple web instance
Replies: 8
Views: 981

Re: PA: Multiple web instance

This much works, but even if I did this for instances from test 1 to test5 and navigated to all 5 instances using different URL's, when I look at the task manager on the web server, I still see a single java.exe process that I assume is responsible for serving all the web requests. I'd like to have...
by orlando
Mon Jan 14, 2019 9:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action button conditional navigation
Replies: 3
Views: 351

Re: Action button conditional navigation

Hi,

maybe you could use an attribute on the row element to save the target filename.
or you use an lookup cube, that makes the VLOOKUP.
then you can read the attribute or the cube

regards,
orlando
by orlando
Mon Jan 07, 2019 12:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Individualize TM1Web Login Landing Page in Planning Analytics
Replies: 1
Views: 461

Re: Individualize TM1Web Login Landing Page in Planning Analytics

hi,

you have to play with the home.jsp in .\webapps\tm1web

regards,
orlando
by orlando
Thu Dec 13, 2018 8:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 server crash
Replies: 5
Views: 610

Re: TM1 server crash

Hi all, i found the "problem". It was a DimensionDestroy in one of my meta processes. A metaprocess runs Process 1: build a temp dimension Process 2: Copy a part of the structure to another dimension Process 3: Load the attributes After the third process the metaprocess runs DimensionDestroy for the...
by orlando
Mon Dec 10, 2018 12:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 server crash
Replies: 5
Views: 610

Re: TM1 server crash

bgregs wrote:
Mon Dec 10, 2018 12:21 pm
Not entirely sure, but sounds like this *could be* related:

https://www-01.ibm.com/support/docview. ... wg21654717
thanks for your reply.

i saw that before. even shut down server, delete logfiles, start service does not help
by orlando
Mon Dec 10, 2018 11:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 server crash
Replies: 5
Views: 610

TM1 server crash

Hello, after moving to a knew windows server (Win 2016) i have a problem with one of the tm1 instances If a run a a data load or dimension process, the service for this db stops: "TM1.Transaction TM1TransactionLog::BasicInitialize: The transaction log was found and write-locked. Recovery possible af...
by orlando
Mon Nov 12, 2018 8:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Architect not showing any servers after installation
Replies: 5
Views: 851

Re: TM1 Architect not showing any servers after installation

Hi,

you didn't worte which version.
So, my first guess is: old 10.xxx version with expired certificates

http://www-01.ibm.com/support/docview.w ... SS9RXT-_-R

best regards
orlando