I have an update rule that currently queries an ODS to get the value of a key figure and then apply that key figure to the cube the update rule is intended for.
Basically, this is the select statement I use in the routine:
select defect_quantity from table_a
where notification = notification
and notif_item = notif_item.
Since the ODS is a flat table, this works fine. However, I am having trouble figuring out how to write this same query against a cube.
Is there a way to query a cube with ABAP in an update rule? Any info or link to how to do this would be appreciated.
Thanks,
Brent