Search Results

Search results 1-20 of 149.

  • User Avatar

    Jedox 7 Rules bug

    jjunek - - Rules

    Post

    Hi OLAP 7 distinguishes between 0 and null. Its is documented breaking change. Processing of 0 costs much more memory and cpu whereas null is almost for free. so ['Delivering savings'] = B:IF((['Total savings in percent'] - ['Company Savings']) < null,null,['Total savings in percent'] - ['Company Savings']). Should do the job. I's also recommend to use comparison operators that do not include equality check ( >, <, != ) than others (>=, <=, ==). It is faster in new engine that was built to elimi…

  • User Avatar

    It is happening to me time to time. Excel is quite strict and disable add-ins anytime it gets the feeling there is something wrong with them. Open Excel Options/Add-Ins and in combo box Manage select Disabled items and re-enable it.

  • User Avatar

    Restrict character entry into a cell

    jjunek - - Palo Web

    Post

    It is not built-in in the OLAP, but I think you write your own php writeback event handler and let Supervision Server to start it as a reaction on typed cell value. Just search documentation

  • User Avatar

    Quote from JCO: “sible yet to other users/sessions ..because unfortunatelly the integrator package still does on” You are right. All the modifications to the database data and metadata are published for other connections at the moment the outer call successfully finishes. The modified data are visible within context of SVS custom code not from externally started tools.

  • User Avatar

    Olap server error code: 2002

    jjunek - - Palo Web

    Post

    Hi, it is error ERROR_DATABASE_NOT_LOADED check the palo.log for details. Some database couldn't be loaded for some reasons (incomplete/damaged files, memory usage) Best would be to use backup of your database or rebuild it from etl project if possible. In other case you would have to check recently modified files of your database folder and try to check what's wrong with them. All of them are text files, except few redundant binary files for better performance.

  • User Avatar

    Hi Mattheus, this seems to be some problem in excel rules editor. Make sure you are using latest version of Jedox.If the problem persists you should report the issue and how to reproduce it step by step.If you are able to type the rule formula [] = palo.marker("","",...) and you type it into Rule texbox without using comboboxes with rule fragments and press OK button you should avoid the parsing of the rule in excel integration. BTW: you should use markers only if you have performance problems w…

  • User Avatar

    Hi Nicolas, we know about problems related to this scenario and we are working on it. If it is acceptable for you you can store any negative number to represent existing 0 Headcount value ['Metric':'Headcount'] = B:IF(STET() > 0, STET(), if (STET() < 0, 0 , ['Metric':'Headcount', 'Year':offset(-1)])) regards Jiri

  • User Avatar

    Unfortunately there is no way to do this. One of the reasons is that all the cells have the same value for all users. Implementing such rule function would destroy this principle and cause inconsistency in report results and kill performance - every user would have to have his own cache. J

  • User Avatar

    What Hobee suggested is also possible. I didn't want to suggest it because it is returning 1 also for negative savings values. So if your savings are always positive numbers you can use it too. In 5.1 and 6.0 versions you can define the rule without using markers, if you have no other rules in the cube using markers. ['active projects'] = B:['savings'] / ['savings'] would do the job. Actually in version 6.0 the version "['active projects'] = B: IF(['savings'] > 0,1,0)" whould be as fast as the "…

  • User Avatar

    Hi, I think in hierarchical dimensions, first top element is chosen as default. In flat dimension first element is selected. You can edit the dimension this way to get pre-selected element. We are aware of this requirement and we are working on it. Jiri

  • User Avatar

    Talking about performance

    jjunek - - Palo OLAP Server

    Post

    Your approach to create more cubes with less dimensions is good practice These cubes are usually connected via rules if needed. Only in case of performance problems these individual cubes can contain redundant data from other cubes to eliminate rules. If you want to go this way from beginning and load data directly to multiple cubes it's ok. Cubes with aggregations only with 8 dimensions and less than some hundreds of millions of loaded cells is the simplest scenario working well on 8 core cpus …

  • User Avatar

    Talking about performance

    jjunek - - Palo OLAP Server

    Post

    Hi Matheus, the number of cells in the cube is unimportant. 10^13 you have in your cube is nothing unusual. It depends on sparsity of data - how many base cells you load into the cube. I doubt it will be more than few millions. Other aspect is how general will be your cube rules and how complex calculations they will do. Last week I was helping with performance issues in cubes with 10^27 cells. Jiri

  • User Avatar

    Hi, if I understood you right you have to use B: rule ['active projects'] = B: IF(['savings'] > 0,1,0) then consolidation over other dimensions does the job Jiri

  • User Avatar

    Hi, was it data driven modelling? jedox.com/de/ressources/jedox-5-1-data-driven-modelling JJ

  • User Avatar

    check OLAP server log. Port is also printed there and your proxy settings Jiri

  • User Avatar

    There are functions palo_subset and Palo_subset in php or palo.subset/palo.dfilter in excel for that. They are much faster than MDX especially in 6.0 Jiri

  • User Avatar

    JEDOX 6 big problem !

    jjunek - - Palo ETL

    Post

    Should be fixed and available soon as hotfix or SR1

  • User Avatar

    [PHP Palo] palo_getdata_export: limit ?

    jjunek - - SDK

    Post

    You have to call the export function in a loop. I don't know the .NET params exactly, but for PHP there was a parameter $first_path. In first call of the export you leave the parameter empty, for all subsequent calls you use coordinates of last line from previous bulk. Repeat until you get less records than $max_rows. Source Code (2 lines)

  • User Avatar

    ['Unbooked Hours'] = max(0,['Contractual Hours'] - ['Actual ']) or ['Unbooked Hours'] = B: max(0,['Contractual Hours'] - ['Actual '])

  • User Avatar

    Regular user (Load to Cube) slow

    jjunek - - Palo ETL

    Post

    Hi laloune you have to find balance between performance and level of details you control rights on. One extreme is to load data as admin for fastest process typically used for etl loads. Second extreme is to use rules to calculate per cell access rights, typically used for manual writebacks. You cannot have fast load while using detailed dynamic access rights. For preventing of overwriting some data you can use locking functionality. But it will also slow down etl loads including admin users. De…