Search Results

activeworkbook()->sheets('Main')->Range($range)->style = (put some css code here) example : activeworkbook()->sheets('Main')->Range($range)->style = "backgroud-color: #FFFF00"; With CSS you can make anything : underline / bold / italic /color / background-color / border ... many many things, documents yourself on css code. It could be pretty useful.

Hi ! I think it's a misunderstood, i talked about put a text into the center of a cell (vertically and horizontally). Not putting the in vertical write mode. But thanks for this I will use it for another purpose !

I want to know if it's possible to get Dimension's settings as : "Total element" "NA element" "Default read element" "Default write element" or "Default parent element". I want to know if there is a PHP function or juste a spreadsheet function that can retrieve those information. Because the php function [b]palo_dimension_info [/b]retrieve many information but not that one. Thanks

Soon I sounded about backend RPC method I tried to find a way to get all method and classes concerned by this. Then I just search on each php file that I found in the jedox file on Jedox Suite. But if you know RPC Backend and other thing like that maybe you can clarify you answer on this post : How to retrieve all warnings at the end of a job or get all warnings from an already finished job ? what did you meant by : using the Rest webservice of Integrator. Look here on your local installation lo…

You can run this PHP code it will write on the cell "L5" all task id with the task name. Just create a button assign the macro "test" on the button and click on it. PHP Source Code (17 lines)

In PHP file I found in the jedox folder they mention weird command like [["osel", 1, "a1b0"]] or [["ping"]] there is many other like [["badd"]] I don't know where I can find out about them but I'm very interested to get a list of all command with their names and descriptions.

(new Jedox.backend.RPCAsyncRqst('scheduler', 'getTree', [])).setOnSuccess([this,scs]).send();

I try to use macro to run a task from the scheduler(I know we can do it by action button, but I precisely want to do it with macro PHP). And the documentation said that I need the id of the task, I first though it was the name of the task, BUT NO. It's the id, each task has an id (according to the documentation the id should have a form like this "tn" with n a natural integer, ex: t1,t5,t9,...) and I don't know how to get one of them or all of them. I want, in fact, a way to retrieve all task id…

I forgot to reply to me but I create my own groovy script to connect the azureblob storage to jedox. Then I ask my colleague to make a Jedox Idea post about this connection. And BOOM ! 2022.1 we got a native connection for azure blob storage !

palo_cube_refresh_template_rules(string resource_id, string db_name, string cube_name)

I want some line of PHP code to insert them in my macro so I can update rule template

I don't know how to use your rest web service integrator, but I see something in the url you send to me : "ExecutionHandling/getExecutionLog" I think ExecutionHandling is a class and getExecutionLog is a method. I'm okay with that, but I have a question : How can I get the jar that contains this class ? Because I need to understand how to call the methods directly in the groovy ! I think it's should be better. And if you want to retrieve all log from a PHP macro here's the code : PHP Source Code…

Everything is in the title. I just want to add that I'm okay to use groovy for this and I'm ready to use groovy for it !

I've 2 buttons with the same macro affected to them. And I want this macro to return the id of the button I just clicked on. How I manage to do this ?

You can successfully use blob storage library by doing this : 1) download those jarfile: azure-core-1.20.0.jar azure-core-experimental-1.0.0-beta.18.jar azure-core-http-netty-1.11.0.jar azure-storage-blob-12.13.0.jar azure-storage-common-12.12.0.jar azure-storage-internal-avro-12.0.5.jar On this website : mvnrepository.com/artifact/com.azure You need to download azure-storage-blob AND its dependencies. 2) move all jar file in /opt/jdx/tomcat/lib_ext/ (path available only in jedox cloud instance)…

I try to connect my jedox integrator to a blob storage I want to know wich version of the jar file should I download ? I download 12.13.0 and it doesn't work, I think I should downgrade.

Everything in the title !

Hi ! I don't know how to do it but I think you should try one of those syntax : PHP: PHP Source Code (1 line) JS: JavaScript Source Code (8 lines)

Hi ! Here's a way to sort dimension without any attribute. And btw @Gerwin Haas your code doesn't work well with consolidate element. PHP Source Code (26 lines)

Nothing new about this subject ?