Set ETL variable value based on other variables (via formula)
Sometimes a variable in ETL is just a simple math calculation based on another variable.
Example: year_end = year_start + 10
Another case would be a simple "if then else" condition based on another variable.
==>
It would be great to just defi...
Add JedoxFiles option to the location parameter in the Directory Connection
Dear Jedox, What: Please expand the location parameter with the option "JedoxFiles" in the directory connection. This option already exists in the CSV and Excel connection. Why: The directory connection is very useful for file management. Please l...
Little Icon (i) which can lead to the exact article in the KB. For example, in table join, i would take to https://knowledgebase.jedox.com/integration/transforms/tablejoin-transform.htm?Highlight=table%20join
Presently when a user authenticates their excel add-in with SSO or SAML Jedox does NOT store the credentials and therefore users have to enter their credentials every time they open excel. Store the token or cookie or whatever it is that Azure AD ...
Add public-facing IP address to cloud console for each instance
Clients often need to whitelist the IP address for the Jedox Cloud server, which requires submitting a ticket and waiting for a reply. This should be available in Cloud console.
Create a refresh sheet option In Excel, and disable auto refresh all workbook and sheets whenever Jedox initiates an action ( paste element, change POV.. etc) . This will make better usability with Excel addin.
In the standard Excel Add-in it is possible to use a function PALO.ESELECT to visualize an element as well as change it by double-click. But in Excel 365 it does not work - just nothing happens. It is necessary to implement an element selection in...
Enable separate control for rows and columns for "Parents below Children"
"Parents below Children" is a very useful feature. However, it applies to both rows and columns which isn't always suitable. It would be great if Jedox could simply enable separate control for rows and columns for "Parents below Children" function...