Search found 1845 matches

by Steve Rowe
Thu Mar 21, 2024 9:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics workspace is down
Replies: 8
Views: 1011

Re: Planning Analytics workspace is down

A fellow forumer also pointed out that the licensing conditions have changed as well. If you try to reinstall PAW you're going to need a HCL Mirantis licence, make sure you fully understand this before proceeding. The lack of a licence may block you from installing the product (though I don't know t...
by Steve Rowe
Wed Mar 20, 2024 4:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics workspace is down
Replies: 8
Views: 1011

Re: Planning Analytics workspace is down

Hi, Rolling back the install of the patches is not the same is not the same as rolling back the VM to before the patches were installed. The damage will already have been done, you need to have the VM recovered from a back-up. A simple google give you the install instructions for PAW on 2016. https:...
by Steve Rowe
Wed Mar 20, 2024 9:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics workspace is down
Replies: 8
Views: 1011

Re: Planning Analytics workspace is down

Not to pile in on this but Win 2016 also does not have mainstream support from Microsoft anymore.... This kind of issue really needs to be raised with IBM support but you may struggle to access this due to the age of your install. If you think drive space is the issue, just add some more and see wha...
by Steve Rowe
Wed Mar 13, 2024 9:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAfE Issue on Win 11
Replies: 7
Views: 275

Re: PAfE Issue on Win 11

Thanks burnstripe, good shout, I'll follow this up. My understanding is that IE11 is not required anymore following the move to using WebView 2.0 for all the carbon pieces but there could be a miss somewhere. I'd also expect the log-in to the SaaS environment to fail as well if it was as simple as I...
by Steve Rowe
Tue Mar 12, 2024 4:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAfE Issue on Win 11
Replies: 7
Views: 275

Re: PAfE Issue on Win 11

Hi MaranC,
Yes I'm expecting them to say the combination of PAfE and PAW is out of range of their conformance statements, hence coming here for a solution.

Will keep the thread updated as and when I hear something.
by Steve Rowe
Tue Mar 12, 2024 1:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAfE Issue on Win 11
Replies: 7
Views: 275

Re: PAfE Issue on Win 11

Thanks burnstripe sensible suggestion but we're in the awkward situation of migrating to IBM Cloud and need to have both Cloud and on Prem available for parallel run. Would prefer not to upgrade on prem PAW if possible as then we would have to UAT that just to get through the parallel run.
by Steve Rowe
Tue Mar 12, 2024 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAfE Issue on Win 11
Replies: 7
Views: 275

PAfE Issue on Win 11

Hi, We are seeing the following error come up in the web page when PAfE is trying to render the set editor or cube viewer. { "error": { "code": "AUTH_REQUIRED", "message": { "authenticate": { "location": "/login" } } } } This happ...
by Steve Rowe
Thu Feb 22, 2024 9:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ELPAR in Rule
Replies: 2
Views: 171

Re: ELPAR in Rule

For something as slow changing as this I would populate with a TI and hang the script for it off whatever TI is looking after updates to the Cost Centre dimension. This way there is no need for SecurityRefresh to get rule changes reflected in the security model, once you have to kick the system to g...
by Steve Rowe
Thu Feb 01, 2024 3:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use of VBA in PA
Replies: 5
Views: 569

Re: Use of VBA in PA

Are you talking about publishing to TM1 Web / PASS from within PAFE

If so I don't think it is possible using VBA.
by Steve Rowe
Wed Jan 31, 2024 6:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copying data between different dimensions
Replies: 1
Views: 395

Re: Copying data between different dimensions

Most cube to cube data transfers follow this sequence Prolog tab Define the Destination View and ViewZeroOut Define the Source View and declare it to the datasource. Data tab Update dims if required (use the direct functions) Write data Epilog Clean up objects DimensionUpdateDirect if you used the d...
by Steve Rowe
Wed Jan 31, 2024 6:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Can you use ConsolidatedCountUnique with criteria
Replies: 2
Views: 351

Re: Can you use ConsolidatedCountUnique with criteria

Hi, I'd be very careful about using the Consolidate.... family of functions. They do some strange things to the calculation engine including (I believe / been told) turn off the sparse data calculation methods (skipcheck / feeders) "underneath" them. They can lead to significant RAM growth...
by Steve Rowe
Fri Jan 26, 2024 5:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Populate Cube thru T1 or other process
Replies: 1
Views: 356

Re: How to Populate Cube thru T1 or other process

Hi, It's Friday and I'm about to log so I'll be brief. Problem 1. " There is a process that deletes the ORGs and then repopulates the ORGs to bring in new orgs if there are any" Check if this is doing a DimensionDeleteAllElements, if so you should flatten the structure instead (i.e. remove...
by Steve Rowe
Mon Jan 22, 2024 11:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM Tech Exchange - Barcalona - Now
Replies: 0
Views: 623

IBM Tech Exchange - Barcalona - Now

Hi, Myself and some colleagues are at the conference, anyone else here?
by Steve Rowe
Fri Jan 12, 2024 11:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Instance starting up failure
Replies: 1
Views: 478

Re: Tm1 Instance starting up failure

Probably best to show the lines it is stopping at. My best guess is that you have persistent feeders on and this is enabling fast start-up. Sometimes it will decide to rebuild the feeders which can take a v long time and you will see the log pause on these lines for long periods. Key point is if the...
by Steve Rowe
Thu Jan 04, 2024 10:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule Dependency Query
Replies: 2
Views: 708

Rule Dependency Query

Just want to double check before I over engineer... I have two cubes that I want to be totally independent in order to preserve the Rule Cache in each cube. If the rule sheet for both cubes reference the attributes of the same dimension via a lookup, something like a prior period lookup then does th...
by Steve Rowe
Wed Dec 13, 2023 2:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Flexible PickList Definitions
Replies: 2
Views: 3493

Re: Flexible PickList Definitions

This was touched on in some other threads recently. You can only point the picklist at a dimension, set or static list. Therefore if you have a complex need delivered by MDX then you must create a public set to deliver the list. You can not point a picklist directly at a MDX statement. If you have a...
by Steve Rowe
Fri Dec 08, 2023 9:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut doesn't work
Replies: 11
Views: 16659

Re: ViewZeroOut doesn't work

Super unlikely.... Most likely you have a C level in your view, you can only zero out N level data and it must be explicitly in your view / sets. Other reasons for confusion to arise. It's ruled data and therefore can't be zeroed out. Suggest you post your code and / or screen shot of view definition
by Steve Rowe
Fri Dec 01, 2023 4:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Saving and Reusing user settings
Replies: 10
Views: 12746

Re: Saving and Reusing user settings

There is an RFE here
https://ibm-data-and-ai.ideas.ibm.com/ideas/PAOC-I-318

that would allow picklists to defined by MDX only without the need for a set in between, I see it's been marked as not for consideration 😭 but allegedly even a closed RFE can be reopened if it get's enough votes!
by Steve Rowe
Fri Dec 01, 2023 2:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Saving and Reusing user settings
Replies: 10
Views: 12746

Re: Saving and Reusing user settings

SHowing the alias should be a property of the set not the picklist definition? i.e. Save the set with the alias set. I'm not aware of any bugs in current releases in this area