Loading data in Incrementally loading cube with deleted ecdata files.

This issue is regarding trying to load data on a cube under specific conditions-

1) some tables of the cube have been set up to load data incrementally.
2) you have had to manually delete backup files due to lack of disc space.

In this case no matter which load you try to do- schema changes, load full data, delete existing data and load sample, cube will fail to load.

Work around:
copy the cube in another name and run it again and change the cube in dashboard.

Soluution:
I found no solution to above problem. It continuously fails with message: "failed to load cube". No matter what you try, it will continue to show the same message.
The reason for this seems to be that in some procedure it has stored that there is an existing copy of the cube data (ecdata file). However upon not finding it, instead of letting you do a full load, it keeps throwing error.

Time based transformations in Sisense.

When trying to implement time based transformations sisense offers some good options, if that is, your time requirements are limited to month, quarter or year.
If you want to implement last week, 28 days, last 30 days average/sum then you can run into some big confusion.

In other tools this is managed by transformations, however since no such feature exists in Sisense,  one will have to implement it using custom tables. However upon googling you will come across two very helpful features-

RPAVG
and
RPSUM

These are supposed to give you running period average and running period sum.
http://pages.sisense.com/rs/sisense/images/SisenseFormulaReference.pdf

However, if you try to implement it you will see some unexpected behaviour.
Upon contacting sisennse you will come to know that the features are no more supported, despite being mentioned on their documents.

Recommended solution-
Please implement your requirement through another SQL-based query within your E-cube. This will be additional overhead for maintenance and cube build time.