Dynamic record creation in SAP BW-IP
I have a business scenario for which I need to create a planning report based on user selection of fields.
Assume that my planning query has three fields viz., Product, Period, Revenue.
User should be given with a blank layout with the drop down button for Product and Period.
User can select any Product / Period combination for which he wants to plan upon.
I cannot dynamically load the entire Product data with all the available periods.
Is there a way in which only the user selected Product/ Period alone is generated in the real time cube?
Many thanks in advance for your suggestions,