Search Results

Search results 1-20 of 25.

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

  • Rules with IF AND and IF OR

    Bjoern. - - Rules


    Hi Joergen, in Cube Rules you have to think a bit like in Excel when you're combining functions. So your IF AND rule would look like this: If (AND (!'Product' == "Car", !'Color' == "Green"), xxxx, yyyy) If you are unsure of the syntax of some rules, try using the editor first. It's a lot of clicking, but you get the syntax and can do the editing in the Rule itself then. EDIT: Same applies for OR: If (OR (!'Product' == "Bycicle", !'Color' == "Blue"), xxxx, yyyy) Br, Bjoern

  • Hi chrisj, how do exactly do you let the users start the job? Is Company and Department set as variables that are filled in the integrator project? Does the second user get an error message that job is already running? BR Bjoern

  • Jedox Web Config Database Error

    Bjoern. - - General


    Can you see if all the services are still running? Seems like either one of the services is hung up. Either check by the services one by one first or do a restart of the server and see if the web is reachable again. BR Bjoern

  • Thanks Belgarion, I assume that the oracle connector in jedox is not equally developped as the MySQL-Connector for example. And I guess that I need to specify jdbc parameters in the connection. But there is no documentation on this whatsoever by jedox NLS_DATE_FORMAT with YYYY-MM-DD and NLS_LANG with UTF-8 did not help so far.

  • Hi everyone, we are in the process of migrating from MySQL to Oracle in our backend, and I am testing the connection to Oracle. I stumpled upon a few weird issues when extracting. 1. I used often a ";" at the end of the queries as a delimiter, since I tested the queries in the MySQL Workbench and now Oracle Developper respectively. With MySQL there was no issue. When using the same query to an Oracle Connection it results in an error Error in source e_rel_D_PROJ: ORA-00933: SQL command not prope…

  • Decimal and thousand separators

    Bjoern. - - Jedox Web


    If you mean by that, the seperators in Web-Reports, then yes, it is possible just like in Excel actually. Via Format cell and custom number format. Otherwise you can set the default language of the database in the modeller in the properties tab. I have never tried it yet. Would be interested however of the outcome. However, if I remember correctly, mainly the language setting in the group has an effect on that. So if you have a database with default language = English but the Groups have a diffe…

  • Hyperlinks:scrollbar=no

    Bjoern. - - Jedox Web


    Try it with a FrameSet instead of a .wss. Then it should work. I did the same workaround. The second wss-file in the Framset is just empty then. And instead of #_blank, consider using #_new for the reason given in your link Quote: “after executing the function with this target, the same report cannot be opened within Jedox in some other context for the remainder of the current session. ”

  • Hi Ulrik, thats a good idea, thanks. In the meantime I made the following work around (for future reference, in case anybody needs it) I created the following rule for each year, because the performance was extremely bad, if I had the rule for all 6 years: ['Calendar':{${Elements}},'Movement':'BOP','KPI':{'SA', 'OE', 'CC'}] = IF(STET()==0,PALO.DATA("","","","#_Calendar","PreviousDay", !'Calendar', "~"), !'Version', !'Segment', !'ProjectType', !'Provider', !'ProductCategory', !'ProjectP…

  • Hi Daveed, You need to enter the token in the connection wizard. It is needed to connect to the Web in order to see the modeller, have paste data function and so on. The security token must match the entry CFG_SECRET in the file …\Jedox Suite\httpd\app\etc\config.php more details here:

  • 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("","","","#_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: and define a range?

  • 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.