Search Results

Search results 1-20 of 41.

  • User Avatar

    If your DynaRange source is a subset, you can sort the subset by values returned by a query that you define in the data tab. You can set variables in this tab, so that this query has the same links to spreadsheet cells as your DATA functions in the DynaRange area.

  • User Avatar

    To get data from another cube you use the data function in the rule. Only the order of the dimensions in Cube A matters there. So just use the notation for the currently selected element in DEF (!'DEF') and use it as the right parameter in the data function. And since the target cube has a less detailed hierarchy but with the same elements, you don't have to worry about mapping element names or handling elements that are not in the source cube.

  • User Avatar

    Just move line 21 to the end of the function.

  • User Avatar

    Oh, I misunderstood that the job isn't starting and overlooked the obvious. The return statement ends a function and your's is not at the end.

  • User Avatar

    Just two things I'm noticing are that I don't see an initialisation of "$jobstatus" or the line "require library('integrator');".

  • User Avatar

    Oh yeah, the problem is PHP specific. By using the equal sign, you take a value from the right and put it to the left. So $project and $job need the cell value on the right side and to write into a cell it's on the left side. This also means that retrieving and writing are two different lines. And you never write range() without "->value" when it's about the cell's value. Regarding line 23, you have a different notation in PHP to pass "by reference". I think you just reassign the variable's valu…

  • User Avatar

    From the API documentation (Range -> Properties -> value): Source Code (3 lines)

  • User Avatar

    If you don't know much about PHP and you just want to start jobs, then just read section 2 in the KB article and use the two functions "integrator_start_job" and "integrator_set_job_status". Then you have to provide a valid list of job names and projects in the report, but you do not have to learn details about the SOAP calls.

  • User Avatar

    Besides and attribute filter with "[a-zA-Z0-9_]+", you could use one of the expressions that summarize glyphs ("\w" for words) or use a value filter for the attribute cube. In the latter case, you have to create the subset with the editor and exclude something like "1". Then you have to manually adjust the formula and erase this "1". It's a weird behavior that you cannot exclude empty strings in a value filter in the subset editor of Jedox.

  • User Avatar

    The idea was: Quote from SvenAndersen: “where an Attribut is empty” ^$ Quote from SvenAndersen: “or” | Quote from SvenAndersen: “have a certain text value.” ^certain text value$

  • User Avatar

    Quote from Bjoern.: “Hi, no the minus is always in front the content of the csv-file looks like this (whereas the last value/column is the value column R70110;0090000000;-92628283,33” True, you can also use a LEFT in SQL to define a CASE statement. Also, I see you have a comma as a decimal point. If this is not converted correctly, use a REPLACE statement.

  • User Avatar

    Hi, FieldTransform with Groovy is a good idea. If you cant handle it as a number, handle it as a string. Check whether the first character is a minus and remove it via code, also add a minus if there is none and the value is not zero.

  • User Avatar

    Hyperlink to unformatted files

    Seaben - - Palo Web

    Post

    You can add the files to the storage folder, adding the new file hierarchy element name (e. g. n10) as a prefix to the filename. Then add the new file hierarchy element with the same name via ETL to its file hierarchy dimension in its filegroup database. Finally add the attributes "type" (e. g. static) and "data" to the hierarchy attribute cube. The XML string for the data attribute isn't too complex. You can import a file to get the example values and the file location in the storage folder. Ma…

  • User Avatar

    Hi, have you tried a regular expression like the following in the attribute filter? ^$|^attribute text$

  • User Avatar

    1. Unfortunately, Jedox doesn't let you assign standard attributes or subsets used in views. But you can use "Ansicht entkoppeln" in the german interface to convert the ENAME functions to ESELECT and change those. 2. In the cube #_CONFIGURATION of the database you can insert Y for the element "HideElements". Then elements users have an N right for are invisible.

  • User Avatar

    You can use a calendar extract to create the list of days and use a field transform without functions to convert the tree to a table.

  • User Avatar

    Hi, Do you have a calendar table with datasets for every day? Then you could use this extract to import data: select a.name, b.date, 1 as #value from table as a, calendar_table as b where b.date between a.date_from and a.date_to

  • User Avatar

    You can give the ESELECT function two additional parameters, so that a subset is pre-selected. But the user can change the list to no subset by clicking on "more" at the bottom of the window. Is the pre-selection enough or is this also about access rights to elements?

  • User Avatar

    Hi, in "...Jedox Suite\httpd\app\base\macro\integrator.php" you got the code of the wrapper function that creates the SOAP call for the Integrator. The SVS should be able to use this method as well. Maybe you can deposit the file in "...\Jedox Suite\svs\custom_scripts" and include it in the sep.inc.php to just use the function easily in the code.

  • User Avatar

    Message Box Display via Cell Change

    Seaben - - General

    Post

    In that case I woudln't make it too complicated. Don't let the user input directly into a DATA-function, instead use a SETDATAIF-function and a button to splash the value. THen you can implement restriction checks and UI information in various ways.