01-05-2023 03:05 AM - last edited on 05-25-2023 05:49 AM by JackLacava
Dear community,
I am currently using FDXExecuteCubeView in order to get only data coming from a cube view that the user is selecting into a business rule data table.
However, FDXExecuteCubeView need to specify the entity & scenario member filters which is a pain when these are parametric.
--> So I was wondering if there are other way to get the data coming only from a cube view ? I was thinking of a data adapter component but it seems that the cube view passed in those can't be parametric (ie. the name of the cube view can't be a parameter).
What are the other, possible better way, to get only the data coming from a cube view ?
Regards,
01-05-2023 08:51 AM
Another approach would be to have a DataAdapter of type CubeView or CubeViewMD, then in your rule using brapi.Dashboards.Process.GetXFDataSetInfoForAdapter to retrieve it. The returned XFDataSetInfo object has a .DataSet parameter that contains the data.
Depending on what you're doing and the data size, this could be slower than FDX calls - but if it solves the problem it might be worth the trade-off.