In order to easily maintain complex print reports, I would need up to 5 nested Dynaranges in one report. One of the latest requirements could use 3 nested vertical Dynaranges with 2 horizontal ones intersecting only the inner vertical Dynarange (t...
Define a separate cube data value for dynarange filtering and sorting
With a dynarange, you can only filter based on the value used for data filtering. If you have e.g. Projects as a vertical dynarange and turnover and costs as a horizontal dynarange, and want to filter out elements where both are 0, you cannot then...
In addition to the export functions (PDF, HTML, XLSX) there should be a function for printing.
Right now, users who want to print a report have to export first and print then. Better doing this in one step.
Dynarange shouldn't change the specified cell with dollar sign ($) in Excel formula
If a excel formula is defined in a cell which is covered in a Dynarange, position of specified cells in that Excel formula is dynamically changed when the Dynarange is expanded.
e.g.
If "SUMIF($G$2:$G$4,B3,$E$2:$E$4)" is specified in a cell cover...
It would be useful to be able to create, modify, delete and launch tasks directly from the API, allowing specification of :
schedule (date/time of execution and frequence of execution),
active or not,
file location when generating xlsx or pdf.
By default show summary of cells in the bottom right corner
Like in Excel it would be nice to get an automatic summary of cells shown in the bottom right Corner (see attached file).
For example:
Value in cell A1: 20
Value in cell A2: 30
Value in cell A3: 40
When range A1:A3 is selected, the sum of those ...
this would be greatly useful to have a method to get the number of rows returned by an ETL component, such as:
mySource=API.initSource("myExtract");
mySource.getRowCount();