cubewise-code / cubecalc Goto Github PK

• stdev
• median
• mean
• weighted mean
• min
• max
• 25 % quantile
• 75 % quantile
• Sample size
• count of observations (including and excluding nulls)

Team , Marius ,

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

Thanks
Suresh

Hi,

When there is an error, main.py creates an error file which is great but in the console, it does not tell you it created an error:

When there is an error, it would be great if main.py could return a message in the console such as "error check CubeCalc.log.

Cheers,

Vincent

very new to tm1py and cubecalc but the creation of the samples was failing.

after changing line 62 to "dimension_name="Py Project Summary Measure" from dimension_name="Py Project Planning Measure",

everything worked fine.

Thanks
Max

Hello Marius, Vincent, et al,

This is certainly a useful set of tools for for instance NPV calculations for projects. I can see many more applications.

However, the biggest drawback is that the code does 1 project per function call. It does the login to TM1 many times if we execute the code within a loop over say 100 projects. Can we also have something like a loop over projects (elements in a subset) and execute the calculation of NPV for any project in the loop - thereby doing the login and logout in TM1 only once ?

As I was testing CubeCalc and other REST API and tm1py scripts, I notice that the login to a TM1 model on my own laptop takes about 2 seconds. I don't know what causes this, it's just security mode = 1, my laptop is the admin host, nothing special at all. That being said, 2 seconds times 100 projects becomes a long time to run (relatively speaking ;-))

If needed I could create views and subsets in the calling TI script, but also happy when that would be done in the Python script of CubeCalc.

What do you think ? We could have calculations for 300 cost centers all at once, statistics like the median for 1000 products over 5 regions, etc.

At the moment when CubeCalc is executed it performs a single calculation.
There is quite a bit of overhead associated to that single calculation (starting up python, importing libraries, Authentication with TM1, etc.).

CubeCalc needs a batch mode.
When executed in batch-mode a list of tasks and a number of threads is provided. CubeCalc performs all the necessary overhead at startup and then works through the tasks with n threads.

CubeCalc.py --method "IRR" --tm1_source "MF" --tm1_target "MF" --cube_source "position" --cube_target "position" --view_source "IRR_Q2" --view_target "IRR_Q2_Result" --dimension "ticker" --hierarchy "ticker" --subset "IRR_ticker" --dimension "accts" --hierarchy "accts" --subset "IRR_Accts" --tidy False';

One more thing,

How we can do cartesian query in cubecalc

It is overriding first dimension .

To make it consistent with RushTI, where we execute RushTI.py. Could we rename main.py to cubecalc.py

We should go all lower case, it avoids spelling mistake. We will need to rename RushTI.py to rushti.py.

Cheers,

Vincent

Hi,

I have previously been able to get CubeCalc working on my IBM Cloud environment using the sample provided, however it appears something may have changed with how CubeCalc.py addresses the credentials as the script now aborts when I attempt to run the sample IRR script. It appears that CubeCalc now omits an import of Base64, although it still aborts even if I use the plain text password.

Example of script used;
python CubeCalc.py --method "IRR" --tm1_source "guardian-dev" --tm1_target "guardian-dev" --cube_source "Py Project Planning" --cube_target "Py Project Summary" --view_source "Project1" --view_target "Project1 IRR" --tidy False

Attached are the log file generated by CubeCalc and an example of how my Config.ini file appears. Please let me know if you have any questions or require any further detail.

Regards,
Peter

CubeCalc.log

Implement all functions discussed here

• https://corporatefinanceinstitute.com/resources/excel/study/excel-for-finance/
• http://stephenlnelson.com/articles/standard-financial-functions-excel/