Jedox for beginners Forum - Recent Topics

Measure Jedox Mobile vs Web access

Enrique — Fri, 11 Apr 2025 13:42:26 +0000

Hi,

I've built a report monitor that helps us measure how people is interacting with the reports we have in Jedox. We would love to have the capabilities of splitting the usage by access type: whether a report was accessed via Jedox Web or Jedox Mobile App.

Do you know of any script, function or log trace that can retrieve that info?

Thanks!

Report Usage metrics

Enrique — Mon, 23 Sep 2024 18:55:05 +0000

Hi!

I remember a couple of years ago there was a custom report that retrieved some "report usage metrics", such as:

- how many times a report had been accessed

- how many users accessed the report and how many times per user

Kind of an audit log for reports. Can we build something alike with the current tools?

Thanks!

90 day running average

Pierre — Fri, 09 Aug 2024 08:36:00 +0000

Hi, How do you calculate a 90 day running average starting from the previous day (and recalculated for every day of a day dimension)?

PALO.SETDATA

Gary Hall — Mon, 15 Jul 2024 12:19:35 +0000

Hi team,

I recall using this functionality a few years but I've forgotten how to set it up now. I want to have a routine using palo.setdata that can load data held on multiple rows in a spreadsheet. I recall being able to use the command whereby it would cycle through the list until it reached the bottom and then it would stop. For the life of me I can't remember how to set it up. Any ideas?

Thanks

Gary

CAGR calculation with ^ function element is not support in Jedox, but is there a way around this ?

Martin — Fri, 24 May 2024 09:15:22 +0000

CAGR calculation with ^ function element is not supported in Jedox, but is there a way around this ?

Example of CAGR formula:

CAGR = (Final Value / Initial Value) ^ (1 / Number of Periods) - 1

Migrate System Cubes

Shaan — Mon, 18 Mar 2024 05:16:47 +0000

Say I have a Client's LIVE Jedox server and have plenty of Groups and Rules with Rights assigned. How do I migrate these cubes to my test server (it's not exact Sync of the LIVE)

#_ROLE_RIGHT_OBJECT
#_ROLE_ROLE_PROPERTIES
#_GROUP_GROUP_PROPERTIES

When I download and upload to my test server I am getting this error

"At least one mapped column must be defined.Dimension 0 has no default write element defined. Use the column menu to assign a column to this dimension.At least one column must be mapped to any of the measures."

screenshot-System-Cube-upload-error.jpg

KPI Card Formula Problem

Jedox 4 Beginners — Mon, 04 Sep 2023 16:19:57 +0000

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 yesterday

When pulling through a comparison value for the same day last year I’ve written the following expression as the Data Point. The formula works when posted in a worksheet. When I tested it originally it worked but it seems to have stopped. Any idea what I’m doing wrong?

PasteViews access rights to save Global views

Martin — Fri, 18 Aug 2023 12:20:39 +0000

I have published PasteViews reports, but users including me (admin) can only save Private views.

I have tried to search on topic in Jedox knowledge base, but can find anything on where I control the access right for users to save Global PasteViews.

Could someone in this forum give me a hint, where I should search for access rights setup on PasteViews to be able to save Global views

Running average, what is the best way to set it up in Jedox ?

Martin — Fri, 14 Jul 2023 06:40:59 +0000

Running average, what is the best way to set it up in Jedox ?

Would it be via a hierarchy or via a rule setup ?

Would it be possible to advise on a rule setup on running average ?

Worksheet Variables, Initialization

Rostyslav Kolosov — Tue, 16 May 2023 12:49:38 +0000

What is the best way to initialize variables in a Jedox worksheet?