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 ...
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...
Microsoft has now 10 applications as part of their Dynamics 365 portfolio. Apart from the fact that their marketshare is growing, we will need to have this to be a serious Msft partner.
In the integrator any steps with issues are removed in the illustration af the selected transformation/extract etc. If the current selected on fails, the illustration is removed and replaced by a red box. I would really like that the illustration ...