Search Results

Search results 1-16 of 16.

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

  • Ok, I changed the Movement Dimension so that EOP is parent of BoP and NetMove and thus is automatically calculated. The Rule for the continuation of BoP-Values is then the following: ['Movement':'BoP'] = IF(STET()==0,PALO.DATA("","",Palo.data("","#_Calendar","PreviousDay", !'Calendar', "~"), !'Version', !'Segment', !'ProjectType', !'Provider', !'ProductCategory', !'ProjectPhase', "EoP", !'KPI'),STET()) In the Calendar I have an attribute which is filled with the previous day. Now here comes the …

  • Hi Brendan, your suggestion for a seperate cube with user based flags for access rights is completely viable, just keep in mind the maintenance effort. In your scenario, you could set up a cube with three dimesions [CostCentre, User, Measure {write, read, approve}] and just set a 1 for every coordinate where it should be allowed. On the web-report you can then use this cube as a datafilter for subsets (comboboxes, dynaranges etc.) Br Bjoern

  • Hi there, this is a general question and a cry for help at the same time . In the scenario, I have a calendar dimension (basically the standard jedox-Calendar with months and weeks in parallel with dummy elements for every month) and a movement dimension (BoP, NetMove, EoP). Currently the EoP and BoP are not set up a consolidated elements in the dimension, so that they would be calculated by aggregation. The data-load only happens for the NetMove (i.e. add & reduction). At the beginning of each …

  • Hi SaraLM, I know it's quite the late answer, but I thougt I'd put my 2 cents in. we also use for each department at least on database. Basically as soon as there would be too much mixing, or a dimension would be named the same but a parallel hierarchy is not a proper solution we create a new database. The only con that I see is the maintenance of the dimensions that vary a lot between the databases. But that can be solved with proper etl-jobs, (if existing) where everything is based on dwh-data…

  • Hi Chris, as always in life, you have several options. You could create an ETL-Job and make a Loop-Job out of it, in order to let the job run for all cubes. So make an extract on he specific Version and then make a cube load with delete. (For the loop job, a variable for the cube-name would be helpful/needed). The other Option would be to delete with the splashing assistant. Depending on the amount of cubes, it could be faster than creating the etl-Job for a few cubes for a larger number it can …

  • Did you try the macro snippet given here: knowledgebase.jedox.com/knowledgebase/examples-macros/ and define a range? knowledgebase.jedox.com/doc/7_0/macro_engine/

  • 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…9f9a282e34ec1028222a6f062 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.