Let us know how we can make Jedox even better!
As a report designer, I want to set up a lower and upper limit to a value cell so that users are not able to capture meaningless values to the system.
Further Details:
Example:
Scope of consolidation report, where user to capture direct ownership rate with a lower limit of 0% and upper limit of 100%. The cell should not accept the value of less than 0 or greater than 100%
this feature can be implemented easily by using the cube worker in the supervision server. this is much more convenient because it is not report-related but catched on a database level.
I think the feature should not be limited to upper and lower bound of a decimal value, as requested but be extended. There are already good concepts which should be considered:
Microsoft Excel features quite a set of cell data validations, see Apply data validation to cells. In addition to
List
(already implemented) andDecimal
(described above) there is alsoWhole Numbe
r,Date
,Time
,Text Length
andCustom
. From my point of view, all these can be useful,Whole Number
,Date
andTime
being more important thanText Length
andCustom
.The modeler features a similar concept for attribute values, see Creating and Handling Attributes. In addition to
List of values
,Subsets
andStored Subsets
(already covered implemented as theList
feature) there is alsoBoolean
,Integer Range
(with is another term forWhole Number
),Float Range
(which is another term forDecimal
, which is described above),Date range
(which is another term forDate
),Time range
(which is another term forTime
),Date & time range
andYear & month range
. It would be good to share concepts between theDomain
for attributes and it's UI in the Modeler Grid with cell data validation on web spreadsheets where feasible.It would be nice to refer to the
Domain
of an attribute value as defined in the Jedox In-Memory Database (by database, dimension and attribute name) for the cell data validation instead of duplicating the definition in the spreadsheet. This would reduce maintenance and enhance the consistency between multiple reports and between the reports and the database. (For cell values other than attributes values there is no definition in the database yet, which one could refer to)