Search found 6 matches

by engineerairborne
Thu Oct 31, 2024 11:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What PAfE functions do not work in PAW
Replies: 3
Views: 1986

Re: What PAfE functions do not work in PAW

Sorry I should clarify. Yes it works in a websheet. However when I publish the websheet to PA. And then view the websheet in a report in PAW it does not work.
by engineerairborne
Wed Oct 30, 2024 3:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What PAfE functions do not work in PAW
Replies: 3
Views: 1986

What PAfE functions do not work in PAW

I know very late to the game, but I am working on migrating our websheets from TM1 Applications to PAW. I have built out the Security stuff in the application and that is all working. However I am noticing that there are a lot of functions that work when developing in Excel that don't work in PAW. I...
by engineerairborne
Fri Jan 31, 2020 2:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Archiving Data in the same Cube
Replies: 6
Views: 3463

Re: Archiving Data in the same Cube

I figured it out. In the rule, it included all Year Dimensions. I had to update each rule to only include the Current year, so that the new Dimension was not part of the rule. Even though the [] = N:IF(ATTRS('Year',!Year,'Archive')@='Y',STET,Continue); this causes rules not to be applied to these Ar...
by engineerairborne
Fri Jan 31, 2020 2:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Archiving Data in the same Cube
Replies: 6
Views: 3463

Re: Archiving Data in the same Cube

Don't skip ruled values? ViewExtractSkipRuleValuesSet (vCube, vView, 0); That is the code change that I made that caused the errors that I have listed above. How do I not skip rules but not get errors such as "Requested Budget","Current Year","Input","184617"...
by engineerairborne
Fri Jan 31, 2020 12:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Archiving Data in the same Cube
Replies: 6
Views: 3463

Re: Archiving Data in the same Cube

The reason that I am trying to implement a change to the code is because it is not archiving the rule based data. The intersections were data is rule based in the original code come back as blank. This is because in the rule as written by the same contractor is has this line at the start. [] = N:IF(...
by engineerairborne
Fri Jan 31, 2020 11:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Archiving Data in the same Cube
Replies: 6
Views: 3463

Archiving Data in the same Cube

This is my first time posting, I am new to Planning Analytics and I am still learning. I am working with Code that a consulting company put in place that is not functioning, and I am looking for help fixing the code. I am using Planning Analytics 2.0.4 We have a cube with a Year dimension that with ...