Need Sample for XIRR py script arguments

[surdyed]

Team , Marius ,

There is no enough documentation or sample on how to calculate XIRR.
It would be helpful if you can update.

Thanks
Suresh

[MariusWirtz]

Hi @surdyed,

the xirr function expects that date-elements are placed on the rows.

Make sure that in your source view the elements on the rows are dates (e.g. 2022-09-29 or 29/09/2022)

That should be it

Marius

[surdyed]

Hi Marius ,

Tried with both date format suggested, here is the error.
I have added new date format with alias , saved with subset with alias on and assigned to source view.
However when executed the script ,its taking the dimension principal element name instead of alias field.

Please check and also let me know if you have tried this and its working as mentioned?

date None
Failed calculating XIRR with parameters {'tm1_source': 'srver1', 'tm1_target': 'srver1', 'cube_source': 'position cube', 'cube_target': 'position cube', 'view_source': 'z_test_IRR_20220928091911_861', 'view_target': 'Zerout_z_test_IRR_20220928091911_861', 'dimension': 'prj', 'hierarchy': 'prj'}. Error: object of type 'NoneType' has no len()
Traceback (most recent call last):

TypeError: object of type 'NoneType' has no len()
CubeCalc aborted. Duration: 0:00:01.639174.
CubeCalc aborted. Duration: 0:00:01.639174.

[MariusWirtz]

please post a screenshot of the source view

I think the script always takes the principal element name. I think that's a limitation.
Can you create a sample where the element principle name is a valid date format?

[surdyed]

Hi Marius ,
See attached.

I cannot change the base date format , as it would screw up all historicals (rules+ti code ref and all)
Only option is I can add alias as needed.

[surdyed]

please post a screenshot of the source view

I think the script always takes the principal element name. I think that's a limitation. Can you create a sample where the element principle name is a valid date format?

There should be an option for rest api function to use alias.

[MariusWirtz]

Thank you for reporting this @surdyed. I think it is a defect in cubecalc.

Cubecalc should use the alias if one is defined in the cube view selection.
I think we can get to resolve this issue next week.
If you need a short-term solution, feel free to open a PR.

[surdyed]

Hi Marius , Please let me know if you got a chance to resolve the issue.

…

On Sep 29, 2022 at 10:51 AM, <Marius Wirtz ***@***.***)> wrote: Thank you for reporting this @surdyed (https://github.com/surdyed). I think it is a defect in cubecalc. Cubecalc should use the alias if one is defined in the cube view selection. I think we can get to resolve this issue next week. If you need a short-term solution, feel free to open a PR. — Reply to this email directly, view it on GitHub (#16 (comment)), or unsubscribe (https://github.com/notifications/unsubscribe-auth/AL5PLJXXOAFEOV5JVF63CO3WAW3HJANCNFSM6AAAAAAQYYC63I). You are receiving this because you were mentioned.Message ID: ***@***.***>