Search Results

Search results 1-10 of 10.

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Hello everyone, wanted to know whether somebody came across the same bug. When values are entered in a cube consisting of three dimensions (day, user, measure[count]) either via integrator job or manually, the values appear as string. i.e. cannot be aggregated. To double check, I did the followinig steps: - created a new cube - created a new measure-dimension and a new cube with it - created a new database Everytime the error remains the same. Did somebody come accross that error in Version 2019…

  • I found the solution. In the end the issue was with the type. (to clarify: the values did not get replaced in the beginning, it did not run into an error) When I specified in the groovy job for _input2 as float it worked. I had to split up the extract to keep it simple in the ETL, since KPI (_input1) had also a comment element with string values (_input2). But after splitting that up and putting a table union in the end, it worked like a charm.

  • Hello again, maybe someone of you ran into a similar problem and might have a hint for me. I'm struggling at the moment with a field transform. The groovy function there is supposed do the following Check if KPI (_input1) is Price -> then return value (_input2) check if KPI is amount -> then check if value = PlanSource then return PlanTarget [PlanSource and PlanTarget are both variables), else check value example: * #1 * Price * 150.0 * #2 * Amount * 1000.0 * #3 * Amount * 2416.0 $PlanSource = 2…

  • FYI since the new version reading and setting a password with ETL or in a Excel-View is not possible anymore EDIT: No Thanks to the jedox-support, I found a working solution. There is an alternative to set a password for a user. It can be done in a groovy Job Java Source Code (3 lines)In combination with a Loop Job afterwards multiple users can be set.

  • After some further research and a lot of trial and error, I've finally found a solution. If anybody has a similar need, it might come in handy. Source Code (26 lines)In the FieldTransform ("t_ft_NewUser_MailList") is already everything set up that is needed for the mail being send with the groovy job, including the MailBody (via Groovy Function with multiline strings), since I didn't know whether this function would work with HTML formatting.

  • Thanks. That one I found as well after more research now, but am so far having trouble piecing together the script, so that it runs through all new Users with a given text in HTML. I try a bit and get back if I succeed

  • Hello, I wanted to ask, whether somebody has tried to create an E-mail (with groovy) and send it to specified users out of an ETL-Job? Context: I created an ETL project that creates new users with the respective properties and groups. See image: forum.jedox.com/index.php/Atta…99a726a40186423b165c71387 I would like also to automate the Mail to those new users with a short description how to access Jedox and change the initial Password. Since the information is already in the source file and respe…

  • Hi Peter, the List can select multiple items, but can only pass one value (i.e. first selected element). I tried it as well with different version, passing it as a variable, a named range, a cell range etc., but it only returns one value, no matter how many are selected in the list. On top of this, it is unfortunately not possible yet to have a multi-select in a "normal" combobox. This is a requested feature since 2017. Selecting a range in a date picker as in other BI-frontend software is a req…

  • Hello everyone, I'm running into formatting issues with the Hichert waterfall chart and wanted to see whether anyone had a solution. The issue is with the x-Axis when the elements (here: creditor names) are too long and start overlapping, so that it gets illegible. In the normal bar charts there is an option to rotate the text of the axis. With Hichert unfortunately not. Since the source for the axis is a dynarange I cannot manually alter the text in the datasource of the chart itself. Does some…

  • Hi, I encountered already a lot of issues when using the zoom. Usually though when zooming out. Cells or columns would be shown initially in a wrong format and you had to scroll down and up again to solve that. In some reports the borders of the cells often times show (white gaps/lins in between), when using colored cell borders acroos multiple cells.