Code:104 – Not Found: cannot find requested workbook or worksheet

Code:104 – Not Found: cannot find requested workbook or worksheet

by Jedox 4 BeginnersNo Comments
Than the issue is mostlikely related to the return err, where the refresh statement is before the close and message statement: WRONG:   {return array(                 array('actn', 'refreshData'), array('actn','closeWindow'),                                             array('msg', 'STRATOS', 'Info', "Success Message is generated"),                                                );}   This can be fixed by putting the refresh after the message:   CORRECT:   {return array(                                array('actn','closeWindow'),                                                            array('msg', 'STRATOS', 'Info', "                                             array('msg', 'STRATOS', 'Info', "Success Message is generated"), "),                                                            array('actn', 'refreshData')                                                );} ...
Read More
How to create a colour picker in Jedox?

How to create a colour picker in Jedox?

by Jedox 4 BeginnersNo Comments
Jedox has a wide range of possibilities when it comes to reporting since it is working based on Excel technology. Having that in mind it might happen that sometimes you will need to add a colour picker to your dashboard. Here is an example of how it could be done. On the spreadsheet, you can put the colours which could be chosen Set up a macro which will be trigged when colour is clicked ="<a href=""#"" title='"&U5&"' style=""height:100%;width:100%;display:inline-block;color:"&U5&";background-color:"&U5&";"" onclick=""Jedox.wss.macro.exec([true,['Module1.saveColorToVariable','"&V5&"']])""> </a>" Create the macro in the Macro Editor function saveColorToVariable ( $color ) { define_variable ( 'varColor' , $color ); //return do_close(); } That is it!! In case you are not a person who has much sense for colours, there are amazing patterns of colours on this website. An example of the project can be found here. ...
Read More