Search found 229 matches

by Harvey
Fri Jun 04, 2021 4:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Months and TimePeriod
Replies: 8
Views: 7736

Re: Months and TimePeriod

Yeah fair enough. I tend to use and encourage data copy processes for that kind of thing, but it is nice to have the data spreading option in many cases.
by Harvey
Fri Jun 04, 2021 4:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: HELP! SSO broken by disabling AD user account?
Replies: 3
Views: 3047

Re: HELP! SSO broken by disabling AD user account?

The Applcation Pool was ok, but burnstripe's suggestion about the CA Binding Identity did the trick. Thanks so much to you both!
by Harvey
Thu Jun 03, 2021 6:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Months and TimePeriod
Replies: 8
Views: 7736

Re: Months and TimePeriod

paulsimon wrote: Thu May 20, 2021 10:05 pm I would hope that this finally puts the one or two time dimension debate to rest, but I doubt it.
No, it does. Best of both worlds.
by Harvey
Thu Jun 03, 2021 6:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem with CreateHierarchyByAttribute
Replies: 6
Views: 5994

Re: Problem with CreateHierarchyByAttribute

Unless I misread your question, the result you got is the one expected. If you have a look at the documentation for CreateHierarchyByAttribute , you'll see it's very limited in what it can do. It can create a 3-level hierarchy, with level 0 being your leaf elements, level 1 being the value of the at...
by Harvey
Thu Jun 03, 2021 5:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: HELP! SSO broken by disabling AD user account?
Replies: 3
Views: 3047

HELP! SSO broken by disabling AD user account?

Hi all, I inherited a PA / PAW server that was installed with SSO before I arrived. It's a Windows Server 2016 machine with IIS 10 and PA 57 installed. For reasons I won't go into, the server was setup using my colleague's AD account, rather than a dedicated service account. The account ended up bei...
by Harvey
Wed May 05, 2021 12:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prior Year and Next Year in Rules: What is Faster?
Replies: 9
Views: 5763

Re: Prior Year and Next Year in Rules: What is Faster?

Using the string to numeric conversion method is bad practice for other reasons also. For one, you're linking your naming convention to your rule. What if one day you want to expand your year dimension? What if your users insist on distinguishing between FY2020 and CY2020 ? Yes you can work around t...
by Harvey
Sun Mar 14, 2021 11:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Tools is there one for PAX
Replies: 7
Views: 3909

Re: TM1Tools is there one for PAX

Now I'm not saying the Waterfall approach to software development isn't without its own intrinsic flaws, but it sure beats the hell out of throwing half finished crap at customers just so it can be said that "look at us, we're Agile now". I recently had some training on Agile Project Mana...
by Harvey
Sun Mar 14, 2021 11:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Tools is there one for PAX
Replies: 7
Views: 3909

Re: TM1Tools is there one for PAX

Oh, and STILL they haven't provided hierarchy aware DBRW formulas. They might, maybe get around to it by the end of the year. That tells you a lot. Don't get me started :) After becoming an early adopter of virtual hierarchies and discovering this omission live with the client, I asked IBM at every...
by Harvey
Sun Mar 14, 2021 10:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Tools is there one for PAX
Replies: 7
Views: 3909

Re: TM1Tools is there one for PAX

Well said, Alan! You said a lot of things out loud that I've been thinking about Planning Analytics for a long time now. I remember hearing them talk about Docker and Kubernetes and all these technical aspects of the software and thinking "how about you just build a really good front end?"...
by Harvey
Tue Feb 23, 2021 3:42 am
Forum: Free And Open Source Tools
Topic: Visual Studio Code Extension for TM1
Replies: 12
Views: 65889

Re: Visual Studio Code Extension for TM1

This looks fantastic, bgregs!
by Harvey
Mon Feb 22, 2021 9:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Matching unnamed subset with named subset
Replies: 5
Views: 2764

Re: Matching unnamed subset with named subset

ykud wrote: Mon Feb 22, 2021 7:03 am I'd say it's probably simpler with rest api than with a TI over .vue files
Definitely, if you have the skillset.
by Harvey
Mon Feb 22, 2021 5:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Matching unnamed subset with named subset
Replies: 5
Views: 2764

Re: Matching unnamed subset with named subset

Agree with Alan's post, with one exception. You used the following language: those elements under Unnamed subsets is similar to other elements under the Named subset. Similar or the same? It would be much harder to detect "similar" subsets than identical ones. One could imagine an algorith...
by Harvey
Thu Jan 21, 2021 4:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API - Getting alias value when retrieving native view
Replies: 0
Views: 6898

TM1 REST API - Getting alias value when retrieving native view

Hi all, I'm trying to retrieve and render a view using the REST API. I want to present it similarly to how it looks in Architect. Python is not an option in my dev environment -- so I must do so using native API calls via web request. I've tried using tm1.Execute, but when the Axes are returned, I d...
by Harvey
Thu Sep 13, 2018 8:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 MDX - set element collapse using element name in dimension
Replies: 10
Views: 6139

Re: Tm1 MDX - set element collapse using element name in dimension

But, I would like to pass the element to drill down the particular element in dimension and save to subset or dimension itself. I don't really understand your question, but you're talking about two incompatible concepts here. There is no way to pass anything to a subset or dimension. Subsets don't ...
by Harvey
Wed Aug 29, 2018 9:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating a }Picklist cube in a TI process
Replies: 3
Views: 3222

Re: Creating a }Picklist cube in a TI process

SaveDataAll doesn't seem to make any difference. What I have discovered is that the picklist works the first time the cube is created, but once it's established I can't delete it and re-create the picklist cube. For now I'm just going to leave it if it already exists and replace the rule file. That ...
by Harvey
Wed Aug 29, 2018 7:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating a }Picklist cube in a TI process
Replies: 3
Views: 3222

Creating a }Picklist cube in a TI process

Hi all, I'm trying to create a picklist cube for an existing cube using a Turbo Integrator process. I'm creating a cube with the correct name (}Picklist_Cube_Name) with the same dimensionality as the original cube with the addition of the }Picklist dimension as the final dimension. I'm then attachin...
by Harvey
Wed Aug 29, 2018 7:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 restapi in C# app
Replies: 4
Views: 3167

Re: Tm1 restapi in C# app

I have played around with the REST API in C#. I got my test scenarios working with authentication, but can't guarantee it'll work in every case.

If you continue to have issues, PM me and I'll send you some code examples. I probably won't have time to dig through the code until the weekend.
by Harvey
Wed Jan 24, 2018 11:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using Alternative Hierarchies to calc stock balances
Replies: 7
Views: 5684

Re: Using Alternative Hierarchies to calc stock balances

Hey Steve, sorry for the late reply. The customer is on 11.1.0.30 (according the the properties on the tm1s.exe file) or TM1SERVER-AW64-ML-RTM-11.1.00000.30-0 according to the cmplst.txt. It's PA "Express" on-prem. If there's anything I can do to help you out, shoot me a PM. I'd be happy t...
by Harvey
Fri Jan 19, 2018 3:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using Alternative Hierarchies to calc stock balances
Replies: 7
Views: 5684

Re: Using Alternative Hierarchies to calc stock balances

I tried it with the good ole' DB formula and it worked. Thanks to those who gave advice, it got me thinking in the right direction. I'd say the lesson learnt is to avoid the CellValueN function for now, as it seems to behave differently from the way it is documented. For those interested in this, th...
by Harvey
Fri Jan 19, 2018 2:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using Alternative Hierarchies to calc stock balances
Replies: 7
Views: 5684

Re: Using Alternative Hierarchies to calc stock balances

As far as I know, the DB function does not support alternative hierarchies. To check, I tried as you suggested and got a syntax error "missing right parenthesis": ['CSOH Quantity'] = N: DB('MFP Scenario Planning', !GBL Company, !MFP Scenario, !MFP Selling Season, !MFP Product Lifecycle Sta...