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...
workbook export macro function should also support pdf as file type (currently xlsx, wss)
I am using macros to export files.Currently I can only choose between xlsx and wss.For a project I do at the moment I would need Pdf to be a possibility as well. why Pdf in this case?- normal users can't handle wss- we don't want the user to use a...
Allow view creation to use DATAC formulas when pasting
The Jedox support team recently told me that to improve performance of a view, we should be using DATAC formulas. However, the formula type is set within the Paste View Options, and DATAC formulas are not even offered as an option. We have to choo...
Search for "name"/"description" within Jedox Integrator
Currently, a new user can have issues in finding specific ETL components, because he has to work backwards from Jobs to Loads to Transforms and try to find the relevant pieces. An easy solution would be to add a "Search" functionality to the main ...
Wenn performing a load of a cube with drillthrough parallel load a log line states : Number of rows in table "<schema>"."table" changed from xxx to yyy the query performed to do that is select count(*) from <schema>.<table> thus ...
One of the great things about Excel is that you can have as many windows open on as many screens as you need. With Jedox, we have found it very limiting only having one web sessions on one screen. While having Jedox data in Excel on other screens ...
Extend INFO() function to include users current time/timezone
This would be a powerful feature where there is a multi-timezone solution deployed, but the user needs to know schedules and executions in the current zone. INFO("timezone_user") = displays users timezone INFO("timezone_server") = displays server ...
Since Jedox 2018.4 its possible to use labels. This is quite useful to layout a report since you dont have to stick to a grid of the spreadsheet (e.g. figures in tiles). But for some reason its not possible to interact or attach a macro to a label...
We see that our customers wants to use more specific planning horizon charts such as Gantt charts. In order to build those now dynamic it is quick some work (like using widgets). It would be nice to support gantt charts like it is "native" done in...