TM1 Forum

Hi,
We've seen internally and at a customer the last Office 2019 update breaking Pafe (i.e. ribbon not loading).
Deleting the Office Connection folder and reinstalling the .xll didn't work.
Reinstalling Excel resolved the issue.

Anyone else seeing this issue and have a better fix?

Great thanks, excellent!

Scratch that, frustratingly that switch doesn't appear to work with the carbon viewer that is the default in Pafe 2.0.90

Fairly simple one.

Currently a slice from the cube viewer in Pafe goes to the active book.

Request to be able to configure it so that it slices to a new book or have the full range of options that are available off the task bar.

https://ideas.ibm.com/ideas/PAOC-I-1269

What you may find is that it is including zeros in the top count and then suppressing them.

i.e. if you have 10,5,0,0,0,-5,-10
You will only get two numbers in a suppressed top / bottom 5.

If you have a low record count you are better off sorting the list then using top / bottom

You should be clear about what RAM is increasing. If the server is maxing out are you sure the TM1 DB is the cause? Can you see what is using this RAM? I ask this because I recently had an issue at a two different clients where the RAM on the box was maxing out but not visible vs anything in task ma...

I think this is the second use case that I outlined. You need to set your export up to use the C level of Period Month Main (the YTDS) and in order to get them to appear in the query you will need to uncheck the Exclude Consolidations in View check box (or use the equivalent TI command). The both th...

In this situation you would add an attribute to use for the mapping. sPeriodToWriteTo = Attrs ('PERIOD MAIN' , vPeriodInSource, 'Mapping Attribute to PERIOD MONTH MAIN'); CellPutN('CubeAInput' ,..... sPeriodToWriteTo.....); If it is just that your source has YTDs at leaf and your destination movemen...

Also worth checking what activity is going on in the TM1 DB. Could there be a long running / broken TI hogging the processors? Has the issue persisted through a restart of the TM1 DB? Given the symptoms you describe I'd be looking for some kind of change to the infrastructure or change in the TM1 DB...

Rule based values can not be overwritten, your user is wrong. A possible exception might be where the rule has a switch in it to allow entry, this might happen in Budget versions vs an Actual version. It would read something like. ['KPI']= If (Attrn ('Version' , !Version , 'IsBudget')=1 , Stet , ['A...

Hopefully you have already raised with IBM support? If it's bug then they will likely be the only ones that can help...

Thanks for updating the group John, appreciated!

Hi Mark, The example shown from IBM is super simple though, resulting in the exclusion of an entire slice from the cube. I don't need a MDX view to do this, I can just put 2019 in a set. I wouldn't really consider this as part of the use case. This use case where the conditionality for the clear is ...

What kind of erraticness were you hitting with RunProcess MarenC?

I've a MT job running hourly that I am not seeing issues with, at least the customer has not raised them to me.

Nice spot JohnO, looks like they will provided a step change in our ability manage parallel processing.

As JohnO said the only way I know to do this is counting Flag files. Something like this. Main Job Clear your Flag folder of all files. Figure out how many RunProcess calls you are are going to make = nFlagCount Call all your Run Process jobs Loop Until FlagCount>=nFlagCount FlagCount is the sum of ...

Yes, I had the same experience, it's frustrating to hit this in the support process.....

Something that's not clear in the explanation I had or your one, is if it is actually possible to refactor the MDX such that what we want to do is possible? I think not but would be happy to be wrong....

We also have an old ticket, since closed, wrt to PAAA and high processor usage. This only occured when PAW was making a request to PAAA for the performance stats and so some what mitigated at the customer site by turning down the update frequency. The processor spike seemed to be driven by the PAAA ...

So as best we can tell this issue is being caused by Planning Analytics Admin Agent (PAAA) spawning and dropping many instructions to powershell to look at the registry. The many many instances of these hanging around in the background are chewing through all the RAM over time.

Off to IBM....

Yeah, did I mention it was Friday afternoon?? Never trust the documentation! Now I just need to understand that fact that Cube RAM totals 1.5GB Server RAM =10.5GB Garbage = 0.8GB Taskmanager states 10.5 GB So which is wrong...Garbage or Cube..... Thanks for your help Elessar, have a great weekend!

You can turn on the option in the cfg editor of PAW in Administration / YourDB / Configuration / Default / PerformanceMonitorOn Unfortunately this method requires a restart of the DB if you change it through the console. Although the documentation states if you change it in the cfg it is dynamic. (I...