Search Results

Hello, thanks for sharing that! i meant actually, how did you find out which method of the RPC backend you have to run for that ? did you inspect the code manually or something ?

this is quite interesting ! can you please share how you find that out ? (there could be other methods are available couldn't it ?)

error 400 means that your call is malformed

unfortunately this is not possible yet :-/

you could use the rest api of integrator (soap api until 2021.2 version) for that you have to open the port 7775 so that it listen outside of jedox: knowledgebase.jedox.com/integr…ap-api.htm?Highlight=7775

you copied the code that should be used in a macro, not a groovy job. See here for the integrator scripting reference: knowledgebase.jedox.com/integr…i.htm?Highlight=scripting

using the Rest webservice of Integrator. Look here on your local installation localhost:7775/etlserver/servi…nHandling/getExecutionLog

Subset with Text Filter

Hey, where do you want to use this function ? if in a script located in /pr/custom you include the file located in ../../base/jedox.php and call one of the functions defined here: knowledgebase.jedox.com/jedox/…view.htm?Highlight=widget jedox_get_sid() gives you for instance the current session id that you can use in place of the user/password info

wtf. i searched an eternity for this thanks Ulrik Kofod

Hello, you can't use function in the left part of the "=" sign. But in the right one yes. So you should invert the logic of your rule as such: ['Product':'Laptop_XXX'] = PALO.DATA("<database>","<cube>",...,...,LEFT(!'Product',LEN(!'Product')-4),....) or using Dynamic cell reference

it's not possible. you'll have to use "@" variables since those are cross-frames / cross-reports

what about "POWER()" ? POWER(number, power) Returns the result of a number raised to a power. POWER(2,9) = 512

What if you put them between double quotes ?

hello, there are imho 2 ways to do that : 0. a "client-side" way where you query in the spreadsheet the launchdate of the unit, and use this launchdate to make a query on the data (for instance sum of launchdate+1, +2 and +3) 1. a more "server-side" solution where you pre-calculate the launchdate+3 as a measure, using for instance jedox integrator hope this helps!

Did you flag one of the elements in one of the 3 dimensions as text ? (the little "abc" icon besides the name of the element) if yes then it will be automatically casted as text what prevent from aggregating

hello, what does "it does not work" mean ? do you get any parse error from the script or doesn't it do what it is supposed to do?

depending on the number of elements this could be very long you may want to use palo_setdata_bulk instead

please post the script that you are using. What have you tried so far ?

yes you can use the SOAP API of the ETL, the wsdl file is located here: 127.0.0.1:7775/etlserver/services/ETL-Server?wsdl the port has to be open (on a standard basis it is only hearing locally) still you will have to get a valid jedox session id to connect to the webservice. So this will not be totally disconnected from jedox more information here: knowledgebase.jedox.com/knowle…pi-of-jedox-etl-from-php/