Hi,
Just a bit confused on the PAX custom reports, if I create one of the subsets within the report are dynamic does this report take all new projects created in the future in? I am struggling to define the difference between dynamic and custom reports? I have googled a few and its not overly clear on this. Any advice much appreciated
Thanks
Shane
PAX custom reports
-
- MVP
- Posts: 1815
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: PAX custom reports
Hi,
A "Custom Report" is static in terms of the rows that are displayed (there are some tricks to make it not static but we won't get into that.)
A "Dynamic Report" has the POTENTIAL to have a dynamic list of elements in the rows.
It is driven by a TM1RptRow formula (link below) which can return a list of elements based on a Subset or an MDX expression (or some other options), if your subset that you define gets updated to include an extra element then a refresh of your report will see that new row appear... likewise if you write an MDX expression directly in the book you can pick up new elements.
https://www.ibm.com/support/knowledgece ... ptrow.html
Hopefully that makes sense.
Thanks,
Declan
A "Custom Report" is static in terms of the rows that are displayed (there are some tricks to make it not static but we won't get into that.)
A "Dynamic Report" has the POTENTIAL to have a dynamic list of elements in the rows.
It is driven by a TM1RptRow formula (link below) which can return a list of elements based on a Subset or an MDX expression (or some other options), if your subset that you define gets updated to include an extra element then a refresh of your report will see that new row appear... likewise if you write an MDX expression directly in the book you can pick up new elements.
https://www.ibm.com/support/knowledgece ... ptrow.html
Hopefully that makes sense.
Thanks,
Declan
Declan Rodger
-
- Posts: 3
- Joined: Tue Dec 15, 2020 11:15 pm
- OLAP Product: tm1
- Version: tm1
- Excel Version: 2017
Re: PAX custom reports
ok that makes sense so technically a custom report would automatically update the following rolled up figures going forward.
Parent, pay, amount
as no additional lines would come into the report however behind the scenes additional children would come under the parent these would be picked up correctly as a total in a custom report?
Thanks
Shane
Parent, pay, amount
as no additional lines would come into the report however behind the scenes additional children would come under the parent these would be picked up correctly as a total in a custom report?
Thanks
Shane
-
- Site Admin
- Posts: 1454
- Joined: Wed May 28, 2008 9:09 am
Re: PAX custom reports
To be clear, the totaling happens on the server, using the rollups in your dimension - so if new elements are properly charted when they are added, the total will be correct. The 'custom' report retrieves values against the dimension element.
-
- Posts: 3
- Joined: Tue Dec 15, 2020 11:15 pm
- OLAP Product: tm1
- Version: tm1
- Excel Version: 2017
Re: PAX custom reports
thankyou both appreciate the clarity