Search found 19 matches

by Adam
Mon Oct 26, 2020 5:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX USERNAME, differences in CAM and Mode 1?
Replies: 4
Views: 373

Re: MDX USERNAME, differences in CAM and Mode 1?

Hi Steve, Instead of your ("first form"): {StrToMember("[WARF ID].[Total " + [Front End Selection].([}Clients].["+USERNAME+"] ,[Selector].[WARF ID]) +"]").Children} Does this work? ("second form"): {StrToMember("[WARF ID].[Total " + [Front End Selection].(StrToMember( "[}Clients].[" + USERNAME + "]"...
by Adam
Thu Oct 08, 2020 2:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How you would explain what is TM1 to your mom ?
Replies: 6
Views: 794

Re: How you would explain what is TM1 to your mom ?

I've heard the following:

1. LEGO for adults.
2. Mathematical video game.

But the most concise explanation I prefer to use with non-work individuals is:

3. Enterprise-grade Excel spreadsheets.
by Adam
Fri Oct 02, 2020 2:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unexpected behavior of consolidations
Replies: 8
Views: 388

Re: Unexpected behavior of consolidations

I see what you mean Maren, then just:

1. PNL0000067 set weight to -1.
2. PNL0000068 set weight to 0.
3. Create new element PNL0000068_ABS set weight to 1 and place next to PNL0000068 in the hierarchy.
4. Add rule so PNL0000068_ABS = ABS(PNL0000068). PNL0000068 =feeds=> PNL0000068_ABS.
by Adam
Fri Oct 02, 2020 2:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unexpected behavior of consolidations
Replies: 8
Views: 388

Re: Unexpected behavior of consolidations

Although the premise around absolute values seems unusual, here's how I would go about this: 1. PNL0000067 set weight to 0. 2. PNL0000068 set weight to 0. 3. Create new element PNL0000067_ABS, place next to PNL0000067 in the hierarchy and set weight to 1. 4. Create new element PNL0000068_ABS, place ...
by Adam
Fri Oct 02, 2020 11:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unexpected behavior of consolidations
Replies: 8
Views: 388

Re: Unexpected behavior of consolidations

Hello Kaz,

Setting a c-level rule, as you do for PNL00000Q, does not impact higher-lever consolidations, in this case PNL00000H or PNL00000D, as those also consolidate leaf-level elements. You’ll need to use ConsolidateChildren, but this gets messy.
by Adam
Tue Sep 29, 2020 2:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance impact of many timestamped transaction logs
Replies: 1
Views: 187

Performance impact of many timestamped transaction logs

Hello all, In our environment we have a daily SaveDataAll chore running during off-hours. As a consequence, we have accumulated many timestamped tm1s*.log file as we don't presently archive these. I recall from a prior thread there IS a performance hit with keeping the timestamp'd transaction logs i...
by Adam
Thu Sep 17, 2020 3:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copying data TM1
Replies: 1
Views: 149

Re: Copying data TM1

Hello. Data in TM1 is held in leaves, the lowest level of data. Roll-ups / consolidations happen on demand so the copy will also need to occur at the leaf level. The advice Wim gave you is really solid -- consider implementing }bedrock.cube.data.copy . With that process, you can pass high-level sour...
by Adam
Thu Sep 17, 2020 2:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW export and send by mail automatically
Replies: 2
Views: 206

Re: PAW export and send by mail automatically

Hello!

My approach would be to create the views using PAFE API, perhaps CreateFromMDX. It's quite powerful. Then you can use VBA to generate the emails.

Different than your desire to use Planning Analytics Workspace, but Planning Analytics for Excel is more flexible.
by Adam
Mon Sep 14, 2020 6:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX statement for pointing to a subset
Replies: 1
Views: 135

MDX statement for pointing to a subset

When writing a view MDX statement inclusive of a subset, what is the preferred syntax to use?

Is it:

(A) [Dimension].[Hierarchy].[Set]
-or-
(B) TM1SubsetToSet([Dimension].[Hierarchy], 'Subset')?

Option (A) is more succinct, but TM1 tends to "auto generate" (B), hence my question.
by Adam
Thu Aug 27, 2020 8:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Icons under Planning Analytics ribbon (excel-addin) is grayed out
Replies: 4
Views: 327

Re: Icons under Planning Analytics ribbon (excel-addin) is grayed out

I just got back to my computer. I can recreate what your screenshot shows. My fix is as follows: 1. Right click on the blank space in the "IBM Planning Analytics" tab and click "Customize the Ribbon". The Excel Options window appears. 2. On the left side of the Excel Options window, "Choose commands...
by Adam
Thu Aug 27, 2020 6:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Icons under Planning Analytics ribbon (excel-addin) is grayed out
Replies: 4
Views: 327

Re: Icons under Planning Analytics ribbon (excel-addin) is grayed out

Looks like it’s not just grayed out (disabled) but outright missing. I’ve never seen this before and I’m in PAFE 5 days a week for over a year now. A couple of thoughts: — In Excel it’s possible to customize the ribbon. Are the ribbon tab contents “checked” i.e. enabled when you go to edit the ribbo...
by Adam
Wed Aug 12, 2020 7:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA for Excel isConnected VBA Function
Replies: 1
Views: 231

PA for Excel isConnected VBA Function

Assuming you're using IBM Planning Analytics for Excel (PAX/PAFE) alongside the API as documented by IBM , I wanted to share a VBA function that will return True when users are successfully logged into the target server. Function isConnected(givenConf As Boolean) As Boolean ' In the below row, subst...
by Adam
Tue Aug 11, 2020 11:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: LOGGING for }StatsBy Control Cubes
Replies: 7
Views: 502

Re: LOGGING for }StatsBy Control Cubes

tomok, thank you!

If a blank means YES for logging purposes, then it's doing what is intended.

By the way, would you say it's a good practice to set any control cube, esp. }StatsByX to NO for logging?
by Adam
Tue Aug 11, 2020 7:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: LOGGING for }StatsBy Control Cubes
Replies: 7
Views: 502

LOGGING for }StatsBy Control Cubes

I was debugging some rules in dev and I find a nice fat 32Mb tm1s.log with thousands of line items for }StatsByCube and }StatsByRule, etc. My dev box: -- PA 2.0.9.1 (TM1 Build Number: 11.8.00000.33) -- PerformanceMonitorOn=T -- In }CubeProperties, I have ---- LOGGING set to YES for non-control cubes...
by Adam
Wed Jun 17, 2020 3:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sending an email using PA on IBM Cloud
Replies: 2
Views: 532

Re: Sending an email using PA on IBM Cloud

Thank you! Just curious is that PA readiness thread in a forum I don’t have access to because I get an: You are not authorised to read this forum.-message.
by Adam
Wed Jun 17, 2020 2:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sending an email using PA on IBM Cloud
Replies: 2
Views: 532

Sending an email using PA on IBM Cloud

I was reading a recent thread and found out about sending an email using SMTP PA on IBM Cloud. I have a working prototype and I figured I would share the two quick little EXPANDABLE scripts that I wrote. Spent (<2 hrs) on it so of course not optimized. PowerShell Script: email.ps1 [System.Net.Servic...
by Adam
Tue Apr 21, 2020 1:16 pm
Forum: Useful code, tips and tricks
Topic: Bedrock Issues
Replies: 20
Views: 22432

Re: Bedrock Issues

Thanks for the suggestions. I just figured since this forum has a Bedrock Issues thread to post it here. Will do so in GitHub next time.
by Adam
Mon Apr 20, 2020 9:07 pm
Forum: Useful code, tips and tricks
Topic: Bedrock Issues
Replies: 20
Views: 22432

Re: Bedrock Issues

I've been having issues with getting }bedrock.cube.data.import.pro to work. I want others to avoid the headache I have, so I'm documenting my findings and workaround. Issue with pQuote In the documentation , it claims that pQuote accepts an empty quote. This is not the case. }bedrock.cube.data.impor...
by Adam
Wed Dec 04, 2019 8:01 pm
Forum: Useful code, tips and tricks
Topic: Bedrock Issues
Replies: 20
Views: 22432

Re: Bedrock Issues

I've gotten so much out of this community, it's time I put something back in. The parameter pSuppressConsol does not work properly for }bedrock.cube.data.copy.intercube.pro . Errors occur when trying to copy string across cubes. In the above process, search for: # Allow consolidations only if pSuppr...