Search found 264 matches

by Elessar
Mon Nov 22, 2021 1:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to use TM1ELLIST in conjunction with MDX-Subsets as Drop-Down Input in Excel?
Replies: 10
Views: 2250

Re: How to use TM1ELLIST in conjunction with MDX-Subsets as Drop-Down Input in Excel?

LGEIS wrote:
Wed Nov 17, 2021 3:27 pm
  • 1. disabled auto refresh
Hello, I may misunderstand something... You need to enable autorefresh. Without it, you will not be able to use dynamic drop-downs
by Elessar
Wed Nov 17, 2021 1:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to use TM1ELLIST in conjunction with MDX-Subsets as Drop-Down Input in Excel?
Replies: 10
Views: 2250

Re: How to use TM1ELLIST in conjunction with MDX-Subsets as Drop-Down Input in Excel?

Hi, Do you have autorecalculation enabled? Where do you use TM1ELLIST? In named range? In short, you need to make named range using TM1ELLIST (this cannot be used in data validation), then display elements using INDEX, then make named range using OFFSET, and then use it in Excel data validation). I'...
by Elessar
Thu Oct 28, 2021 7:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX did not work in TI
Replies: 6
Views: 2891

Re: TM1 MDX did not work in TI

Hi,

Can the subset you are using be private?
by Elessar
Mon Oct 04, 2021 7:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Element Security
Replies: 9
Views: 3247

Re: TM1 Element Security

Hi,

This looks like PrivilegeGenerationOptimization is turned on in tm1s.cfg. Is it?
by Elessar
Mon Oct 04, 2021 6:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX API: Multiple commit of all quick reports (or other ways?)
Replies: 4
Views: 1962

Re: PAX API: Multiple commit of all quick reports (or other ways?)

Thanks George, Adam, Wim, Geroge's variant looks the most elegant, and it works. And as Adam said, "Wait" is not needed. My final code is: Sub CommitAll() Dim oReport As Variant Dim iReportCount As Integer Dim iReportIndex As Integer 'Get number of reports in the book iReportCount = Reporting.GetRep...
by Elessar
Fri Oct 01, 2021 8:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules effect on a Data load
Replies: 6
Views: 2678

Re: Rules effect on a Data load

Hi,

As said before, it's definitely feeders. You need to switch them off before loading data

Create a blank rule file (or a rule file with rules, but without feeders): let it be "dummy"
In Prolog: RuleLoadFromFile('Sales', 'dummy');
In Epilog: RuleLoadFromFile('Sales', '');
by Elessar
Fri Oct 01, 2021 8:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX API: Multiple commit of all quick reports (or other ways?)
Replies: 4
Views: 1962

PAX API: Multiple commit of all quick reports (or other ways?)

Hello everybody! The Commit button commits data only in active sheet, so I'm asked to make a button to commit the entire book. Firstly , maybe there is an option to make the Commit button commit the entire book (like the "Refresh" one)? Secondly , I've made a VBA script to do this. The idea is to lo...
by Elessar
Wed Sep 08, 2021 11:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export data
Replies: 3
Views: 2660

Re: Export data

Hi, There are many ways to do this. 1. Create a view with 100 customers. Use Architect "Export as text data" function 2. in PAW or TM1web, use "export to excel" function 3. Use Bedrock: https://github.com/cubewise-code/bedrock/wiki/%7Dbedrock.cube.data.export 4. Write your own process, using ASCIIOu...
by Elessar
Mon Sep 06, 2021 10:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Kill a running Chore
Replies: 2
Views: 2006

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
by Elessar
Thu Aug 05, 2021 11:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Concatenating element name and attribute value in rules
Replies: 3
Views: 2085

Re: Concatenating element name and attribute value in rules

Hi!

Code: Select all

'a' | 'b'
Interesting! I've tried to find it in "TM1 Reference", and didn't find it either...
by Elessar
Tue Jul 27, 2021 7:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process in architect weird error
Replies: 4
Views: 2579

Re: TI process in architect weird error

Hi,

No, you've done the right steps.
Try to relaunch Architect.
Is .pro file new or old after PROD server starts?

Try to find "side" errors like:
  • Admin server is correct in Architect
  • The server had stopped completely before you copied the file
  • Double check the folder you are copying to
by Elessar
Thu Jul 22, 2021 2:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Suppress zero row/column in a chart in websheet
Replies: 7
Views: 3355

Re: Suppress zero row/column in a chart in websheet

Thanks burnstripe,

But it is not what I need:
Grey and yellow icons are what I need to hide. And you have an empty ZSTAT, which should also be hidden
by Elessar
Tue Jul 20, 2021 6:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics Integration With Google Sheets
Replies: 7
Views: 7177

Re: Planning Analytics Integration With Google Sheets

Hi,

It's can be done very easily using python and pandas:
  1. Use tm1py to load data from TM1 to a dataframe: example
  2. use gspread to load dataframe to google sheet: example
by Elessar
Mon Jul 19, 2021 6:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Suppress zero row/column in a chart in websheet
Replies: 7
Views: 3355

Re: Suppress zero row/column in a chart in websheet

Thanks guys,

It's a completely websheet model, so custom macros and PAW could not be used :(
And yes, of course, I need this to be dynamic
by Elessar
Fri Jul 16, 2021 2:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Suppress zero row/column in a chart in websheet
Replies: 7
Views: 3355

Suppress zero row/column in a chart in websheet

Hi,

I have a websheet with stacked column chart. There are zero-rows and zero-columns. Is there a way to hide them?
Websheet suppress.png
Websheet suppress.png (27.75 KiB) Viewed 3355 times
by Elessar
Thu Jul 08, 2021 7:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics Upgrade added lines of code in Cube Rule Editor
Replies: 1
Views: 2274

Re: Planning Analytics Upgrade added lines of code in Cube Rule Editor

Hi,

Do you use Performance Modeler? (if yes, I recommend to stop using it)
As far as I remember, it is the only one who add this lines of code. If you do not need SKIPCHECK in some cubes, double-click them in PM and select and deselect the option for automatic SKIPCHECK adding
by Elessar
Mon Jun 28, 2021 6:20 am
Forum: General
Topic: Belgium - Italy
Replies: 35
Views: 26375

Re: Belgium - Italy

I'll just post here an old Russian football joke :(
If you cheer for your national football team, then you are either a fool or a German
by Elessar
Wed Jun 23, 2021 11:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User's active sandbox
Replies: 8
Views: 3800

Re: User's active sandbox

Hi,

Sandbox Synchronization for Action Buttons will be implemented in 2021 Q4: https://bigblue.aha.io/published/30f7b7 ... 10d?page=4
by Elessar
Tue Jun 15, 2021 9:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Wet End Rebuild?? ;D
Replies: 3
Views: 2965

Re: TM1 Wet End Rebuild?? ;D

Wat?

Found it in Russian. TM#1 is tissue machine #1 :D
by Elessar
Wed Jun 09, 2021 10:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Long time execution of TI after finished nested processes
Replies: 8
Views: 4830

Re: Long time execution of TI after finished nested processes

avkaz wrote:
Wed Jun 09, 2021 9:28 am
but I won't get a results of calculation :)
Of course, it's not the way to solve the problem. By commenting parts of code, you can figure out what part of code causes the problem, and then try to fix it.