Search Results

Search results 1-9 of 9.

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

  • Report query

    akapoor29 - - Jedox Web

    Post

    Hi I have to create below kind of view, where I have an item dimension, Item has attribute called called size and range. I have too aggregate the range, sizes belonging to that range and then quantities of item sold in that range. YfcEaoEaROMAAAAASUVORK5CYII= How can I approach. Do I have to create parallel hierarchies in item dimension for size and item below it, or is there any easier solution? Thanks

  • Sort on report

    akapoor29 - - Jedox Web

    Post

    Thanks

  • Sort on report

    akapoor29 - - Jedox Web

    Post

    Hi, Thanks for you response. If I sort by value in Dynarange, how can I select the week's cover column only? I have calculated Week cover on the report

  • Sort on report

    akapoor29 - - Jedox Web

    Post

    I have created this report where i have used dynarange for item and calculated Week's cover on the report by SOH/Demand Plan. How can I now sort the weeks cover Colum in descending order. I searched that excel has SORT function but saw that Jedox doesn't support SORT function. I cannot use dynarange sort as I am using different sorting criteria for item there.

  • In my report I am taking Item as dynarange and the data comes from two cube- Stock on hand from one cube and Forecast numbers for the item from another cube. I want all those item that have Stock on hand+forecast>0. In Data tab for item dynarange if I select Stock on hand cube and do slice operator as <>0 then only those items come who have stock on hand not equal to zero but I also want those items that have forecast not equal to zero. How can I get this sorting from other cube too?

  • I have to build a report where my cube structure is ( day, measure, location, SO Number, Store, Customer, Item). I am using day, location, customer selection as combo box and I want that based on selected date, I should have all the SO number (Sales orders) as a dynarange, then there are various stores too, so every SO should have Stores below it and then after, items for that particular store. I can get SO Number and item below it or store and item below it but I am unable to get the view I wan…

  • It would be good to have a PALO for calculating values based on date range. Date range as date start and date end and palo should calculate sum values between date start and date end.

  • Palo.data.avg on a date range

    akapoor29 - - Jedox Web

    Post

    Hi sebkos, Sorry I don't have answer for you question, but I want to use similar mechanism related to date range. I am not getting how to use AVG function. My query is- Here a user selects start and end date and based on that it should populate the number on the committed order+Back order column. I am using start date as @varStart and end as @varEnd. I want to sum the numbers in between two selected dates. for example- SO(sales order) arriving at different dates in between two selected dates and…

  • I am stuck at a place here in my report. Please let me know if I am heading in correct direction. Here a user selects start and end date and based on that it should populate the number on the committed order+Back order column. I am using start date as @varStart and end as @varEnd. I want to sum the numbers in between two selected dates. for example- SO(sales order) arriving at different dates in between two selected dates and i want to sum all the numbers.example- based on the input dates in pic…