TM1 Forum

Thanks Wim, that's an interesting read, most of the items are pretty obscure. A few items stand out though TI Functions. Interesting that the ASCIIOutput function is not listed, the one thing that has been known for a long while to not be possible. Same for ExecuteCommand. AssignClientPassword - I'm...

They were pretty clear when asked that v12 on premise would not re-introduce any of the functionality that v12 containerised was removing. The loss of the Stats cubes has not really been publicised, it's a pretty big deal isn't? How are we supposed to tell we have got our designs right, if dim order...

Hoping this was part of the April fool as well?

Also, in V12, the }Stats cubes are deprecated

Hi, The Elpar / ElementParent function will bring back an elements parent, so if you have the levels organised as structure in the dimension then you can use this. Do take care though as if you have multiple consolidation structures in the dimension then you can't guarantee which structure you will ...

Hey Wim, all the best with Jedox, but you maybe should of picked a different date to post this?

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...

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

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...

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...

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.

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.

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...

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...

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

If so I don't think it is possible using VBA.

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...

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...

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...

Hi, Myself and some colleagues are at the conference, anyone else here?

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...

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...