Modeler - cube layout - change to alphabetical order
Currently, when changing the cube layout the dimensions are sorted by creation date. With a long list of dimensions it takes a while to find the correct dimension. Please change the dimensions to alphabetical order.
In many reports I need to consider date intervals. for example beginning is
2012-11 and end is 2015-03
Calendar is
- All Years
- Year
- Quar.
- Month
So a macro calculates all needed Elements:
- 2011-11, 2011-12, 2012, 2013, 2014, 2015-Q1
This is...
Functionality to filter the reports on a date range
Merged
Currently, there isn't a functionality that filter the Jedox reports specifying a date range; start_date and end_date.
Could you consider to add the functionality to the product, since most of the BI tools have the functionality.
On excel we can force the user to put only number for example or only number between two number. Or only date, only a precise format and specific rule. It could be great (at least) to force the user to put number in cell. But in fact the best you ...
Option in time editor to have element names of days as serial numbers instead of yyyy-mm-dd
When element names of days are serial date numbers, it is much easier to make calculations regarding time, e.g. lead times and due dates. You can simply add or subtract numbers of days from the element name. Serial date number as an attribute is n...
Every object from modeler and integrator should be timestamped
To get a better traceability of the data it should be interesting to have a timestamp when a dimension are modified and a timestamp when the dimension is created. But not only dimension, cube, dimension element, and other object from the modeler(i...
Provide additional information for cell level comments
The following improvements could make cell comments more useful: Username and date: similar to Excel, when adding a comment to a cell in the Web Spreadsheet (Designer) the username and date/time should be added Cell UI: Commented cells should have...