Search found 1842 matches

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: 228

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: 228

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: 228

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: 228

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: 165

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: 557

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: 392

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: 343

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: 349

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: 619

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: 471

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: 703

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: 3168

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: 14546

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: 11387

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: 11387

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
by Steve Rowe
Fri Dec 01, 2023 12:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Saving and Reusing user settings
Replies: 10
Views: 11387

Re: Saving and Reusing user settings

Sounds like a good first step. You could have put your rule against the Picklist attribute rather than in the picklist cube. You only tend to need picklist cubes with much more complex logic against a data cube rather than the simple 2d list we are working with here. (i.e. it's the picklist cube you...
by Steve Rowe
Fri Dec 01, 2023 9:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM usage exploding with CubeUnload and ViewConstruct
Replies: 5
Views: 10341

Re: RAM usage exploding with CubeUnload and ViewConstruct

If the method you have picked for keeping the cubes aligned is not working, have you considered other methods? A couple of methods, there are probably others.

If you have logging enabled you could consider replication.
Export and import of active periods

Cheers,
by Steve Rowe
Thu Nov 30, 2023 3:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prerequisites and Challenges: PAW installation
Replies: 6
Views: 8211

Re: Prerequisites and Challenges: PAW installation

any suggestions please we are in the middle of the decision-making to with PAW or stay with TM1 Web. Go RHEL for PAW. PAW is massively better than TM1Web, assuming you want to use dashboards of course. Much better dev and admin tools as well. You get to use Pafe too, baring in mind that Excel 365 a...