Search Results

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/

another one-liner: Java Source Code (4 lines)

hello, do u use a groovy function ? if yes can you please post it ? if not what kind of functions do u use ?

yes but for that you need to open the required directory in the macro_engine_config file. See here: knowledgebase.jedox.com/knowle…cro-engine-configuration/ look in open_basedir

unfortunately there don't seem to be a method for that in the macro engine api: knowledgebase.jedox.com/doc/2019_1/macro_engine/ If possible I would have expect something like worksheet->hide()

unfortunately not. There is a feature request for that: feedback.jedox.com/forums/2204…shing-for-string-elements the solution would be to use supervision-server to get the cartesian product of all base cells and input the string on these cells

+1 good practice since this is a full standard function

rules are objects related to the olap server, whereas web reports are so to say a client for the olap server (even if a web report runs itself on a server) thus the answer is : no. if you want to make rules variable you can throw an eye to the rule templates feature

Hi, I would use the palo_datav function to query all the cells you need, iterate over the array that it delivers, and write back using palo_setdata_bulk (which ist more performant for writing back) see the php api for reference

Hello, supervisionserver is designed for this purpose. You can watch a slice of the cube and react to the change of a cell within this slice. Say, you change price, then you can fire a script that will write the price in the cube, and calculate the sales using the quantity and commit it to the cube. Now if you change sales you would write the sales, query the quantity and commit it back to the cube also please refer to the knowledgebase as well as the scripts shipped with the jedox installation