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...
Change Freeze Pane position when inserting/deleting rows/columns
When you have defined Freeze Pane on a Web Spreadsheet, and then insert or delete rows or columns above / to the right of the frozen panes, the position of the Frozen Panes is not adjusted. This should be improved to work similar to Excel.
When you show the report in "Reports", you will see two menus for saving snapshots in the Home tab. 1): XLSX snapshot 2): XLSX OLAP snapshot Since we expect users not to make export operations, the role permission "ste_reports" has been changed to...
Unfortunately there was no official statement to my comment on topic
http://feedback.jedox.com/forums/220460-jedox-feature-voting-tool?query=cancel
Thats why I opened the same feature reqest again.
The main problem is, that during calcula...
If you need the same macro in different workbooks you currently have only 2 options:
- copy & paste the macro into all relevant workbooks
- use external PHP files.
But external PHP files are not really handy when you want to provide deplo...
Navigating from a scheduled task in task scheduler to the actual ETL component (groovy/ standard job, etc) would be handy. Right clicking and selecting an option to navigate to the respective ETL component would save a lot of time in implementatio...
Manage global custom PHP spreadsheet functions via Report Designer (esp. in Cloud Setup and for Jedox Models)
Dear Jedox colleagues, we would like to suggest some features to make handling of custom PHP scripts / user defined spreadsheet functions easier ..esp. for Jedox Models and Cloud: starting point: You need a custom PHP / spreadsheet function for gl...
Running an Http request from an action would allow integrating APIs into spreadsheets without using macros or Integrator. Post requests should allow specifying a body and e.g. using variables or referencing cell values.
Make an easy way to add a custom library for PHP, JS, Groovy
It should be intersting to make an hub with our customs libraries for PHP macro or Groovy for example. Something like an folder and we put our php files(libraries) in it, then we could freely use the function define in the php file in all workbook...