Creation and last login time of the Jedox user

Creation and last login time of the Jedox user

by Jedox 4 BeginnersNo Comments
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
Code: 1 – element not found : unspecified default write element in the dimension

Code: 1 – element not found : unspecified default write element in the dimension

by Jedox 4 BeginnersNo Comments
In this article, we will explain what the following error message means and how to deal with it: Code: 1 - element not found : unspecified default write element in dimension This error appears when the user wants to extend his cube with an additional dimension. The problem is that system doesn't know to which element to assign already existing data. If the dimension which needs to be added has more than 1 element that is where the confusion starts. In the below example, we will show how to deal with it. Like always we will use the Demo database: Dimension country is the one which should be added and extend Sales cube. As stated in the error message, there is a necessity to proclaim one default write element so all the data is assigned to it. We can do it here: In the picture above we assigned the element Europe as the Default Write Element. After this action, saving the changed layout of the...
Read More
Palo.ini standard configurations

Palo.ini standard configurations

by Jedox 4 BeginnersNo Comments
Palo.ini is a configuration file where superusers (the ones who administrate the server) could add or remove some functionalities of Jedox. It is located in data folder and on-premise could be accessed at this address <instalation folder>/Jedox/Jedox Suite/olap/data. Edit is possible if you do the right click and edit it. For this purpose, we will open it via standard Notepad. Standard palo.ini Lines starting with # are commented configurations and therefore will not be executed. The line will be skipped and the next one will be processed. More about palo.ini can be found on this link. Here are the explanations of the lines: http line represents the IP and port where jedox can be accessed.log sink is the location of the file where OLAP logs will be writtensplash-limit 1000 shows an error if splashing requires more space than the first number. 500 shows a warning if splashing requires more space than the second number. 100 Shows info if splashing requires more space than the...
Read More