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.
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.
No comments:
Post a Comment