Jedox 4 Beginners

Hi @einfante, So far, i dont see the other way but seems like to be on the roadmap. What you can do is to set them up in combo boxes and then hide them.

Hi Enrique, Here’s the approach I would take: First, I would create a cube with the following dimensions: Reports Date Users (optional) For each report, I’d set up a macro or an "on open" action tha...

hi Pierre, I would do it this way but feel free to modify my idea: I will create a parallel hierarchy for dates which will have suffix _AVG90 (Example: 2024-08-26_AVG90) Go to Integrator and add two ...

@shaan007 In that case you can just try to import the file via Connection to Excel and continue with the Integrator. Maybe this helps?

Hi Shaan, I would suggest that instead of exporting/importing these cubes, you go to the test system ETL and create a connection to the System cubes of Prod, create 3 cube connections to these : #_RO...

Could this be a solution? =TEXT(TODAY()-366,"yy-MM-dd")

I'm new to using Canvas and have set up a KPI card to capture daily sales data. The information for the current value pulls through ok and I've used an expression for the day dimension to default to y...

Hi, with the role object "sub-set view" "D" users will be able to save global Views

Hi Martin, try this out: ^((?!_R18).)*$

Hi Martin, you can do it via rule. I am attaching a picture of how it can look. Running-Averages.PNG SO whenever you add a number, the base day date average is recalculated. I hope this is what you...

Hi Rostyslav, there are different ways. You can do it via macros: function __open(){ define_variable('vCountry',$vCountry);} or you can initialize the on open Workbook event: when you open the empty ...

Hi Rostyslav, In case your instance is on premise i suggest to follow this order: JedoxSuiteHttpdService JedoxSuiteCoreService Jedox Suite Tomcat Service JedoxSuiteMolapService For cloud instance I ...

With the current 2023.1 version you can use action buttons with many functions plus you can create a chain of actions in the same button:

Hi Adis, did you try something like this C:\Users\adis.prijic\Documents/Desktop/OSA.xlsx for the File Name?

Hi Adis, could you upload some screenshots of errors so we can check the reason behind them? Thanks