TM1 Forum

We've found that in PAfE the dependency chain is less robust for DBRW formula than in Perspectives. Suggest you check all references in the DBRW formula for any TM1 formula, we've seen issues with things like tabdim, dimnm and elpar giving issues. Suggest you range value each reference until your fo...

Testing would be required. DimensionDeleteAllElements is regarded as unsafe as if there is a problem with the subsequent rebuild then this could result in permanent deletion and data loss. In a dimension with hierarchies then DimensionDeleteAllElements will act on the same named hierarchy only (I as...

Hi,
Suggest you post the whole TI and the whole error message.

The error message should have the line number and tab of the error in the log, which lines is this?

Cheers,

I've had a very erratic file lock issue in one environment we look after where the a text file remains locked by TM1 even after the all TI processes have stopped running. The only way to clear this (that I know of) is to restart the instance. We can tell it's happening as we can not delete the file ...

Though you state no feeder issue what is your evidence for this? A common problem with feeders is if you feed a consolidation, then when the feeder first saves the children of that consolidation will be fed as you would expect. If you then add a child to that consolidation then in most circumstances...

and option 4, load the log files back into TM1 again.

Unless the logs are huge there's no reason why you can't load (or even write them in the first place) to a TM1 cube fir easy viewing by the end user.

It is probably your view definitions, do you have the view set to exclude consolidations and or ruled values? If you have and the source contains data points of this type then they won't be excluded in the export. These are on by default. See below for the usual culprit https://www.ibm.com/support/k...

Most likely reason is that your MDX in the context it is being used at runtime is not returning any members. TM1 will not let you create an empty MDX subset. Standard practice (mine anyway) is to add the first element from the dimension to the start of the MDX statement and then delete the first ele...

You should think about your approach too, what you appear to be doing is likely to be very very inefficient. You appear to want to see the same values at all levels on the function and MVS dimensions. Even each of the dimensions only has 10 members than you are holding these data points 100 times mo...

First make 100% sure that you are using the subset in the way you think you are. Create the subset Assign the MDX. Remove the MDX (since we don't want it potentially re-calcing when we export) Assign it to the view used in the export. Tom is I think suggesting doing manually what the data tab is doi...

Wow, that took a while to get organised, Merry Christmas Ken!

Just make sure you stay on RHEL 7, RHEL 8 doesn't support the free docker anymore.

(RHEL 8 is not supported by PA, though the supported software page did briefly state that it was. )

I think that now that is up in the "ideas thing" we should all pile on and vote, just so someone somewhere doesn't decide that it isn't important...

I have seen issues with the compiler where if you mix a numeric test and a string test in the same conditional expression that it will give a false positive syntax error, it was a long time ago though.

i.e. If ( 1=2 & 'a'@='b' ,.... would fail to compile but If ( 'a'@='b' & 1=2 , ........... would

Hi John, Two questions I guess, neither of which I can answer... Why is the call failing? Is the call failing because you have turned PMHub off on the server? Are the parameters correct, if it was working in Café but not Pafe then I would guess so but it might not be safe assumption. I do remember w...

Some testing you could do 1. The source with the 113770 records, how long does it take to export to a text file and does the text file just contain the records I think it should. 2. Activate different bits of the code to see where the performance hit is. If it is the while loop and there is no rule ...

Maybe generalising the problem might help? I think you should probably be doing this with rules. Though you state you have already tried this and had an issue with the feeders, maybe your feeder was wrong? My target cube needs park information to do a simple calculation. As Lotsaram implied this doe...

It may have dropped off in later releases of PAfE...at one time you could change the MDX subset references to reference a hierarchy for example and I assume to any valid MDX. Pafe QuickReport.png I don't seem to be able to do it now though, which is a shame as it was one of the few ways you could ge...

I think that if you go onto the worksheet objects part of the PAfE task pane then there is some opportunity to interact with the definitions there.

As well as anti-virus I've managed to get two SaveDataAlls running concurrently before which has caused this issue....