Search found 1537 matches

by Steve Rowe
Mon Jan 27, 2020 2:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBR/DBRW formulas resulting in #VALUE! errors
Replies: 8
Views: 108

Re: DBR/DBRW formulas resulting in #VALUE! errors

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...
by Steve Rowe
Mon Jan 27, 2020 11:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use of DimensionDeleteAllElements
Replies: 3
Views: 74

Re: Use of DimensionDeleteAllElements

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...
by Steve Rowe
Thu Jan 23, 2020 1:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset having a cube of parameters
Replies: 8
Views: 104

Re: Subset having a cube of parameters

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,
by Steve Rowe
Thu Jan 23, 2020 1:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process Error Log Not Available
Replies: 12
Views: 158

Re: Process Error Log Not Available

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 ...
by Steve Rowe
Thu Jan 23, 2020 9:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Value is not computing after adding existing element to a dimension?
Replies: 4
Views: 179

Re: Value is not computing after adding existing element to a dimension?

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...
by Steve Rowe
Sun Jan 12, 2020 2:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Log Management for PA
Replies: 7
Views: 232

Re: Log Management for PA

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.
by Steve Rowe
Wed Jan 08, 2020 9:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX in TI Process
Replies: 14
Views: 522

Re: TM1 MDX in TI Process

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...
by Steve Rowe
Wed Jan 08, 2020 10:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX in TI Process
Replies: 14
Views: 522

Re: TM1 MDX in TI Process

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...
by Steve Rowe
Fri Jan 03, 2020 2:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation
Replies: 12
Views: 254

Re: Consolidation

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...
by Steve Rowe
Fri Dec 13, 2019 5:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AsciiOutput element order different from subset
Replies: 12
Views: 505

Re: AsciiOutput element order different from subset

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...
by Steve Rowe
Fri Dec 13, 2019 1:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server crash on saving dimension (status Suspended)
Replies: 14
Views: 1481

Re: TM1 Server crash on saving dimension (status Suspended)

Wow, that took a while to get organised, Merry Christmas Ken!
by Steve Rowe
Thu Dec 12, 2019 11:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW on Linux better performance?
Replies: 10
Views: 2920

Re: PAW on Linux better performance?

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. )
by Steve Rowe
Wed Dec 11, 2019 10:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Enhance DBSW/DBRW formulae with Hierarchy Awareness Parameters
Replies: 3
Views: 187

Re: Enhance DBSW/DBRW formulae with Hierarchy Awareness Parameters

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...
by Steve Rowe
Tue Dec 03, 2019 9:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 rule subst with dimension element
Replies: 9
Views: 758

Re: TM1 rule subst with dimension element

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
by Steve Rowe
Thu Nov 14, 2019 10:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX: TM1IOData Source still uses PMHUB for CognosOfficeAutomationObject.ExecuteFunction to run a TI
Replies: 2
Views: 202

Re: PAX: TM1IOData Source still uses PMHUB for CognosOfficeAutomationObject.ExecuteFunction to run a TI

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...
by Steve Rowe
Wed Nov 13, 2019 6:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Optimize While
Replies: 20
Views: 707

Re: Optimize While

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 ...
by Steve Rowe
Wed Nov 13, 2019 11:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Optimize While
Replies: 20
Views: 707

Re: Optimize While

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...
by Steve Rowe
Mon Nov 11, 2019 9:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Quick Reports and MDX
Replies: 6
Views: 323

Re: Quick Reports and MDX

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...
by Steve Rowe
Fri Nov 08, 2019 9:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Quick Reports and MDX
Replies: 6
Views: 323

Re: Quick Reports and MDX

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.
by Steve Rowe
Wed Nov 06, 2019 2:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1.Server sf_Delete and sf_Rename failed
Replies: 17
Views: 5710

Re: TM1.Server sf_Delete and sf_Rename failed

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