Recent Activities

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

  • Hi there, We suddenly receive this error: "Paste View failed with error: Undefined Cell Value Info : Received Cell Value Type is not defined (Error 104)" when trying to create a simple view, both through the Excel AddIn and the web interface. It related…
  • Gerwin Haas -

    Replied to the thread Creating Validation.

    Post
    Anytime ;) Good luck with your project!
  • MosheA -

    Replied to the thread Creating Validation.

    Post
    Thank you Gerwin for helping me its work!!!!!!
  • Gerwin Haas -

    Replied to the thread Creating Validation.

    Post
    Yes!!! ...sorry, I am using the German version...translation error
  • MosheA -

    Replied to the thread Creating Validation.

    Post
    thanks Gerwin !!! unprotect mean unlocked?
  • Gerwin Haas -

    Replied to the thread Creating Validation.

    Post
    Hey there, you may select the cell you would like to be unlocked when "yes" is selected. Use option Format->Conditional-Formatting->New Rule Pick the "formula"-option (in German Jedox Web it is the last selectable rule) and…
  • MosheA -

    Replied to the thread Creating Validation.

    Post
    thanks! i try this one =IF(C41="No","G","B") but when its False (B) what kind of condition i need that the system will allow me to put data ?
  • Gerwin Haas -

    Replied to the thread Creating Validation.

    Post
    You can use data validation -> pick option "list" -> "formula" -> enter in the formula field " ={"Yes","No"} " In another cell you could use conditional formatting and allow user to enter data, if the validation field is "yes". Best Gerwin…
  • MosheA -

    Posted the thread Creating Validation.

    Thread
    Hi, i try to create Validation field in Jedox Web. For Example i have a question and i want to create Valid field that give me two option: Yes and no: and If choose yes it will give me the option to write something. thanks!!! :)
  • Gerwin Haas -

    Replied to the thread Using palo.eparent in a specific hierarchy or subset.

    Post
    Hey, I personally do not like to use many subsets, due to performance lack. I think the best way is, to use PALO.ELEMENT_LIST_PARENTS(Server/ Database, Dimension, Element) You can simply exploit this formula with some php in Jedox…
  • ovo4fev -

    Replied to the thread Using palo.eparent in a specific hierarchy or subset.

    Post
    Maybe the information is available in one of the attributes on the time dimension? I had a similar problem where I wanted to get the fiscal period for a month. I used the 'Fiscal Year Element' attribute in this case.
  • Gerwin Haas -

    Posted the thread Reverting Data Entries (Undo) / User Rights.

    Thread
    Speaking of Jedox Web, there is the possibility of reverting data entries - "undo" - which is covered in this topic: LINK As this is a very powerful tool, I feel uncomfortable with "normal" users setting undo-references to cubes, locking those. Is…
  • Gerwin Haas -

    Replied to the thread Sort Dimension Elements.

    Post
    I recently faced the same issue. I had a very huge dimension looking like this: * Element * * * * Attribute * A * * * * 1 * * B * * * 2 * * * C * * 6 * * * D * * 5 * * * E * * 7 * * *…
  • OlafS -

    Replied to the thread Admin Manual.

    Post
    Thanks for the answer !
  • laloune -

    Replied to the thread Admin Manual.

    Post
    there is no manual anymore, only the knowledge base : knowledgebase.jedox.com/
  • OlafS -

    Posted the thread Admin Manual.

    Thread
    In Jedox version 5 and below, there was always an admin manual available. Is there a new one available as well ? Where can it be found ?
  • OlafS -

    Replied to the thread Dynamic Clube Slice.

    Post
    Hello, thanks this is an idea. But the Variable just needs to be set once a month and should be valid for all jobs which will be executed in the following days. I hoped, it can be set via groovy script, but this is only temporary and the conent of the…
  • d_meissner -

    Wrote a comment on d_meissner’s wall.

    Wall Comment
    too blessed, to be stressed
  • dominik_l -

    Replied to the thread Dynamic Clube Slice.

    Post
    Maybe you can look into the functionality of "Loop Jobs". The loop job can take some tabular input (e.g. Constant Table, in your case some extract that gives you list of months), loop over the rows in the table, and assign the row values to variables…
  • OlafS -

    Replied to the thread Dynamic Clube Slice.

    Post
    Does no one have an idea or a hint how to delete data in JEDOX dynamically ? Perhaps I try to explain in a different way. We have a cube "Umsatz" with e.g. 10 dimensions. One is period (month-year). I have a data source "Loeschen" (e.g. Oracle or a…