Hello Experts,
This is the situation.
Three Infobjects:
Sales Ord
System ID
Sales Ord Rpt
Compounded:
Sales Ord is compounded with system ID to make it unique
Sales Ord Rpt is a nav attribute of Sales Ord
Sales Ord Rpt = Sales Ord
Purpose of Sales Ord Rpt:
In the reporting to provide rollup on Sales Ord
Master data:
loaded for Sales Ord
Trx Data feed:
Transaction data is feed into Sales Ord Infobject & system ID.
Report:
rollup required on the Sales Ord Rpt
Will the report show the values of Sales Ord Rpt.
I know that I am missing something in here. Any suggestions appreciated.
Thanks,
Sweatha.
Hi Sweatha,
I follow you up to Trx Data Feed. Does your Trx data load into a cube or ODS? If you are using a cube or ODS then the Trx data will roll up to the aggregated level of that object. For example: if Sales Ord is the key then all records will be at that level or if Sales Ord and Sales Item are the key then the records will be at the Sales Item level. If you are loading this data into a master data object then the key is the master data object, example: all data in Sales Ord master data roll up to the Sales Ord.
Hope this helps,
Aaron Blasi
I think it will work, although I am not sure, but it should work pretty similar to for example nav attr. sales organization (in stead of Sales Ord Rpt). In this case it would also combine sales orders by sales organization and this is the behaviour you want.
Nevertheless I would personally choose a seperate characteristic filled in the update rules, if this is still possible of course.
Tom
Add a comment