Search Results

Any SupervisionServer workers on the cells you are populated?

yes... but both cubes will be shown in Excel (the original cube as well as the mirror cube) the only solution is to educate the users or make the name of the cube clear enough to communicate to the users that the cube to use in Excel is the mirror

Hello Peer, afaik the sheet objects are read-only at the present time. Maybe this will be otherwise in the future

I don't think this is possible :-/

regex101.com your new best friend when dealing with regex

Hello, "There is a possibility to use excel add-in with read-only rights even you are an admin on Jedox Web." => No. Rights are server-side, so that they are independent from the client your user is connecting with. The Supervision-Server is also no help in this case cause afaik there is no possibility to get the client used (Excel / Web, and so on)

yes - try with the ETL

hi, can you please post a short sample of your data? do you have something like : 123.456- ?

+1 should work accordingly with a simple require('integrator.php');

hello, the sep_error instruction raises a msgbox also in the web interface (from v6 onwards)

alternatively: Source Code (1 line) it creates/appends a file in core/tmp/

Hi, another approach would be to program a macro that makes SOAP calls on the ETL API. See knowlegebase for reference

Quote from a_mueller: “ Data source is a olap cube not a relational database.” read too fast. of course my response does not make any sense

you can also round directly in the SQL query using ROUND(<value>,<decimal places>)

Hi, from the drillthrough svs script (which uses the soap etl webservice itself) : Source Code (2 lines)

hello, you can use pagination parameters, meaning the number of elements you want to display, and the number of the element from which you want to display them. see here : knowledgebase.jedox.com/knowle…e/subset-editor-tab-sort/ for instance if your subset displays the following: Trump Obama Bush Jr Clinton Bush Reagan Carter Ford Nixon Johnson and if you use 5 as number, and 5 as start then the list will be reduced to the following: Reagan Carter Ford Nixon Johnson using hyperlinks you can give…

be careful with the macros that call the ETL SOAP webservice, it requires from version 6 an authentication. and also the macro that use application()->PALO_SUBSET : the indexes of the returned array are not the sames as in the previous versions

Quote: “But this all the time requires me to prepare all the coordinates for each relevant cell.. this is quite annoying. ” did you try cubeslice? because of the performance look at the option "lock cube access during load", this may accelerate the process. And be sure to use a user with the admin role so that it will not have to check the rights prior to the load

Hello, just use a widget and get the source video displayed in it. Widgets can read and display all stuff that can be read by a browser

PHPMailer FTW sure it's pure PHP, this should work in 5 as well as 6 give us more information please. Did you put back the svs definition after install (the setup overwrites the path to your file in sep.inc.php)