Hi,
I am currently writing a sales report using XL Reporter.
It needs to allow user to specify the document date and Item Group that they want to look at.
(a) Item Group
The only dimension that I can retrieve "Item Group" is Dimension Item.
If I create a parameter for Item Group refering to Dimension "Item", the Item Group displayed for selection is duplicated because there are > 1 item group in OITM.
Is there a way to get around it?
(b) Documentation Date
How to set up a parameter that refer documentation date? I can't use dimension "Financial Period" because the use needs to specify document date wanted not Financial Period wanted.