Sales Analisis by Dimensions... Need a lil bit of help!

Becka
Becka Member Posts: 178
edited 2008-11-21 in NAV/Navision Classic Client
Hi Nav World! :)
I have a problem with a form Sales Analisis by Dimensions.. I wanna add there an additional filter, to filter it by Customer Posting Group. I tried to do that by myself, but it goes to waste... So, if any ideas just share it with me.
:mrgreen:

Thanks a lot..
MCSD
Attain Navision

Comments

  • schpidi
    schpidi Member Posts: 25
    an idea...

    create a new dimension named "CUST-POST-GROUP".
    in the customer table... customer posting group... validate trigger...
    copy the current value into the dimension table for the new dimension

    then you are finished, the value should be copied to your sales orders, invoices, g/l...

    i know it is not the best solution, because you have duplicate data,
    but i also think it would work :)

    kind regards,
    schpidi
  • Becka
    Becka Member Posts: 178
    Thanks schpidi, but i need somethin' else, near to "that's it" stuff... :mrgreen:

    Any other ideas??
    MCSD
    Attain Navision

Categories