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

Becka

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.


Thanks a lot..

schpidi

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

Thanks schpidi, but i need somethin' else, near to "that's it" stuff...

Any other ideas??