Search found 38 matches

by pikolikoli
Mon Jun 05, 2023 9:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Insert Progress status in TI process
Replies: 2
Views: 1280

Insert Progress status in TI process

Hi TM1ers, I need to add status displaying the start and the end of a TI process. I know that TI processes don't commit its data until the end of the process. So I opted of another solution. I created a parent process, where I added a cellputS to my new logging cube( with status ' Running'). Then I ...
by pikolikoli
Tue Nov 16, 2021 4:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web select many elements at the same time
Replies: 5
Views: 17205

Re: TM1 Web select many elements at the same time

...I feel bad for not thinking about this :mrgreen: ... There are many times in one's life to feel bad about something. Determining that a current method is suboptimal and seeking to better yourself by sharing your frustration and soliciting advice from an online community of users who may have exp...
by pikolikoli
Tue Nov 16, 2021 1:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web select many elements at the same time
Replies: 5
Views: 17205

Re: TM1 Web select many elements at the same time

If you're trying to select 400+ elements from the left side and drag to the right, I'd say you're not using the subset editor in the best way in TM1Web. One thing I like to do when working with the TM1Web subset editor is to simply collapse the left side and work only in the right. Select the subse...
by pikolikoli
Tue Nov 16, 2021 12:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creatae a TI proess who simulates the same role of Snapshot cube button
Replies: 1
Views: 7108

Creatae a TI proess who simulates the same role of Snapshot cube button

Hello TM1 People, For a business need, I should create a TI process who extracts any public view created by users to database. I tried using parameters and passing the cube and vue to parameters then adding these two lines : DataSourceNameForServer = pCube; DataSourceCubeView = pView; But it seem ta...
by pikolikoli
Fri Oct 22, 2021 12:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web select many elements at the same time
Replies: 5
Views: 17205

TM1 Web select many elements at the same time

Hello All, I have a dimension in TM1 Web, which has more than 400 pages of elements as shown in this image : https://ibb.co/xjgBfh3 I want to select all of them and drag them to the next selection tab at the left of the screen, so they can be displayed in the cube. I used Shift + Click like in excel...
by pikolikoli
Sun Oct 17, 2021 7:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Access a users private View
Replies: 3
Views: 5153

Access a users private View

Hello All,

A user requested that I access his private view and do some modifications on his view, Also the user is not an admin so I guess he will not be able to make the view public.

Is there a way that I can access his private view ?

Thank you
by pikolikoli
Thu Oct 14, 2021 1:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web add Automatic Sheet Refresh
Replies: 4
Views: 4485

Re: TM1 Web add Automatic Sheet Refresh

As far as I'm aware that setting is the only way to get what you require. It forces a refresh when the data validation changes, without the parameter the user will need to trigger the refresh. Only the tm1web service will need restarting following the config change in tm1web.config, nothing else. S...
by pikolikoli
Wed Oct 13, 2021 12:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web add Automatic Sheet Refresh
Replies: 4
Views: 4485

Re: TM1 Web add Automatic Sheet Refresh

How are you generating your selections, through subnm or data validation? If its subnm then as long as automatic recalc is on when you upload the application, tm1web should change when a selection is made. If it's a data validation list then have a look at the tm1web config. There's a setting Recal...
by pikolikoli
Mon Oct 11, 2021 3:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hide button Based on a condition in an active form
Replies: 2
Views: 3708

Re: Hide button Based on a condition in an active form

This is very insightfull and helpfull idea. We will work on implementing this idea in our solution. Thank you very much!
by pikolikoli
Mon Oct 11, 2021 1:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web add Automatic Sheet Refresh
Replies: 4
Views: 4485

TM1 Web add Automatic Sheet Refresh

Hello Forum, I want to use an automatic refresh on a sheet in TM1 Web without using a refresh button. The sheet is a normal excel sheet not an active form, where you select values from dimensions then a launch button to launch a process. Based on a selection of some dimensions, the other cells value...
by pikolikoli
Fri Oct 01, 2021 7:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hide button Based on a condition in an active form
Replies: 2
Views: 3708

Hide button Based on a condition in an active form

Hello Forum ,

I have an active form where based on a cell value I want to hide or show a button.

Is there anyway to achieve this solution in TM1 without using VBA ?

Thank you
by pikolikoli
Fri Sep 24, 2021 1:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Apply Active Forme styling on Table not Containing TM1RPTROW
Replies: 0
Views: 63247

Apply Active Forme styling on Table not Containing TM1RPTROW

Hello All,

Is there a way to apply Active form styling on a table not containin a TM1RPTROW in a sheet containing TM1RPTROW in another table ?
by pikolikoli
Mon Sep 06, 2021 10:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Kill a running Chore
Replies: 2
Views: 3075

Re: Kill a running Chore

Hi, If the chore doesnt show up in TM1TOP, it is not running. Your interface (Architect/PM/whatever) can hang itself and do not show the "the chore has ended" message. Check your tm1server.log Thank you ! It really didnt start yet Thank God ! or else the server will shut down since there ...
by pikolikoli
Mon Sep 06, 2021 10:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Kill a running Chore
Replies: 2
Views: 3075

Kill a running Chore

Hello Forum,

Is there a way to Kill a running chore ? if yes how can we do it ?

Also I noticed the chore doesnt show up in TM1TOP.

Thanks
by pikolikoli
Tue Aug 03, 2021 9:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Import Views without restart
Replies: 5
Views: 4948

Re: Import Views without restart

I didnt know that .. Thank you So much for the clarifications . I appreciate it.

Thanks
by pikolikoli
Tue Aug 03, 2021 8:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Import Views without restart
Replies: 5
Views: 4948

Re: Import Views without restart

Thank you for your replay. I right clicked on the cube and I only found unload button , where can I find the reload button ?
by pikolikoli
Mon Aug 02, 2021 6:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Import Views without restart
Replies: 5
Views: 4948

Import Views without restart

Hello All,

is there a way to import views to TM1 without having to restart the server ?

I tried today to put all my views in TM1DATA but I wasnt able to see them under the cubes.

Thanks
by pikolikoli
Mon Jul 19, 2021 6:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Failed Process only for one User while launching in TM1 Web
Replies: 3
Views: 3178

Re: Failed Process only for one User while launching in TM1 Web

Hi Sana, A lot of times, if there is no record of the error in the logs it means that the user did not have permission to run the process. A "process failed" error message appears in the screen, but nothing appears in the logs because the process doesn't even get as far as running (and fa...
by pikolikoli
Mon Jul 19, 2021 4:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Failed Process only for one User while launching in TM1 Web
Replies: 3
Views: 3178

Failed Process only for one User while launching in TM1 Web

Hello TM1 Forum, I came accross a weird error today. We have a TM1 interface in TM1 Web where every user can launch a process using a button. It worked perfectly before. until today one of the users can never launch this process and always shows up a pop up error : "Process failed". I did ...
by pikolikoli
Fri Jan 22, 2021 8:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating Dimensions Using Referentials .How does i work ?Where to learn about it
Replies: 9
Views: 3117

Re: Creating Dimensions Using Referentials .How does i work ?Where to learn about it

Yes True, I work in a french speaking company where they use this term 'Referentiel'. Thanks Wim for the clarifications. I would like to ask you do you know somewhere where I can read about how this template work and how it is created ? So I was right 😀 This template belongs to our colleagues in Pa...