Search Results

Search results 1-18 of 18.

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Hi ! Very interesting function but I don't think I will use a widget because my first goal is about hidding of showing a button if there is hold on a certain cube. So I can't use those function. But I think you could help me to find where those function are defined, maybe I can call them if they are in sencha library. ! update: Those function are in PHP and are define in a php file call jedox.php located in a folder called base(on the localhost). I will try to see if it's possible to import it !

  • Hello ! I need to use this function : palo_cube_holds this function use the ressources_id in the parameter. This id is provide by the function palo.init, but this function works only if the user put directly his password in the code. It's very dangerous to do this type of practices and I want to know if there is any possibility to get the ressource_id that allow me to get rid of the palo.init or a way to retrieve dynamically my user password without write directly in the code. By the way if you …

  • This function doesn' work like I want because when I request =PALO.EPREV("localhost/Demo","Regions","Europe") it return a consolidate element and not a base element. I want to have a way to retrieve base element with the top element or with nothing.

  • Hello ! Is there any possibility to request the first leaf of a dimension ? Even if I change the dimension architecture I want to retrieve the name of one of the base element, any of them. Is it possible ?

  • Here's the path : /user_data/data/etl_data/files/ EDIT: That's not the path in fact. You have to request the support to ask them to fix this problem for you, and they will fix it on each instance of jedox your using. I'm using 2021.1

  • Hello ! I using the new cloud architecture. And I have a report with a widget that allow me to upload file on cloud serveur and then once the file is upload on the server I can use it on an ETL job. But with the new architecture I can't, because I don't know the path to access to the folder that use file in ETL job. The ETL job throw me an error : File /opt/jdx/tomcat/webapps/etlserver/data/files/my_file_test.xlsx does not exist. If this file is created in a load, the warning can be ignored. Aft…

  • I tried to use a stored subset with a variable(a range named) and it work pretty well when I try to paste the subset on the sheet. But when I try to use the subset in a PALO.ESELECT it doesn't work and jedox returning a error message like this: "Code: 1 - Variables missing during subset calculation, subset probably changed meanwhile." What should I do ? PS: it work on excel add-in but not on jedox web

  • (thread moved to Jedox Web)

  • Hello ! Border option is about cell's border, in my problem I just want a vertical text alignment. I will show you with excel check the attachement as an example.

  • IIPT = Is It Possible To I want to have vertical-align on a cell but even with a macro that change the style and the format of a cell it doesn't work ! Here's the code : PHP Source Code (4 lines)I add background-color to show you that macro react to background-color but not to vertical-align... Why ? Is there any solution about that ?

  • Download Excel File

    Zarcoff - - Jedox Web

    Post

    I think it could be possible if you do it with a widget. Because widget could retrieve data from the sheet(you can place on the sheet the data for the csv) then you can code a little of php to get construct the csv file(I think) and then propose to the user to save the file. I didn't check if it possible but I think it's a good clue to solve this problem best regards

  • Mmmmh very interesting way to see things ! I will try it ! Thanks for your advise !

  • Ok I found a solution ! First you have to define your array colors, it's an array with color code in hexadecimal like this ["#51b5ce", "#89c733", "#54a329","#2f7ed8", "#0d233a", "#8bbc21", "#910000", "#1aadce", "#492970", "#f28f43", "#77a1e5", "#c42525", "#a6c96a"] and then you have to put series.color at null for each series. Here's my "Diff" that show all modification bring to the chart json: JavaScript Source Code (33 lines)you can copy paste it on your diff then make the modification on the …

  • Hi ! Thanks for your answer, but when I talk about palette I mean those palette in Series "tab" on cluster column chart for example: Shoal, Hydro, Copa, Office, Apex, Aspect, Chaplin and CUSTOM. But the custom one return nothing, and each Time I try to use it it desappear when I click "OK" to validate my change in the chart. On Highchart library I tried to search something about it but even the attribute "colors" placed in the root returning an array of colors correpsonding to a palette doesn't …

  • Hi ! I want to change the custom palette to change the color of any of my chart. I don't really like the default palette, there no many choice and they are pretty ugly. So what should I do to change the custom palette ? best regards

  • Data from Spreadsheet -> Widget

    Zarcoff - - Jedox Web

    Post

    Hi ! When you create a Widget on the source tab, you can select range. You can choose to point your range on something you know like dynarange or a range with all the parameter you want. You can also use a formula and use a Name(named range) to define your range more dynamically. You can also use a subset as source, you can just copy paste the dynarange's subset and here we go ! To use the data in your widget you can use the array "params" on your js code. best regards

  • Traverse a range in PHP

    Zarcoff - - Jedox Web

    Post

    Hello ! What do you want ? Do you want to iterate on cell values or on cell ? Because both are possible but this is different level of difficulty. But in your case I think you just want to iterate on cell VALUES. It's interesting to iterate on cell when you need to change for example the style or the format of each cell or check something that define the cell other than the values. Anyway. In your case (cell values): activesheet()->range("D8:Z8")->value , it return a matrice/multidimensional arr…

  • [IIPT] = [Is It Possible To] 4maq.png(img1, jedox view) ejm5.png(img2, user view) Hello, i will first explain my goal: When I use jedox as user I want to change a cell's background color when I change the value of a cell in the same line. To indicate which line as changed. The img2 represent the view of a user and normally the line with the 0 is the line where I do all my test(none of them works :/). The line with the zero is fillable by the user because all the cell are unlocked. When I change …