Creation and last login time of the Jedox user

Creation and last login time of the Jedox user

In this article we will show you how to pull the report will all your users and their creation and last login time. This could be useful in case you are wondering which of your users actually use Jedox and utilize the "Free seat" license. In case you are interested more in how licensing in Jedox works you can check it out here. As we learned in some of the previous articles details about Users can be found in the System database and _USER_USER_PROPERTIES cube. SO therefore we will paste a view with this information: As you can see both data values are stored in Serial number time of date. Example: =DATEVALUE("01-02-2015") returns Unix time stamp 1420156800, which represents 02-Jan-2015 (=60*60*24*16437 seconds since 1.1.1970). Obviously, we will need to convert these values into something more readable. There are two ways to do it: Convert from UNIX to normal date using excel formula =(A1/86400)+DATE(1970,1,1) Option to convert the value with Rule. For this option, I suggest...
Read More
Removing extra space in the Jedox report

Removing extra space in the Jedox report

Jedox spreedshets are powerfull place for your analysis. Since it is based on Excel funcionality some side effects can occure as well. One of this sideeffects is extra space in the report which cause higher memory usage. It could be identified if the report size is unusally high and performance while opening is extremelly low. (Example 250kb.) In order to fix it and decrease the size / increase the performance you will need to do the following set of actions: Click on the row under which it is nothing developed. (In this case 30th) Select A30:IV65356 and hit ENTER Delete all selected lines Tadaaaa!!! the new report is now of the proper size. More about Jedox Reports....
Read More