Extract values from cube with inRange and date

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

    • Extract values from cube with inRange and date

      Good morning from Cologne,

      I work with Jedox for two month now and I think it's pretty cool.

      But sometimes questions are coming up which cannot be answered by manual or knowledge base.
      My Problem is extracting values from a cube for a period of one year or month.

      Time dimension looks like '01.01.2014,01.02.2018...….01.12.2020'
      If I want to extract the data for october/november 2018 I tried "inRange" with [01.10.2018,01.11.2018]. That's what the knowledge base told me.

      But if I fire the statement by data preview I get the message

      "Configuration Error in extract C_SalesCube: Range Definition [01.10.2018,01.11.2018] contains non-numerical values"

      Ok, the message seems to be clear but the knowlegde base neither any Manual told me that inRange is for numeric values only.

      Can anybody help me with this issue.

      Thanks in Advance, Alex