TM1 Forum

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

Hi,
I don't have any of the legacy clients available to me and so have no way to see the cube sizes and also I cannot see an option to turn on the performance monitor so can monitor and track cube sizes.

Anyone seen an option to enable this anywhere?

Thanks in hope!

From what I have been told / inferred / remember the issue relates to PAfE driven picklists. When a cell is selected it has to check if there is PAfE driven picklist in the cell. For reasons unknown this check involves checking and testing all the named ranges in the workbook. What the purpose of th...

Hi wcoffen,

Thanks alot, that's some great detai.

Customer is investgating at this time so I'll update this thread when we get to the root cause.

Many thanks,

I've hit this issue a few times (at the same customer, see also here ) When I last hit this, the other common symptom was for PAfE having a noticable lag when navigating around from one cell to another using the cursor keys and more general slow calculation peformance. If you think you are suffering...

See this enhancment request https://www.tm1forum.com/viewtopic.php?p=82419#p82419

In the general, MDX views where a filter has been applied can not be used as a a target for the ViewZeroOut function.

Hi RFE is here. https://ibm-data-and-ai.ideas.ibm.com/ideas/PAOC-I-1178 Use case as follows. In the general case the target area of a VZO and data load looks like this, with the red areas excluded from the ViewZeroOut. General Case VZO.png Using a legacy view we have to VZO each "cell" one...