PAX Dynamic Report is not rendering to TM1 Web
Posted: Fri Nov 01, 2019 4:06 pm
Hello,
I found several discussions about this issue, but none of them actually answered a question why dynamic reports are not properly rendering in TM1 Web.
I am on Planning Analytics and PAX 2.0.6 and I have a dynamic report with four row dimensions, one of which (Time) is based on the subset created by MDX on the same sheet. The MDX is based on the date range. When the report is recalculated in PAX, it displays all data. If I publish it to Web, I get all dimension elements, but DBRW formulas do not show any data.
The report worked before the server refresh from production. Dimension order in the cube did not change. Also, there are three tabs on the websheet, two of them don't work, but one works. The one that works does not use MDX in TM1RPTROW, instead it has a reference to a dynamic subset. I tried to use the same dynamic subset on the websheet that does not work, and it still did not work.
Are there any known bugs or issues that can explain what's going on? Are the first two websheets corrupted, but I can't find where?
I found several discussions about this issue, but none of them actually answered a question why dynamic reports are not properly rendering in TM1 Web.
I am on Planning Analytics and PAX 2.0.6 and I have a dynamic report with four row dimensions, one of which (Time) is based on the subset created by MDX on the same sheet. The MDX is based on the date range. When the report is recalculated in PAX, it displays all data. If I publish it to Web, I get all dimension elements, but DBRW formulas do not show any data.
The report worked before the server refresh from production. Dimension order in the cube did not change. Also, there are three tabs on the websheet, two of them don't work, but one works. The one that works does not use MDX in TM1RPTROW, instead it has a reference to a dynamic subset. I tried to use the same dynamic subset on the websheet that does not work, and it still did not work.
Are there any known bugs or issues that can explain what's going on? Are the first two websheets corrupted, but I can't find where?