Search found 350 matches

by Elessar
Thu Nov 03, 2022 2:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Old Architect rule editor replaces dashes with hyphens
Replies: 4
Views: 854

Re: Old Architect rule editor replaces dashes with hyphens

The dash in the first screenshot is an Em Dash - MS Word is generally to blame and converts dashes to em dashes via auto correct as you type. Someone then copies these to Excel or elsewhere then into TM1 and you have an issue. Yes Sherlock, it was exactly like you've described :) The rux file, equa...
by Elessar
Wed Nov 02, 2022 3:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Old Architect rule editor replaces dashes with hyphens
Replies: 4
Views: 854

Re: Old Architect rule editor replaces dashes with hyphens

Yes, this happens no matter where the dash is located
by Elessar
Wed Nov 02, 2022 3:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders evaluation
Replies: 8
Views: 1217

Re: Feeders evaluation

Hi,

Your "zero" years can be overfed by a feeder like

Code: Select all

['Something'] => ['fiscal_year':'Total years']
and feed further other zero cells.

And seriously, this "=>['item':'total_cost'];" feeder would confuse me more than your question.
by Elessar
Wed Nov 02, 2022 2:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Old Architect rule editor replaces dashes with hyphens
Replies: 4
Views: 854

Old Architect rule editor replaces dashes with hyphens

Hello everybody! I have noticed a strange behavior of the old rule editor: if I try to use object names with dashes (–, code 150), it works fine for the first time. But if I reopen it, the rule editor replaces them with hyphens (-, code 45). When I try to change something (eg add a comment) and save...
by Elessar
Mon Oct 10, 2022 11:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pax - Blank Subset Editor
Replies: 5
Views: 1482

Re: Pax - Blank Subset Editor

Hi,

This is a PAW window. Is your PAW running, do you have access to it? Check if you can use subset editor in PAW directly.
Also check if PAW address is added to trusted/local intranet in your internet options
by Elessar
Wed Oct 05, 2022 5:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Quick Report - Refresh Sheet throws error
Replies: 2
Views: 605

Re: Quick Report - Refresh Sheet throws error

Hi, this can appear when you have a mismatch in quick report and cube structures. Possible reasons: You have several dimensions in rows/columns, and their order is broken (eg you have accounts and months in rows (in this order), but the labels aer in different order (September, Revenue)) Sandbox doe...
by Elessar
Wed Oct 05, 2022 8:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Colum and line charts question - PAW - Multi line
Replies: 5
Views: 996

Re: Colum and line charts question - PAW - Multi line

I've dragged random dimensions (Version and Cost center) to colors just to show how it works.

This depends on what you want to be split to different lines and different columns. Note that This should be different dimensions
by Elessar
Wed Oct 05, 2022 6:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Colum and line charts question - PAW - Multi line
Replies: 5
Views: 996

Re: Colum and line charts question - PAW - Multi line

You should use the "couleur" fields. One of them is for columns, one is for lines (my French is too bad)
Image 4.png
Image 4.png (53.21 KiB) Viewed 962 times
by Elessar
Mon Oct 03, 2022 3:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Colum and line charts question - PAW - Multi line
Replies: 5
Views: 996

Re: Colum and line charts question - PAW - Multi line

Hi,

You need "Color" section in "Fields" tab for this.
Image 4.png
Image 4.png (16.99 KiB) Viewed 990 times
by Elessar
Mon Sep 05, 2022 1:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Powershell Snd-MailMessage Fail to Attach File
Replies: 16
Views: 2412

Re: Powershell Snd-MailMessage Fail to Attach File

Hi, Here is mine: $serverSmtp = "smtp.XXXXXX.XXX" #May be different! Check with mail server administrator $port = 587 $encoding = [System.Text.Encoding]::UTF8 $From = "XX@XXXX.XXX" $To1 = "XXX" $To2 = "XXXXX" $subject = "My subject" $user = "XXX...
by Elessar
Mon Sep 05, 2022 7:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1web data writeback is slow!
Replies: 6
Views: 1372

Re: TM1web data writeback is slowly!

These are basic things, and BIM documentation and Google will help you more at this stage than tm1forum ;)
https://www.ibm.com/docs/en/planning-an ... d-activity
by Elessar
Mon Aug 29, 2022 6:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1web data writeback is slow!
Replies: 6
Views: 1372

Re: TM1web data writeback is slowly!

Hi, There can be 2 reasons of slow data entry: Somebody locked something, and you are in queue The cell you are writing data in overfeeds something (most probably, a large consolidation) Use tm1top (or PAW administration) to determine this. But, is it really data entry? You say that you wait 10 minu...
by Elessar
Fri Aug 19, 2022 9:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SSL V2 Expiry 25 August 2022
Replies: 4
Views: 1367

Re: SSL V2 Expiry 25 August 2022

Aaaand I think it's the last in this thread and I will stop spamming :)

It looks like 10.2.2 is not affected. Try to switch the date to 26 AUG 2022 on you server and check if something fails.
by Elessar
Fri Aug 19, 2022 7:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SSL V2 Expiry 25 August 2022
Replies: 4
Views: 1367

Re: SSL V2 Expiry 25 August 2022

I've addressed this question to IBM team here: https://community.ibm.com/community/use ... fd25c11045
by Elessar
Fri Aug 19, 2022 6:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SSL V2 Expiry 25 August 2022
Replies: 4
Views: 1367

Re: SSL V2 Expiry 25 August 2022

Hi, I could not find the certificates on IBM site I doubt that I can share with you the certificates from my PA installations due to Intellectual Property Rights and because of other security stuff I'm not sure PA certificates can be used in TM1 10.2.2 10.2.2 is no longer supported by IBM Having all...
by Elessar
Mon Jun 20, 2022 6:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX RefreshAllData()
Replies: 8
Views: 15014

Re: PAX RefreshAllData()

Hi all,

I've had another RefreshAllData fault with "91" error recently: DAX add-in caused this. Disabling it fixed the error
by Elessar
Fri Apr 29, 2022 7:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String measure value to consolidation level
Replies: 8
Views: 1625

Re: String measure value to consolidation level

Hi, Primo , beware of several dates being summed up on consolidations Secundo , This is much easier with dates, than if it was really a string measure, because you can convert date to number and then to string again. Here is idea how to do this: Say we have string "Date" measure where we h...
by Elessar
Wed Apr 27, 2022 6:40 am
Forum: Useful code, tips and tricks
Topic: MDX - Using VAL instead of StrToValue
Replies: 2
Views: 11007

Re: MDX - Using VAL instead of StrToValue

Wow, thanks George!