Skip to Content
0
Former Member
Oct 07, 2005 at 03:33 PM

Querying Cubes on Update Rules?

33 Views

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